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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.