topic Re: Unable to resolve %let variable in %include statement in SAS Programming

Unable to resolve %let variable in %include statement

vijaypratap0195 — Sat, 03 Jun 2023 07:29:23 GMT

I am unable to resolve the value of %let project_path in %include statement:

SAS code:

%let project_path = %str(E:/Murli/Project);
%put %str(&project_path);
%include "&project_path/Utils/Macro/connect2mssql.sas"

log:

ERROR: Cannot open %INCLUDE file CONNECTION.
812 %include "&project_path/Utils/Macro/connect2mssql.sas"

Re: Unable to resolve %let variable in %include statement

Ksharp — Sat, 03 Jun 2023 08:45:58 GMT

Since you used MASKED function %str(), you need to use %unquote() to get rid of it before referring to this macro variable.

%let project_path = %str(E:/Murli/Project);
%put %str(&project_path);
%include "%unquote(&project_path)/Utils/Macro/connect2mssql.sas" ;

Re: Unable to resolve %let variable in %include statement

PaigeMiller — Sat, 03 Jun 2023 11:19:35 GMT

Works fine for me on Windows without %STR, quoting or unquoting, but you need to use backslashes on Windows instead of forward slashes.

%let project_path = G:\xxx\xxxx\MillerP;
%put &=project_path;
%include "&project_path\scale_to_100.sas";