topic Re: How do I Get %Sysfunc to work in a PDF File Name in SAS Programming

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

CEG — Wed, 12 Jul 2017 15:51:09 GMT

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

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

Tom — Wed, 12 Jul 2017 16:00:35 GMT

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

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

CEG — Wed, 12 Jul 2017 16:10:39 GMT

Perfect! Thanks!

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

RW9 — Wed, 12 Jul 2017 16:23:09 GMT

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

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

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

CEG — Wed, 12 Jul 2017 16:26:39 GMT

Thanks!

It is a lot easier.