topic Creation of SAS library via macro variable in SAS Programming

Creation of SAS library via macro variable

NKormanik — Wed, 23 Feb 2022 01:34:35 GMT

The code below works just fine:

libname SPY     'e:\00\spy'      ;

Log output:
1
2    libname SPY     'e:\00\spy'      ;
NOTE: Libref SPY was successfully assigned as follows:
      Engine:        V9
      Physical Name: e:\00\spy

The code below does not work:

%let etf = spy ;

libname &etf.    'e:\00\&etf.'     ;

Log output:
1
2    %let etf = spy ;
3
4    libname &etf.    'e:\00\&etf.'     ;
NOTE: Library SPY does not exist.

Help Mr. Wizzard.......

Re: Creation of SAS library via macro variable

kiranv_ — Wed, 23 Feb 2022 02:08:38 GMT

 libname &etf.    "e:\00\&etf.";

Need to use double quotes while referencing macro variable in quotes

Re: Creation of SAS library via macro variable

NKormanik — Wed, 23 Feb 2022 03:02:42 GMT

You da man, @kiranv_ !!

Who would've thought.