Hi...I have a macro that I run but keep getting a warning message. The macro does run and produce the output but I would like to resolve the error message. I tried using %Let dn1=&dn1 but that didn't work...any sugestions...thanks %LET Eff_Date1=20150722; %LET Exp_Date1=99999999; %LET load_date=20150722; %LET OldDin=02414716; %LET fil1=chocolate; DATA PRNS; LENGTH PRN $ 8; INPUT PRN $; DATALINES; 02429659 %MACRO INSERTS(Eff_Date,Exp_Date,Prn,Dn,fil); PROC SQL NOPRINT; CREATE TABLE mydata AS SELECT PLAN.ID, PLAN.PRN, PLAN.EX_EFF_DATE, PLAN.EX_EXP_DATE, PLAN.APPLICATION_DATE FROM FPIN.PLAN WHERE ( PLAN.FLAG = "Y" ) AND ( PLAN.OVERRIDE = 99 ) AND ( PLAN.PRN = "&Prn" ) AND ( PLAN.EX_EXP_DATE ^= 99999999) AND (( PLAN.EX_EFF_DATE <= &Exp_Date ) AND ( PLAN.EX_EXP_DATE >= &Eff_Date )) ; PROC SORT DATA=mydata; BY ID PRN EX_EFF_DATE EX_EXP_DATE APPLICATION_DATE; RUN; %MEND INSERTS; %INSERTS(&Eff_Date1, &Exp_Date1, &OldPrn, &Dn1, &fil1); LOG OUTPUT: 32 %MEND INSERTS; 633 634 %INSERTS(&Eff_Date1, &Exp_Date1, &OldPrn, &Dn1, &fil1); WARNING: Apparent symbolic reference DN1 not resolved.
... View more
