Hi All, I am having some difficulty to formate date in SAS Macro. I need your help to get this done. %LET ASATDATE1 = &ASATDATE; DATA _NULL_; CALL SYMPUT('LAP_DAT_IND',%sysfunc(inputN(&ASATDATE1,DDMMYY,10))); %PUT &LAP_DAT_IND; RUN; When I ran the code i am getting below error message. Could you please help me on this. ------ DATA _NULL_; CALL SYMPUT('LAP_DAT_IND',%sysfunc(inputN(&ASATDATE1,DDMMYY,10))); SYMBOLGEN: Macro variable ASATDATE1 resolves to '03-07-2013' SYMBOLGEN: Some characters in the above value which were subject to macro quoting have been unquoted for printing. 250 CALL SYMPUT('LAP_DAT_IND',%sysfunc(inputN(&ASATDATE1,DDMMYY,10))); _ 159 ERROR 159-185: Null parameters for SYMPUT are invalid. WARNING: Argument 1 to function INPUTN referenced by the %SYSFUNC or %QSYSFUNC macro function is out of range. NOTE: Mathematical operations could not be performed during %SYSFUNC function execution. The result of the operations have been set to a missing value. 251 %put &LAP_DAT_IND &ASATDATE; WARNING: Apparent symbolic reference LAP_DAT_IND not resolved. SYMBOLGEN: Macro variable ASATDATE resolves to '03-07-2013' SYMBOLGEN: Some characters in the above value which were subject to macro quoting have been unquoted for printing. &LAP_DAT_IND '03-07-2013' 252 RUN; 255 PROC SQL; 256 CREATE TABLE lapse_reg AS 257 SELECT * from people 258 WHERE person_status = '1' 259 and lapse_date < &LAP_DAT_IND; WARNING: Apparent symbolic reference LAP_DAT_IND not resolved. 259 and lapse_date < &LAP_DAT_IND; _ 22 ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, a datetime constant, a missing value, BTRIM, INPUT, PUT, SUBSTRING, USER. WARNING: Apparent symbolic reference LAP_DAT_IND not resolved. 260 QUIT;
... View more