using a macro in a library declaration

[ubshams]

Hello,

   When I try to run the following code it says library does not exist. I am doing something wrong in the libname out statement. But not sure what. Please advice.

Thanks in advance.

%let portfolio = samplename;

libname out '/folder1/folder2/folder3/&portfolio';

proc import Out=out.BT_EOP_Balance_import datafile= "/folder1/folder2/folder3/&portfolio/excelfile1_&portfolio..xlsx"

Dbms=xlsx replace;

Sheet=BT_EOP_Balance;

run;

[novinosrin · Accepted solution]

enclose in double quotes for macro variable to resolve

 

%let portfolio = samplename;

libname out "/folder1/folder2/folder3/&portfolio";

[ubshams]

Thanks that worked