| Date: | Wed, 29 Oct 2003 07:55:55 -0500 |
|---|
| Reply-To: | "Goldman, Brad (AT-Atlanta)" <Brad.Goldman@AUTOTRADER.COM> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | "Goldman, Brad (AT-Atlanta)" <Brad.Goldman@AUTOTRADER.COM> |
|---|
| Subject: | Order of output rows of Transposed dataset |
|---|
| Content-Type: | text/plain; charset="iso-8859-1" |
|---|
Input, dataset A:
Obs Pageview Visitors Cars Dealers
1 100 10 50 60
Code:
proc transpose data=a out=b (drop=_label_); run;
Output, dataset B:
_name_ col1
Cars 50
Dealers 60
Pageview 100
Visitors 10
I would like B to appear in the order the variables were in dataset A.
That is:
Desired Output:
_name_ col1
Pageview 100
Visitors 10
Cars 50
Dealers 60
I can't find an option in proc transpose to do this. What is the best way
to get dataset B in the order I need it?
Thank you!
Brad Goldman
| 
