I have this code which i want to run after each query is processed. When i run it manualy it works, but when i use option tools>options>sas programs> insert custom code after submitted code it doesn't insert that row affter i run query.
PROC SQL;
%let date_modified=%sysfunc(datetime(),datetime16.);
%put &date_modified;
insert into REP.tables(TABLE_NAME, DATETIME_MODIFIED, MODIFIED_BY_USER,PROJECT_PATH,PROJECT_NAME,PROCES_FLOW,QUERY_NAME)
values("&syslast","&date_modified"dt,"&_CLIENTUSERNAME","&_CLIENTPROJECTPATH","&_CLIENTPROJECTNAME","&_CLIENTPROCESSFLOWNAME","&_CLIENTTASKLABEL");
quit;
... View more
