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 / luclyl

proc transpose data=hyd out=mum (drop=_NAME_);
var a b c;
run;

Is This Answer Correct ?    7 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What can be the size of largest dataset in SAS?

698


explain the difference between proc means and proc summary?

650


How can sas program be validated?

563


How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?

1565


what is star schema? : Sas-di

633






What Proc glm does?

595


what are some problems you might encounter in processing missing values? In data steps? Arithmetic? Comparisons? Functions? Classifying data? : Sas programming

711


What do the SAS log messages "numeric values have been converted to character" mean?

868


What are symget and symput? : sas-macro

711


How do you control the number of observations and/or variables read or written?

729


How does the internal authentication work in sas? : sas-grid-administration

573


what is business intelligence? : Sas-bi

562


Explain the difference between nodup and nodupkey options?

595


explain the concepts and capabilities of business object? : Sas-bi

525


Where do you use proc means over proc freq?

546