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

Reply
New Contributor
Posts: 4

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

[ Edited ]

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???

PROC Star
Posts: 1,769

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

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;

New Contributor
Posts: 4

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

Posted in reply to novinosrin

That worked. Thank you!

Super User
Posts: 23,663

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

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

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

 

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

Ask a Question
Discussion stats
  • 3 replies
  • 70 views
  • 0 likes
  • 3 in conversation