topic Re: Additional sas code with macro won't run in SAS Programming

Additional sas code with macro won't run

sasuser381 — Thu, 17 Sep 2020 19:33:09 GMT

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;

Re: Additional sas code with macro won't run

Kurt_Bremser — Thu, 17 Sep 2020 19:25:16 GMT

Please post your code in a code box ("little running man" button).

Re: Additional sas code with macro won't run

ballardw — Thu, 17 Sep 2020 19:27:43 GMT

You will make it easier to post code and especially logs by copying the TEXT and pasting into a code box on the forum opened with the </> icon.

We can't edit pictures.

We can't copy text from a picture to show needed changes.

And the default image is so blinking small it is extremely hard to read.

What does your LOG show?

Re: Additional sas code with macro won't run

sasuser381 — Thu, 17 Sep 2020 19:49:53 GMT

I inspected the log as you said. It seems like it only executes this when you run a query in a program, not in a Query bulder. When i run query builder it doesn't show up in log at all, but when i run any program it does.

Re: Additional sas code with macro won't run

Kurt_Bremser — Thu, 17 Sep 2020 19:55:10 GMT

You need to do the "insert custom code" for tasks also.

Re: Additional sas code with macro won't run

sasuser381 — Thu, 17 Sep 2020 20:00:59 GMT

I found the solution. I needed to go in options for query in tools>options>tasks and to set this code tu run after each query. Because the option i used was only for programs. Thank you guys.