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 can you create zero observation dataset? : Sas programming
What do you know about sas data set?
how does sas handle missing values in procs? : Sas programming
Enlist the functions performed by sas.
Enlist the syntax rules followed in sas statements.
What is PDV?
what is the difference between unique key and primary key? : Sas-di
Hi,by usining ptf how we have to combine (likr merge)10 datasets at a time in the oracle database(and write a macro code also)?Like this i have a douts a lot if you dont mind may please send one text mail for me(madhusudhanap16@gmail.com)?
What do the mod and int function do? : Sas programming
How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?
How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?
what is sas application server, database server, sas olap server and sas metadata server? : Sas-di
What is interleaving in SAS?
What are the differences between sum function and using “+” operator?
How to limit decimal places for variable using proc means?
