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
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.
What does the log say?
Macro variables need double quotes to resolve, they won't resolve in single quotes
Log says...
Physical file does not exist,
'k:\&month. &year.\cm.txt'
it doesn't work with double quotations either.
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.
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.