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.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: