topic Re: macro variables in location in SAS Procedures

macro variables in location

brophymj — Thu, 23 Jul 2015 14:29:14 GMT

I have a filename defined in my dataset:

filename cm 'k:\may 2015\cm.txt';

and in another program the month and year are defined as:

%let month = may;

%let year = 2015;

when I used the code

filename cm 'k:\&month. &year.\cm.txt';

it doesn't work

Steelers_In_DC — Thu, 23 Jul 2015 14:36:01 GMT

What does the log say?

Reeza — Thu, 23 Jul 2015 14:40:45 GMT

Macro variables need double quotes to resolve, they won't resolve in single quotes

brophymj — Thu, 23 Jul 2015 15:52:40 GMT

Log says...

Physical file does not exist,

'k:\&month. &year.\cm.txt'

it doesn't work with double quotations either.

Reeza — Thu, 23 Jul 2015 16:37:36 GMT

Use the following line to see what the macro variables are resolving to, also, make sure that the file actually exists

Options symbolgen mprint;

If that doesn't work, post your full code and log.

TomKari — Thu, 23 Jul 2015 18:38:34 GMT

1. As previously mentioned, use double quotes not single.

2. Is your SAS session possibly running on a server that can't see your K: drive?

3. Could the macro variables be local when they're created, not global? In the program that's failing, put in the line

%put &month &year;

to see if the variables have values.