topic need help creating 2 cohorts based on dates from 2005 versus 2015 in SAS Programming

need help creating 2 cohorts based on dates from 2005 versus 2015

bkv1 — Wed, 06 Jun 2018 15:21:26 GMT

Rusty coder here ...

I have a data set with the dates from either 2005 or 2015 (format is YYMMDD10.). They all are currently under 1 variable: dovcug

I want to create 2 cohorts of subjects based on the time period they are from, the variable called "cohort" with 0 = all dates from 2005 and 1 = all dates from 2015. This is my code:

if dovcug < 2006-01-01 then Cohort = 0;
else if dovcug > 2014-12-31 then Cohort = 1;

run;

But when I run proc freq on "Cohort" I only get:

cohort = 1

Frequency = 517

No cohort = 0

What am doing incorrectly???

Re: need help creating 2 cohorts based on dates from 2005 versus 2015

novinosrin — Wed, 06 Jun 2018 15:30:21 GMT

do you not need a sas date constant like this?

if dovcug < '01jan2006'd then Cohort = 0;
else if dovcug > '31dec2014'd then Cohort = 1;

Re: need help creating 2 cohorts based on dates from 2005 versus 2015

Reeza — Wed, 06 Jun 2018 15:37:26 GMT

if year(dovcug) = 2005 then cohort=0;

else if year(dovcug)=2015 then cohort=1;

If your logic is the year, use the YEAR()

Re: need help creating 2 cohorts based on dates from 2005 versus 2015

bkv1 — Wed, 06 Jun 2018 15:37:34 GMT

That worked. Thank you!