Create a macro for jobs in SMC

[sathya66]

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

SS

[gwootton]

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.

[sathya66]

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

[Kurt_Bremser]

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;

[SASKiwi · Accepted solution]

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.;