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 maximum and minimum length of macro variable
What are the new features included in the new version of SAS Programming Language?
What is PROC in SAS?
What is by-group processing?
what are the categories that sas informats are used to the place the data? : Sas-administrator
Do we follow ADAM in analysis dataset development?How? Usually which version? Why is it necessary?
What would be the value of month at the end of data step execution and how many observations would be there?
What are common programming errors committed in sas
Explain what is data step?
what are the best practices to process the large data sets in sas programming? : Sas-administrator
If you were told to create many records from one record, show how you would do this using array and with proc transpose?
what is sas database server? : Sas-di
What are the implications?
what other sas products have you used and consider yourself proficient in using? : Sas programming
hi all, I need the SAS DI DUMP(A00 260) for attending the certification. if any one have, pls provide it.Please Email to vrpotluri@hotmail.com. Thanks - Ramana