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
How would you define the end of a macro? : sas-macro
Difference between informat and format?
how can you import .csv file in to sas? : Sas programming
What are the five ways to do a table lookup in sas? : sas-grid-administration
I need level 2 to 5 sas using companies in india
how does sas handle missing values in procs? : Sas programming
What are the data types in sas?
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?
Name some categories in sas 9? : sas-grid-administration
Hi, If anyone has base SAS certification dumps, please share.
What makes sas stand out to be the best over other data analytics tools?
What is factor analysis?
What is the difference between class statement and by statement in proc means?
Mention how to limit decimal places for the variable using proc means?
what is the different between functions and procs that calculate the same simple descriptive statistics? : Sas programming
