Hi! I am working with claims based data and I'm having difficulty selecting the cases I want based on their enrollment period.   I would like to select cases with enrollment for a full 12 months prior to their diagnosis and full enrollment afterwards until death or end of follow-up. There can be no gaps in enrollment.   The insurance enrollment file is arranged as 300 columns representing one month between 1/1991-12/2015 and a value of "1- yes" or "0- no" for enrollment during that month. Date of diagnosis is arranged as two separate columns "mm" and "yyyy," beginning in 2003. Date of death is arranged the same way as "mm" and "yyyy".   Thus far, I've converted the diagnosis date (DXDT) to columns representing a specific month/year similar to the enrollment indicator (status). I am trying to use an array as follows below to determine which patients have 12 months prior enrollment, but keep getting: "ERROR: Array subscript out of range at line 2900 column 38" even when I've tried explicitly stating the subscripts DXDT(157:300) and _status(145:300). Thanks in advance for all insight and assistance!   ARRAY DXDT(*) DXDT157-DXDT300; ARRAY _status(*) status145-status300; _enroll_pre0=0; DO i= 157 TO 300; DO j= 0 TO 12; IF _status(dxdt{i}-j)=1 then _enroll_pre=1;   ... View more

Hi, I’m trying to run the following macro from this SAS support paper on flagging healthcare claims using SAS 9.4 (TS1M3)(https://support.sas.com/resources/papers/proceedings15/1340-2015.pdf 😞   %macro flag(codetype, flagtype);    proc sql;       select quote(code)          into :codelist             separated by "," from CODES               where                  codetype="&codetype" and                  flagtype="&flagtype";    quit; data CLAIMS;    set CLAIMS;       if &codetype.1 in (&codelist)          then _&flagtype=1;            run;     %mend;   %flag(hcpcs, biopsy); *flag biopsy;   I have my datasets (CLAIMS and CODES) set up as specified in the paper with the only notable difference being my data contains multiple claims per patient; but I'm not sure this should matter.   I keep getting the following error when I try running the code and have tried the almost all suggestions for ERROR 22-322 listed in SAS community posts. None of them have resolved this error. Does anyone know what is wrong with this code?   SAS log after I run this macro:   2653 options MLOGIC; 2654 %flag(hcpcs, biopsy); MLOGIC(FLAG): Beginning execution. MLOGIC(FLAG): Parameter CODETYPE has value hcpcs MLOGIC(FLAG): Parameter FLAGTYPE has value biopsy SYMBOLGEN: Macro variable CODETYPE resolves to hcpcs SYMBOLGEN: Macro variable FLAGTYPE resolves to biopsy NOTE: No rows were selected. NOTE: PROCEDURE SQL used (Total process time):       real time           0.03 seconds       cpu time            0.01 seconds   SYMBOLGEN: Macro variable CODETYPE resolves to hcpcs NOTE: Line generated by the invoked macro "FLAG". 2     (&codelist)             then _flagtype=1;     run;         -         22         76 WARNING: Apparent symbolic reference CODELIST not resolved.   ERROR 22-322: Syntax error, expecting one of the following: a quoted string,               a numeric constant, a datetime constant, a missing value, iterator, (.   ERROR 76-322: Syntax error, statement will be ignored.   Thank you for your help! ... View more