Hi everyone, I tried to insert yesterday's date into a table: proc sql; insert into x (OWNER, TABLE_NAME, DATA_TIME, PERIOD, SAS_PROCESS_START_TIME, SAS_LOAD_TYPE) values ('SAS', 'ABT_TABLES', %sysfunc(intnx(day,%sysfunc(date()), -1),date9.), /* YESTERDAY*/ 'DAILY', %sysfunc(datetime()), 'TRUNCATE/INSERT' ); quit; But there is an error: 24 proc sql; 25 insert into x 26 (OWNER, 27 TABLE_NAME, 28 DATA_TIME, 29 PERIOD, 30 SAS_PROCESS_START_TIME, 31 SAS_LOAD_TYPE) 32 values 33 ('SAS', 34 'ABT_TABLES', 35 %sysfunc(intnx(day,%sysfunc(date()), -1),date9.), NOTE: Line generated by the macro function "SYSFUNC". 35 11MAY2016 _______ 22 202 ERROR 22-322: Syntax error, expecting one of the following: a quoted string, a numeric constant, a datetime constant, a missing value, ), +, ',', -, MISSING, NULL, USER. ERROR 202-322: The option or parameter is not recognized and will be ignored. Do you have any suggestions? Many thnaks, Onur
... View more