Create variable

mar0000 — Fri, 10 Apr 2020 18:11:42 GMT

data have;
input Patient_ID $   date  Date9.     Activity $ ;
format date date9.;
datalines;
1234 20FEB2020 Football 
1234 20FEB2020 Basketball 
1234 25FEB2020 Ski 
1234 07SEP2020 Baseball

How would I create a variable that says 'Y' to the first line that has patient 1234 playing football, and 'N' to person 1234 playing basketball because they are playing on the same day. I want to say 'Y' to person 1234 on 25FEB2020 and 'Y' for patient 1234 on 07SEP2020.

Re: Create variable

andreas_lds — Fri, 10 Apr 2020 19:04:39 GMT

So you want to flag the first observation for each Patient_ID and date with "Y" and any other observation with "N"? Assuming that the data is sorted by Patient_ID and date:

data want;
	set have;
	by Patient_ID date;
	
	length status $ 1;

	status = ifc(first.date, 'Y', 'N');
run;

topic Re: Create variable in SAS Studio

Create variable

Re: Create variable