topic Re: Create ID variable for multiple records per individual in SAS Data Management

Create ID variable for multiple records per individual

ash — Mon, 06 Apr 2015 16:41:47 GMT

Hi,

I have an id variable, and I have multiple observations per id (patients with multiple specimens). I want to create a new ID variable containing 1 for the first ID, 2 for the second, and so on. I have a date variable. This in preparation for transposing the dataset to have one row per patient with columns for the variables related to specimen 1, specimen 2, etc. Open to ideas of better ways to do this, but I was going to use the new ID variable as my prefix.

Re: Create ID variable for multiple records per individual

ballardw — Mon, 06 Apr 2015 16:46:00 GMT

Stub code:

proc sort data=have; by ID date;run;

data want;

set have;

by Id;

Retain IdRec .;

if first.id the IdRec=1;

else IdRec+1;

run;