topic Re: Reference the date of another var in conditional in SAS Programming

Reference the date of another var in conditional

MB_Analyst — Sun, 16 Dec 2018 14:20:42 GMT

I want to create an exclusion criteria using the years within a variable. The data looks like:

DATA TEST;
    INPUT ID DATA_VALID ID_YEAR;
DATALINES;
1 01APR2012 2013
2 14DEC2014 2015
2 27AUG2010 2009
;

I want to perform the logical statement: If the DATA_VALID observation is after the ID_YEAR observation of December 31 YYYY, flag it as a 0.

DATA WANT:
    SET TEST;
    IF DATA_VALID >  '31DEC+"ID_YEAR"'d THEN flag= 1;
        ELSE flag=0;
RUN;

The first two observations should be set to 0, with the last (ID=3) equal to 1.

PaigeMiller — Sun, 16 Dec 2018 14:25:16 GMT

In order to be able to work with dates, they must be read in using the proper informat to make them dates and not text.

DATA TEST;
    INPUT ID DATA_VALID date9. ID_YEAR;
DATALINES;
1 01APR2012 2013
2 14DEC2014 2015
2 27AUG2010 2009
;

Then to do the comparison

DATA WANT;
    SET TEST;
    IF DATA_VALID >  mdy(12,31,id_year) THEN flag= 1;
        ELSE flag=0;
RUN;

Astounding — Sun, 16 Dec 2018 15:14:33 GMT

Why make it complex? Why not:

if year(date_valid) > id_year then flag=1;

else flag=0;

Kurt_Bremser — Sun, 16 Dec 2018 15:39:04 GMT

Or even shorter:

flag = year(date_valid) > id_year;