Data_null _; all content in this blog is original. If you reprint it, please indicate the source blog. csdn. netmyhaspl
Data _ null _; all the content of this blog is original, if reproduced please indicate the source http://blog.csdn.net/myhaspl/
I. Count FunctionsIn actual statistical applications, the number of occurrences of observed values needs to be calculated. This function can be implemented through the count function. It has three forms and functions:
Form you used
The general form of Proc tabulate: (the subject is different from the freq process. Here is the table statement, not tables)
1 proc tabulate format = options;/* format = option to change the format of all cells in the table */2 var analysis-variable-
Contents process (view dataset attributes)
1 ProcContents data=Data-Set;2Run;
Label
1 /* there are two types of labels, but cannot exceed 256 characters */ 2 label = data - set (define a label for the dataset)
Proc Printto log= "./xx1.txt" new;
Data temp;
Input a b C;
Cards
A 1 8
A 2 7
A 3 8
A 4 9
;
Run
Proc Printto log= "./xx2.txt" new;
Data temp1;
Set temp;
f= lag (c);
D= dif (c);
Run
The lag (Var) function is to move the variable in
/* Way One */
%let x=5; %let y=test; %put &x &y;
/* Mode two */
Data _null_; Call Symput (' x ', 5);
Call Symput (' y ', ' test ');
Run %put &x &y;
/* Mode three */* if there are multiple records, only the value of the first bar */
Proc SQL Noprint;
1: Macro definition in program runCall Routines -enable you-transfer information between an executing DATA step and the Macro Proces Sor.You can use the symput routine to create a macro variable, and to assign to, variable any value, is Availa ble
First, objectives
Display all rows, eliminate duplicate rows, and limit the number of rows displayed
subset rows using other conditional operators and caculated values
Enhance the formatting of query output
Using summary
be used in conjunction with the "Storage space" feature to be mentioned later in this article), which will be implemented later. 3. Storage space Storage space is a new feature in Windows Server 2012 that provides an efficient and convenient storage virtualization solution. In simple terms, it can put a standard storage device into a storage pool and virtualize it to create a virtual disk called storage space. Currently compliant storage devices include disk or
. The core Hyper-V Server for Windows Server virtualization has high requirements for storage networking, and here are a number of options: While Hyper-V virtual machines can be deployed in Das, Nas, or SAN storage, for high availability, SAN-based is the most common (iSCSI-based IP San and FC-channel-based FC San), and you can now choose a file server cluster-based Hyper-V over SMB (a small network that can be used in conjunction with the "Storage space" feature to be mentioned later in this ar
Redundancy of storage spaceIn the high-availability architecture of the storage controller server, there is a difference in the degree of redundancy that is achieved by using a different number of JBOD or different ways of storage space layout. If you cannot turn on storage box-level redundancy by using two storage bins, so you cannot implement JBOD storage-tier redundancies, you must use three
, 1/3 of the disk capacity will be used by the backup checksum, and when there are four disks, 1/4 capacity is required as a backup, To minimize the worst-case incidence. When the number of disks increases, the disk capacity consumed by the backup checksum on each disk decreases, but the risk of disk failure increases at the same time, but with two disk failures, data recovery is not possible.Jbod,jbod (Just bundle of Disks) is a simple disk bundle.
With the two years of the SDDC (software-defined data center) becoming more and more hot, software-defined storage (SDS), which is an important building block, is increasingly being used by various industries and data centers of all sizes. Microsoft, one of the SDS vendors, faced this cake of course not to the people, starting with Windows Server 2012, Microsoft grandly launched his SDS solution--storage Space. This version also needs to be built on a shared disk enclosure (
through the adapter interface of the SAS interface, which is represented by the logical unit number of the logical unit number.
Narrowband: 8 interfaces, 7 targets
Broadband: 16 interfaces and 15 targets
2) The RAID Controller must be used by a system driver. You can set it in the BIOS and connect it to the RAID disk array through an adapter.
3) The RAID Controller has a CPU and memory to accelerate. In addition, it sets the power mode to enable emer
great potential of the technology was enough to help the Windows Server system support a sizeable storage array.
For example, 16 devices that use Windows Server (divided into four storage instances) can form a 64-node cluster with a raw storage capacity of up to 15PB. Each server is connected to a JBOD array of 60 4TB disks (or servers with an individual capacity of 960TB) through SAS (that is, serial att
SAS9.3 64bit version Installation GuideWith a new computer, after installing the original SAS9.2 , the enhanced editor has been unable to load, tried various methods and wasted the day. Helpless download SAS9.3 version, but the installation is not smooth, of course , the main problem is the JDK , referring to the Netizen's article, successfully completed the installation, another note operating system for Win7 version. Original address:http://f.dataguru.cn/thread-161588-1-1.html1, the main proc
replicasserver-to-server allows synchronous and asynchronous replication between two independent servers using storage spaces with shared SAS storage, SAN and ISCSI-connected LUNs, and local drives. It is managed through PowerShell and Server Manager tools, and requires manual intervention to failover.650) this.width=650; "Src=" https://i-technet.sec.s-msft.com/zh-cn/windows-server-docs/storage/storage-replica/ Media/storage-replica-overview/storage_
typeParallel:IDE:133MB/S (RARE)SCSI:640MB/S (RARE)Serial:sata:6gbps, approx. 750mb/s (commonly used in home PCs)sas:6gbps (more for server)usb:480mb/sRpm:rotations per minute (rpm per minute)HDD Type:Mechanical HDD (HDD): Hard disk drive, traditional HDD.SSD: Solid state drives, hard drives made of solid state electronic storage chip arraysDifference:1, performance: SSD in shock and drop, transmission rate, power consumption, weight, noise significan
"TechTarget Chinese Original"Microsoft introduced storage Spaces Direct in Windows Server Technical Preview 2. This feature expands local storage to a highly available (HA) storage System.For example, Storage Spaces Direct supports insertion into the PCI Express bus using low-cost, low-performance, high-capacity SATA-like drives and solid-state devices such as SSD and serial storage architectures. This approach is known as nonvolatile memory Express (NVMe) or nonvolatile Storage Control Interfac
of the hard drive transmission speed are:Ultra-ata33Ultra-ata66ultra-ata100 [ultra-ata133SATA hard Drive transfer speeds are:ultra-ata150the difference between a SCSI interface and a SAS interfaceSAS (serial Attached SCSI), serial attached SCSI, is the next generation of SCSI technology, and is the same as the current serial ATA (SATA) hard drive, using serial technology to achieve higher transmission speed and improve internal space by shortening th
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.