how to shift the rows to cols?
eg:
i have like
field1 field2 field3
10 20 20
this should be displayed as
field1 10
field2 20
field3 30
(without the obs col)
how do this?can i use transpose or tell me suitable way to
do this?
Answer Posted / haritha
by using proc transpose procedure
ur data should be like this
data hyd;
input a$ b$ c$;
datalines;
field1 field2 field3
10 20 30
;
run;
solution will be like this:
proc tranpose data=hyd out=mum;
var a b c;
run;
proc print data=mum noobs;
run;
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
what is the basic structure sas administrator? : Sas-administrator
What does P-value signify about the statistical data?
What do the PUT and INPUT functions do?
What is the difference between match merge and one to one merge?
What is a method to debug and test your SAS program?
How can you create a macro variable with in data step? : sas-macro
what are some good sas programming practices for processing very large data sets? : Sas programming
What is the function of output statement in a SAS Program?
What is the use of function Proc summary?
What is PDV?
if you were told to create many records from one record, show how you would do this using array and with proc transpose? : Sas programming
what is intially documentation in sas?
explain the main difference between the nodup and nodupkey options? : Sas-administrator
it will become easy if uuu provide website linkssss and list of consultanciessssss
how can you create zero observation dataset? : Sas programming