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
If you were told to create many records from one record, show how you would do this using array and with proc transpose?
How to create a permanent sas data set?
what are validation tools that are used in sas? : Sas-administrator
How long can a macro variable be? A token? : sas-macro
What is the sas data set? : sas-grid-administration
How would you define the end of a macro?
Why double trailing @@ is used in input statement?
How to convert a numeric variable to a character variable?
how to generate the test data in sas without input data? : Sas-administrator
What are the difference between the sas data step and sas procs?
how to do user inputs and command line arguments in sas?
Name types of category in which SAS Informats are placed?
Explain the difference between using drop = data set option in set and data statement?
What are the functions used for character handling?
Intern stastical programmer written test