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
- 8752 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
Name and describe few sas character functions that are used for data cleaning in brief.
What is program data vector (pdv) and what are its functions?
What are the data types does SAS contain?
What are the difficulties u faced while doing vital signs table or dataset?
what is the basic structure sas administrator? : Sas-administrator
what is hash files in sas and why we are using this one in sas?
why is sas considered self-documenting? : Sas programming
What is a method to debug and test your SAS program?
how will you locate the sas platform applications? : Sas-bi
How are numeric and character missing values represented internally?
how do you pull data from equifax?tell me the process?
How can I remove header from output data set?
Which date function advances a date, time or datetime value by a given interval?
what are 5 ways to perform a table lookup in sas? : Sas-administrator
what is the difference between unique key and primary key? : Sas-di
