topic Re: PROC export - dynamic file name in ODS and Base Reporting

PROC export - dynamic file name

lin39 — Thu, 19 Sep 2019 18:39:28 GMT

Hi everyone,

My dataset has 18 schools in total. I have a macro written to output .rtf files by school.

I'd like the macro to generate an automated file name for each school, for instance:

Profile_School of Business_&SYSDATE9.rtf

Profile_School of Engineering_&SYSDATE9.rtf

But instead, this happened:

Profile_put(int_frrpt, $intmaj.)_19SEP2019.rtf

What am I doing wrong?

My code:

proc format;
value $intmaj 
'BUS'='School of Business' 
'ENGI'='School of Engineering';
run;

%macro Run_Tabulate2 (school=);
ODS RESULTS OFF;
options orientation=landscape NODATE NOSTIMER NONUMBER NOBYLINE;
%let schl = put(int_frrpt, $intmaj.); 

ods rtf file="&root.\Output\Profile_&schl._&SYSDATE9..rtf" startpage=no BODYTITLE_AUX cssstyle="&root.\style.css";

ods escapechar='^';

proc tabulate;
** Insert misc stats by school here;
run;
ods rtf close;
%mend;

%Run_Tabulate2 (school='BUS');

Re: PROC export - dynamic file name

Kurt_Bremser — Thu, 19 Sep 2019 18:50:22 GMT

The macro language is just a text replacement system, so you will have the text

put(int_frrpt, $intmaj.)

inserted where you use &schl.:

Output\Profile_&schl._

thus turns into

Output\Profile_put(int_frrpt, $intmaj.)_

and since data step functions are not executed in this place, you end up with the text that surprises you.

Also, you could only resolve the text "int_frrpt", but never the contents of a variable called int_frrpt.

Change your %let to

%let schl = %sysfunc(putc(&school.,$intmaj.));

Re: PROC export - dynamic file name

lin39 — Thu, 19 Sep 2019 19:27:03 GMT

Thanks so much for the explanation. However when I tried to used your code, I got Profile_'BUS'_19SEP2019.rtf. Any ideas?

Re: PROC export - dynamic file name

Tom — Thu, 19 Sep 2019 19:45:42 GMT

@lin39 wrote:

Thanks so much for the explanation. However when I tried to used your code, I got Profile_'BUS'_19SEP2019.rtf. Any ideas?

Does the format actually know how to decode the value 'BUS' instead of BUS? If not then don't include the single quotes in the value of the macro variable.

Re: PROC export - dynamic file name

Kurt_Bremser — Thu, 19 Sep 2019 20:11:38 GMT

Since the macro processor is a text processor only, quotes are almost never needed. Change your macro call to

%Run_Tabulate2(school=BUS);