topic How do I use the Lag Function based on Key Variables-ID, Date and Training Type in SAS Programming

How do I use the Lag Function based on Key Variables-ID, Date and Training Type

kingsii24 — Wed, 11 Mar 2020 17:49:05 GMT

I have the following data set:

I'm trying to figure out how to capture the previous (most recent) training of an employee (represented by ID) given that they took the IT training. My goal is to have the following table:

I'm assuming that I can use the lag function to accomplish this but I'm having a hard time trying to figure out how to set up my SAS code (using SAS studio).

Re: How do I use the Lag Function based on Key Variables-ID, Date and Training Type

ed_sas_member — Wed, 11 Mar 2020 18:11:21 GMT

Hi @kingsii24

Welcome to the community!

You can try this:

proc sort data=have out=have_sorted;
	by ID Date_start;
run;

data want;
	set have_sorted;
	by ID Date_start;
	length prev_training $ 10;
	_lag = lag(training_type);
	if first.ID then _lag="";
	if training_type = "IT" then prev_training = _lag;
	drop _lag;
run;

NB: there are some inconsistencies in the pictures for patient 2 -> the start dates for each training are not the same. I believe it is a mistake.

If not, please explain.

Best,

Re: How do I use the Lag Function based on Key Variables-ID, Date and Training Type

kingsii24 — Wed, 11 Mar 2020 18:49:39 GMT

@ed_sas_member

Thank you so much! This is what I needed, the discrepancy between the two data sets is definitely an error on my side.

Re: How do I use the Lag Function based on Key Variables-ID, Date and Training Type

ed_sas_member — Wed, 11 Mar 2020 19:23:55 GMT

Thank you @kingsii24!