topic Re: adding macro variable to filename in JOB in SAS Programming

adding macro variable to filename in JOB

cuevasj — Wed, 11 Dec 2019 20:40:23 GMT

In the VIYA environment, JobExectution to be exact,

how do you add a macro variable to a filename statement?

This is what I have:

%let VA_school_year=2019-20;

%let today='12/11/2019;

filename xmlfile filesrvc parenturi="&SYS_JES_JOB_URI"
name='_webout.xml'
contenttype='application/vnd.ms-excel'
contentdisp='attachment; filename=&VA_school_year. MS Promo &today..xml';

ods tagsets.excelXP file=xmlfile options(sheet_name="Overall Schoolwide Progress" frozen_headers='1');

I have tried with double quotes like this: ...fielname="&VA_school_year." MS Promo "&today.".xml'; ...

I have tried with no quotes, single quotes, with period and without period. When the file is produced the macro value is not substituted for the macro variable.

Any suggestions?

Re: adding macro variable to filename in JOB

ChrisNZ — Tue, 25 Feb 2020 02:53:44 GMT

1. What's that quote in %let today='12/11/2019; ?

2. Like this?

contentdisp="attachment; filename=""&VA_school_year. MS Promo &today..xml"" ";

Re: adding macro variable to filename in JOB

Cameron — Sun, 01 Mar 2020 20:53:49 GMT

Macro variables inside strings surrounded by single quotes are not resolved by the macro processor. So you need to hide the single quotes until the macro variables are resolved. to do this replace each single quote with a macro quoted single quote: %STR(%')

For more information read the section about macro quoting in the Macro Language: Reference manual.