Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sarath
We have two different type of TRANSPOSE: “UP” and “DOWN”:
“UP” transpose change rows of a dataset to columns, whereas
the “Down” transpose change columns to rows. We either
use "UP" or "DOWN" tranpose depending upon the requirement.
Whenver we use PROC TRANSPOSE we need to ask some questions
ourselves, since visualizing the PROC Transpose syntax is
not that easy:
To develop the PROC TRANSPOSE syntax we need to know the
answers to the above questions,
1) Which variable/variables need to get transposed?
A) Whatever the variable we mention in the ID statement.
2) What are the variables that need to stay same as in the
input dataset?
A) Variables that are included in the BY statement.
3) Which variables values need to become the values for the
transposed variable.
A) Variables that are included in the VAR statement.
read more at...
http://studysas.blogspot.com/2009/03/proc-transpose-how-to-
convert.html
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
What is the use of the %include statement?
How substr function works in sas?
What is the maximum and minimum length of macro variable
Can you explain the process of calendar?
Give e an example of..
What are the ways in which macro variables can be created in sas programming?
how to debug and test the sas program? : Sas-administrator
what is sas metadata server? : Sas-di
What are the 3 components in sas programming?
how can you put a "trace" in your program? : Sas programming
what is intially documentation in sas?
What is the length assigned to the target variable by the scan function?
What are the difference between sas functions and procedures?
what is the difference between calculating the 'mean' using the mean function and proc means? : Sas programming
How do you control the number of observations and/or variables read or written? Approximately what date is represented by the SAS date value of 730?
