topic Transpose in SAS Procedures

Transpose

robertrao — Sun, 21 Apr 2013 23:03:31 GMT

Hi,

I have a table like this...

pt no ID value

111 101 96.4

111 102 80/120

For the same patient 111 the ID values are different.

ID value 101 is Temperature and 102 is BP..

How can i get the information in a single row??????/

Regards

Re: Transpose

PGStats — Mon, 22 Apr 2013 02:02:23 GMT

Transpose is the question, and the answer!

data have;
length value $10;
input pt_no ID value;
datalines;
111 101 96.4
111 102 80/120
;

proc transpose data=have out=want(drop=_name_) prefix=code_;
by pt_no notsorted;
var value;
id ID;
run;

proc print; run;

Re: Transpose

Ksharp — Mon, 22 Apr 2013 06:31:40 GMT

You'd better post the result you need . Is it what you are looking for ?

data have;
input pt  ID    value : $20.;
cards;
111  101  96.4
111 102  80/120
;
run;
data want(keep=pt x);
 set have;
 by pt;
 length x $ 40;
 retain x;
 x=catx(' ',x,id,value);
 if last.pt then do;
                  output;
                      call missing(x);
                    end;
run;

Ksharp

Re: Transpose

robertrao — Mon, 22 Apr 2013 16:48:56 GMT

It works fine.

I have a question though..

notsorted : can i use this with the by statement and skip the proc sort step?????

Regards

Re: Transpose

PGStats — Mon, 22 Apr 2013 17:52:00 GMT

You can skip sorting only if the patient data (IDs) are consecutive (grouped together) in your dataset. - PG