DI Studio: Access a macro variable created in pre-processing of a job

[ThomasH]

Hi all,

I have created a macro variable in the pre-processing of a job.

[...]
%let jobname = %substr(&etls_jobname,1,5);
[...]

Now I would like to access it in the post-processing via a PROC SQL but it cant be resolved there.

[...]
WHERE jobname LIKE "&jobname"
[...]

I can't use &etls_jobname here, because it gets overwritten while some other jobs run via %include.

Any idea how I can resolve this?

Thanks a lot in advance and best regards,
Thomas

[Cynthia_sas]

Hi:
This may come down to whether your macro variable is GLOBAL or LOCAL in scope, which is where the [...] becomes significant. It also depends on how and where you're running your code, whether the macro variables created on one session or server are even still available after a process closes. Depending on your configuration, a process or job that launches in a single-user session may clean up after itself, so that no macro variables are left in the Global Symbol Table on that server when the job finishes.

I suggest you contact SAS Tech support for more help.

cynthia

[Patrick]

Like Cynthia suggests:
[...]
%global jobname;
%let jobname = %substr(&etls_jobname,1,5);
[...]

...and if you didn't do something 'exotic' in your job you'll have the macro var available in the post-processing part of this job.

HTH
Patrick

[GertNissen]

Is your pre-processing running on the same SAS server as your SQL ?

If 'yes' then your will find rsubmit in the genereated code/log.

You can 'lift' a SAS macro like using sysrput by defining parameters in DI studio.