Help using Base SAS procedures

Needing to transpose data by more than one variable - stuck on coding to use

Accepted Solution Solved
Reply
Contributor
Posts: 71
Accepted Solution

Needing to transpose data by more than one variable - stuck on coding to use

I have data with immunization for individuals. I am needing to create a new line for each individual by each new date that appears, but at the same time have a list of the immunizations for that occured on each date listed.

I have been trying to make this work for some time, but it has been a bit of a disaster and I cannot seem to figure this out. Any help is appreciated.

I want my data to go from looking like this:

ID          Date              Vaccine

1b          06/06/08     vac123

1b          06/06/08     vac345

1b          06/06/08     vac678

1b          06/06/08     vac910

1b          07/09/10     vac123

1b          07/09/10     vac345

1b          08/08/11     vac345

1b          08/08/11     vac678    

1b          08/08/11     vac910

to look like this:

ID     Date               vac123          vac345          vac678          vac910

1b     06/06/08          1                       1                   1               1         

1b     07/09/10          1                       1

1b     08/08/11                                   1                   1               1


Accepted Solutions
Solution
‎09-19-2011 12:34 PM
Super User
Posts: 17,737

Needing to transpose data by more than one variable - stuck on coding to use

Add a 1 in to the dataset for each row and then use proc transpose.

data want1;

     set have;

     value=1;

run;

proc transpose data=want1 out=want2;

by id date;

var value;

id vaccine;

run;

View solution in original post


All Replies
Solution
‎09-19-2011 12:34 PM
Super User
Posts: 17,737

Needing to transpose data by more than one variable - stuck on coding to use

Add a 1 in to the dataset for each row and then use proc transpose.

data want1;

     set have;

     value=1;

run;

proc transpose data=want1 out=want2;

by id date;

var value;

id vaccine;

run;

Contributor
Posts: 71

Needing to transpose data by more than one variable - stuck on coding to use

This worked perfectly. Thank you!

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 150 views
  • 0 likes
  • 2 in conversation