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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.