PROC TRANSPOSE in SAS University edition DAY 27 Part 1 || PROC TRANSPOSE VERTICAL TO HORIZONTAL скачать в хорошем качестве

PROC TRANSPOSE in SAS University edition DAY 27 Part 1 || PROC TRANSPOSE VERTICAL TO HORIZONTAL

Transpose procedure: PROC TRANSPOSE Used to transpose the data or reshape the data Converting the data from vertical data into horizontal data format or convert data values as variable names this process can be called as normalization. Converting horizontal data to vertical data format or convert variable names as data values this process can be called denormalization. Vertical dataset we call as long Datasets: A "long" dataset contains more than one row per subject, and uses a unique ID to identify each subject Statistical software packages typically require data to be in "long" format for procedures like: Time series Mixed and multilevel models In SAS, the TRANSPOSE procedure can perform simple transposes, wide-to-long, and long-to-wide restructuring of datasets. Syntax: PROC TRANSPOSE DATA=Dataset-name OUT=New-dataset-name options; ID variable; VAR variable(s); BY variable(s); RUN; PROC TRANSPOSE tells SAS to execute a transpose procedure on dataset Dataset-name. The OUT keyword says that the transposed dataset should be created as a new dataset called New-dataset-name. BY statement: It allows you to transpose data within the combination of the BY variables. You can sort the variables with PROC SORT. ID statement: It requires only one variable which variable values converted as variable names. VAR statement: It requires variables, which variable values converted as observation or data values. If you do not include a VAR statement, the procedure will transpose all numeric variables that are not included in a BY statement or a ID statement When Transposing data from Vertical to Horizontal, we need all the three statements, ID, VAR, and BY. When Transposing data from Horizontal to Vertical, we need only two statements VAR, and BY, no need of ID statement Options in PROC TRANSPOSE: The NAME= option allows you to change the name of the NAME variable. It is the name of the variable that is transposed. The PREFIX= option allows you to change the prefix "COL". It is prefix to the transposed values. PROC TRANSPOSE DATA=Dataset-name OUT=New-dataset-name options; ID variable; VAR variable(s); BY variable(s); RUN; PROC TRANSPOSE DATA=Dataset-name OUT=New-dataset-name Name=Variable- Name Prefix=prefix-name; ID variable; VAR variable(s); BY variable(s); RUN; Using Dataset options: Drop We can eliminate this variable with DROP= option, Keep, Rename PROC TRANSPOSE DATA=Dataset-name OUT=New-dataset-name DROP=variablename; ID variable; VAR variable(s); BY variable(s); RUN;