adding observations to a variable

jcooper3 — Wed, 04 Dec 2013 17:54:19 GMT

Hi all-

I have the following dataset:

patient ID quarter CHF (and so on...there are ~23 more column variables then- all binary 0/1, with 1=yes the person has the condition)

3 14 0

3 16 0

3 20 1

3 23 0

...and so on

I want each patient to show 36 quarters (so 1-36) regardless of if they have the condition or not. Right now, the quarters that are showing up are only the ones that people have a "yes" for the condition in.

Does anytone know how I would add in the quarters that are missing. It is different w/ each patient.

Thanks!

Re: adding observations to a variable

ballardw — Wed, 04 Dec 2013 18:02:58 GMT

Something like:

data temp;

set have;

by PatientId notsorted; /* if data is sorted by PatientId don't need the notsorted but assumes all the records for PatientId are together*/
if first.PatientId then do quarter = 1 to 36;

output;

end;

run;

proc sql;

create table want as

select a.*, b.*

from temp as a left join have as b on

a.PatientId = b.PatientId;

quit;

You'll get a warning about PatientId and quarter being in both tables but b.* is shorter than listing all the variables in Have except PatientId and quarter.

topic adding observations to a variable in SAS Programming

adding observations to a variable

Re: adding observations to a variable