Q)How to create many records from one
record?
A)using
arrays and with PROC TRANSPOSE
Q)How would you create a data set
with 1 observation and 30 variables from a data set with 30 observations and 1
variable?
A)Using
Proc Transpose and also do with the SAS arrays
Q)What is the use of ID Statement in
proc transpose?
A)ID statement names the column in
the input file whose row values provide the column names in the output
file.There should only be one variable in an ID statement. Also, the column
used for the ID statement cannot have any duplicate values.
Q)What is the use of var statement in
proc transpose?
A)VAR
statement specifies which variables’ values are to be transposed; can be
character and/or numeric variables; if VAR is omitted, Transpose transposes all
numeric variables.
Q)What is the use of By statement in
proc transpose?
A)BY
statement names row-identification variable(s) whose values are not transposed;
it requires a preliminary
No comments:
Post a Comment