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 does proc print, and proc contents are used for?
what are some differences between proc summary and proc means? : Sas programming
what is program data vector? : Sas-administrator
How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?
what are some problems you might encounter in processing missing values? In data steps? Arithmetic? Comparisons? Functions? Classifying data? : Sas programming
what is operational data and operational system? : Sas-di
I have a SCD Type 2 Dimention for Location In which A Sales Office in Having two Surrogate Keys just because of the change in it's Sales Group. SKey SalesGroup Sales Office BeginDate EndDate 280 SG1 SO1 01APR2000 01APR2010 281 SG2 SO1 02APR2010 31MAR2999 Now while loading the Fact, the Lookup ir returning SKey 280 for records before and after 01APR2010. I am not able to give WHERE condition in the Lookup Properties (TranDate between BeginDate and EndDate). Please help.
How do you convert basic cube to transaction cube and transaction cube to basic cube?
what is ae onset date n what is RDS
Describe the function and utility of the most difficult SAS macro that you have written?
What do the SAS log messages "numeric values have been converted to character" mean?
Mention what is PROC in SAS?
what is the difference between unique key and primary key? : Sas-di
name several ways to achieve efficiency in your program? : Sas programming
what is sas business intelligence? : Sas-bi
