DATA Step, Macro, Functions and more

Libname with Macro specifying Directory

Reply
User
Posts: 1

Libname with Macro specifying Directory

I have two libname statements in the attached code (I only run 1 at a time) that should be the same yet only one works. The direct call-out works but using the macro variable name does not. From what I can tell, these are the EXACT SAME things. When I run the libname using dirSAS  I receive an error. Please advise.

 

Code: 

%let dirLSB=/folders/myshortcuts/MyRawData;
%let dirSAS=/folders/myfolders;

 

*libname libsas 'dirSAS'; *This does not work;
libname libsas '/folders/myfolders'; *This does work;

 

data libsas.Snow1;
infile "&dirLSB/Pr1Snowfall1.csv"
DLM =','; *Range of, comma delim;
input Season $ Sep Oct Nov Dec Jan Feb Mar Apr May Total;
RUN;

 

Error:

NOTE: Library LIBSAS does not exist.

Frequent Contributor
Posts: 144

Re: Libname with Macro specifying Directory

You have put your directory in a macro variable. Using

libname libsas 'dirSAS';

You are trying to create a libname called libsas of the directory dirSAS(that doesn't exist). To replace the content of a macro variable you must use & before the name of the variable. Furthermore simple quote doesn't allow macro replacement, you must use double quotation marks

libname libsas "&dirSAS";
Ask a Question
Discussion stats
  • 1 reply
  • 140 views
  • 1 like
  • 2 in conversation