topic Re: Multiple data for same record ID in SAS Programming

Multiple data for same record ID

tranguyen0205 — Thu, 25 May 2023 19:46:44 GMT

Hi,

How can I fill in the cohort number for the same record ID but at different time points? Please see

What the dataset looks like:

What I want:

Thank you!

A_Kh — Thu, 25 May 2023 20:28:09 GMT

data want;
	set have;
	by recordid;
	retain temp;
	if first.recordid then temp=cohort;
	if cohort eq . then cohort=temp;
	drop temp;
proc print;run;

tranguyen0205 — Thu, 25 May 2023 20:50:11 GMT

Thanks a lot! It works.