Hi, Can someone help me to write the macors for 6 months prior to YYYYMM date in YYMMN format which is already there in Temp dataset as shown below. ID Region YYYYMM 2205500483 3742 201503 1105661211 3411 201410 2010452387 4605 201501 data _null_; call symput('Hist',"'"||put(intnx('month', YYYYMM, -6), YYMMN.)||"'"); run; %put &Hist.; Proc sql; Create table Test as Select id, Region, YYYYMM, &Hist. as Effect_date from Temp order by id; quit; This step is not working.
... View more