topic Re: Proc transpose help needed in SAS Programming

Proc transpose help needed

r3570 — Fri, 26 Aug 2022 12:29:45 GMT

Hi All,

I have a dataset as below:

I need to transpose the data as below subject wise:

Any help ?

Re: Proc transpose help needed

Tom — Fri, 26 Aug 2022 12:37:36 GMT

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.

Re: Proc transpose help needed

r3570 — Fri, 26 Aug 2022 12:51:25 GMT

Thank you so much ! it worked !