topic Re: using a macro in a library declaration in SAS Programming

using a macro in a library declaration

ubshams — Thu, 12 Sep 2019 23:26:42 GMT

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;

Re: using a macro in a library declaration

novinosrin — Thu, 12 Sep 2019 23:52:37 GMT

enclose in double quotes for macro variable to resolve

 

%let portfolio = samplename;

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

Re: using a macro in a library declaration

ubshams — Fri, 13 Sep 2019 13:30:25 GMT

Thanks that worked