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

hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?

1665


What is factor analysis?

663


Describe the ways in which you can create a macro variable?

628


What are the features of SAS?

582


Describe a time when you were really stuck on a problem and how you solved it?

2207






Explain append procedure?

636


what versions of sas have you used (on which platforms)? : Sas programming

586


how would you determine the number of missing or nonmissing values in computations? : Sas programming

659


which date functions advances a date time or date/time value by a given interval? : Sas programming

541


: and & modifiers.

866


Mention what is PROC in SAS?

605


What would be the result of the following SAS function (given that 31 Dec, 2000 is Sunday)?

686


Explain the use of proc print and proc contents?

562


How do you connect the desktop application to metadata server? : sas-grid-administration

588


Hello Friends, am new to this forum and am not good at sas progarmming. please can any one of you send me couple of sample large sample SAS Jobs which can you use 200 MB of data and other sas job upto 25GB of data. am doing a performance testing on our legacy systems and new upgraded system. I would really appreciate if you can do me this favor Thank you Priya

1358