Proc transpose help needed

[r3570]

Hi All,

I have a dataset as below:

 I need to transpose the data as below subject wise:

Any help ?

[Tom · Accepted solution]

Use PROC TRANSPOSE.

proc transpose data=have out=want(drop=_name_) ;
  by usubjid;
  id vstestcd;
  var vsorres;
run;

Note that if you will collect multiple BP readings per subject then you will probably also need to another variable to in the original dataset you can use in the BY statement so that PROC TRANSPOSE knows which pairs of SYS and DIA readings to keep together on the same output observation.

[r3570]

Thank you so much ! it worked !