BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
brophymj
Quartz | Level 8


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 ACCEPTED SOLUTION

Accepted Solutions
TomKari
Onyx | Level 15

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.

View solution in original post

5 REPLIES 5
Steelers_In_DC
Barite | Level 11

What does the log say?

Reeza
Super User

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

brophymj
Quartz | Level 8

Log says...

Physical file does not exist,

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

it doesn't work with double quotations either.

Reeza
Super User

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

Options symbolgen mprint;

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

TomKari
Onyx | Level 15

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.

sas-innovate-2024.png

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.

 

Register now!

What is Bayesian Analysis?

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 5 replies
  • 943 views
  • 0 likes
  • 4 in conversation