My code is as below: %let &_DOMAIN = 'S' ; DATA _NULL_; IF &_DOMAIN = 'S' THEN DO; %LET _DTLTRAD = "CAPP_1Q18_ACAS_Detail_R00_20171101_Primary"; %LET _DTLTRAD1 = "CAPP_1Q18_ACAS_Detail_R00_20171101_Secondary"; END; ELSE IF &_DOMAIN = 'A' THEN DO; IF &_state IN ('CO','CT','DE','MA','ME','MN','NH','OR','UT','VT','VA') THEN DO; %LET _DTLTRAD = "&ST1._APCD_Y&YR.M&MN._eRCE_STND_DET_PRIME.txt" ; %LET _DTLTRAD1 = "&ST1._APCD_Y&YR.M&MN._eRCE_STND_DET.txt" ; END; ELSE IF &_state IN ('AR','KS','WA') THEN DO; %LET _DTLTRAD = "&ST1._APCD_Y&YR.Q&QT._eRCE_STND_DET_PRIME.txt" ; %LET _DTLTRAD1 = "&ST1._APCD_Y&YR.Q&QT._eRCE_STND_DET.txt" ; END; END; PUT &_DTLTRAD; PUT &_DTLTRAD1; RUN; Result of this is: AR_APCD_Y17Q01_eRCE_STND_DET_PRIME.txt AR_APCD_Y17Q01_eRCE_STND_DET.txt Where it should be: CAPP_1Q18_ACAS_Detail_R00_20171101_Primary CAPP_1Q18_ACAS_Detail_R00_20171101_Secondary Can you help? I cant understand why it is going in second loop. Thanks in advance
... View more