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 SAS? What are the functions does it performs?
What are symget and symput? : sas-macro
What is the basic syntax of a sas program?
Mention the category in which sas informats are placed?
explain the difference between proc means and proc summary?
What are the data types that sas contain?
For a user to have access to a standard workspace server, is internal authentication alone is sufficient? : sas-grid-administration
What is the difference between order and group variable in proc report?
Explain the difference between nodup and nodupkey options?
what is the Population you used in your project, is it ITT or PP?
Describe the function and untility of the most difficult SAS macro that you have written.
What is the difference between nodupkey and nodup options?
what is change analysis in sas di ? : Sas-di
Mention some common errors that are usually committed in sas programming.
Do you need to know if there are any missing values?
