Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 3 Answers
- 8624 Views
- CMC, I also Faced
- E-Mail Answers
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
How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data?
What are the difficulties u faced while doing vital signs table or dataset?
What is the difference between nodupkey and nodup options?
AE datasets names? how many types?
where are dashboard components are created and maintained? : Sas-bi
State the difference between INFORMAT and FORMAT ?
What do the mod and int function do? : Sas programming
what is business intelligence? : Sas-bi
What is the general format of function in sas? : sas-grid-administration
hi all, I need the SAS DI DUMP(A00 260) for attending the certification. if any one have, pls provide it.Please Email to vrpotluri@hotmail.com. Thanks - Ramana
how sas deals with business intelligence? : Sas-bi
Explain substr function?
What system options would you use to help debug a macro? : sas-macro
What is a method to debug and test your SAS program?
what is data integration? : Sas-di
