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

you can also use arrays to shift rows into columns.

Is This Answer Correct ?    2 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can you limit the variables written to output dataset in data step?

756


I am preparing SAS Certified Advanced Programmer for SAS 9 in 2014. If anybody has the latest dumps for this exam, please mail me at dhiman.mukherjee@gmail.com

2262


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

541


What are the different operating system platforms in which we can use sas? : sas-grid-administration

592


what techniques and/or procs do you use for tables? : Sas programming

574






Explain bmdp procedure?

615


what are the benefits of data integration? : Sas-di

540


what are the considerations when picking a SAS/STAT procedure?

2900


Explain what is the use of proc gplot?

703


Describe the function and utility of the most difficult SAS macro that you have written?

2026


how the sas basic syntax style described? : Sas-administrator

608


What can you learn from the SAS log when debugging?

921


describe about metadata object? : Sas-di

629


Mention some common errors that are usually committed in sas programming.

589


If you need the value of a variable rather than the variable itself what would you use to load the value to a macro variable? : sas-macro

596