topic Re: Create a macro for jobs in SMC in Administration and Deployment

Create a macro for jobs in SMC

sathya66 — Thu, 11 Nov 2021 09:34:36 GMT

Hi All,

Is there a way to feed a macro variable into every job in a flow from management console/flow manager? Without having to change every individual job or is there a way to define an environment variable set in management console as a macro variable in SAS? It isn't recognising the macro variables set at the moment

Thanks

Re: Create a macro for jobs in SMC

gwootton — Thu, 11 Nov 2021 13:37:01 GMT

Could you add a %let statement to the autoexec_usermods.sas in SASApp/BatchServer? Then the macro variable would be set for every SAS session started there, which should be every job.

Re: Create a macro for jobs in SMC

SASKiwi — Thu, 11 Nov 2021 20:18:37 GMT

If you are using the LSF scheduler in SMC then you can add an environment variable to the job then use the SYSGET SAS function to read that into a macro variable. We use this technique ourselves and it is a great way to supply job inputs automatically.

%let batch_var = %sysfunc(sysget(batch_var)); * Reads an environment variable called batch_var.;

Re: Create a macro for jobs in SMC

sathya66 — Tue, 16 Nov 2021 10:50:26 GMT

yes but this one only for perticuler user so we don't want to put it in autoexc.

Re: Create a macro for jobs in SMC

Kurt_Bremser — Tue, 16 Nov 2021 11:30:26 GMT

When the SAS session starts, it's already running with the correct user-id, so you can query that in the autoexec.sas by using

%if %sysget(USER) = ....
%then %do;
  %let macrovar = ....;
%end;