I'm trying to select cases for a cohort. In order to be selected, they must have a status code of 10 for each month of the year that the person was alive. If someone lived the entire year or died in December, then all 12 STATUS_CODE variables must = 10. But if they died in February, then only STATUS_CODE _01 and STATUS_CODE_02 must = 10. I'm trying to use a do loop, with a count that goes up to the month that the person died (or 12 if they didn't die), for the STATUS_CODE variables.
I also need to reformat the do loop count variable so that a padding 0 is added to single digit months but not to double digit months (so Jan should be 01 instead of 1, but October is still 10 and 010).
But I'm getting an error that my do loop count variable "i" is an invalid argument for SYSFUNC because "i" isn't a number.
Another issue I'm concerned about is whether later months will overwrite the selection flag variable. For example, case 2345 should not be selected because status code = 6 near the middle of the year. But since the last status code is 10, will that overwrite the selection flag variable?
I tried to provide sample data, but I can't get that to work either 😡 All of the BENE_DEATH_DT values are apparently invalid, even though everything is in date9 format. And all values for STATUS_CODE_10 are invalid, even though they're exactly the same as all the other STATUS_CODE variables.
data have;
infile datalines dsd dlm=',' truncover;
input BENE_ID BENE_DEATH_DT date9. VALID_DEATH_DT_SW $ STATUS_CODE_01
STATUS_CODE_02 STATUS_CODE_03 STATUS_CODE_04 STATUS_CODE_05
STATUS_CODE_06 STATUS_CODE_07 STATUS_CODE_08 STATUS_CODE_09
STATUS_CODE_10 STATUS_CODE_11 STATUS_CODE_12;
datalines;
1234,"",.,10,10,10,10,10,10,10,10,10,10,10,10 /*should_be_selected = 1*/
2345,"",.,10,10,10,10,10,10,6,10,10,10,10,10 /*should_be_selected = 0*/
3456,"V",04JUN2018,10,10,10,10,10,10,0,0,0,0,0,0 /*should_be_selected = 1*/
4567,"V",15DEC2018,10,10,10,10,10,10,10,10,10,10,10,10 /*should_be_selected = 1*/
5678,"V",08FEB2018,10,6,0,0,0,0,0,0,0,0,0,0 /*should_be_selected = 0*/
;RUN;
DATA want; SET have;
IF VALID_DEATH_DT_SW = "V" THEN final_month = month(BENE_DEATH_DT);
ELSE IF VALID_DEATH_DT_SW ^= "V" THEN final_month=12;
should_be_selected = 1;
do i=1 to final_month;
%let m=%sysfunc(putn(i,z2.)); /*This should add a padding 0 to single digit numbers*/
IF STATUS_CODE_&m. ^= 10 THEN should_be_selected = 0;
end;
RUN; proc print data=want;run;
... View more
