Hi:
Did you look at this program:
http://support.sas.com/forums/thread.jspa?messageID=46738뚒
It essentially transposes 4 character variables in a DATA step program and then uses PROC REPORT to create the kind of output you want. The only differences in what you would have to do is:
1) you'd subset your data so you'd only have 1 obs of interest and
2) you'd have to use a DATA step and the PUT function to convert all your numeric variables to character and this means that
3) if you had special user-defined formats, you'd have to take those into account
OR
you'd have to run PROC TRANSPOSE -- this will be easier if you do only have ONE observation. See the example below.
cynthia
[pre]
** alternate approach;
proc sort data=sashelp.class
out=onlyone;
where name in ('Alfred');
by name;
run;
** transpose all variables -- usually only numeric are transposed;
** there will be a note in the log about automatic conversion of;
** numeric to character -- if you do not want this automatic conversion,
** (for example, if you have user-defined formats);
proc transpose data=onlyone out=charout;
var _character_ _numeric_;
run;
proc print data=charout;
run;
proc report data=charout nowd;
column _NAME_ COL1;
define _NAME_ / display 'ID';
define COL1 / display 'Value';
run;
[/pre]