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
- 8642 Views
- CMC, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / luclyl
proc transpose data=hyd out=mum (drop=_NAME_);
var a b c;
run;
| Is This Answer Correct ? | 7 Yes | 2 No |
Answer / 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 |
what is proc Index? and what is proc document?
What is LAG function?How is it used? can any one explain
3 Answers TRE, Verinon Technology Solutions,
What are types of transport files?
2 Answers PRA Health Sciences, Quintiles,
explain what is factor analysis? : Sas-administrator
What is the difference between where and if statement?
what is enterprise guide? What is the use of it? : Sas programming
what is the difference between proc report and proc format?
Which date functions advances a date time or date/time value by agiven interval?
Do you need to rearrange the order of the data for the report?
Can you excute a macro within a macro? Describe.
What is the difference between nodupkey and nodup options?
in the flow of data step processing, what is the first action in a typical data step? : Sas programming
Teradata 
