How do I Get %Sysfunc to work in a PDF File Name

[CEG]

Hi,

I can't get the month and year to appear in the ODS PDF FILE, but it works throughout the program.

%let today = %sysfunc( TODAY());

%let month = %sysfunc( PUTN(&TODAY - 28,MONNAME3.));

%let year = %sysfunc( PUTN(&TODAY - 28,YEAR4.));

ODS PDF FILE = 'C:&month&year_VideoCounts.pdf';

Thanks!

CEG

[Tom · Accepted solution]

The macro processor ignores string quoted using single quote characters. Use double qoute characters instead.  When you put characters after the macro variable name that are valid characters to use in a macro variable name you need to tell SAS where your variable name ends. You use the period for this.

ODS PDF FILE = "C:&month.&year._VideoCounts.pdf";

[CEG]

Perfect! Thanks!

[RW9]

Not sure why you need all that code, just do:

ods pdf file="c:\%sysfunc(date(),dtmonyy7.)_VideoCounts.pdf";

[CEG]

Thanks!



It is a lot easier.