topic Re: Using LIBNAME or variable (%LET statement) in %INCLUDE statement for code reuse in SAS Programming

Using LIBNAME or variable (%LET statement) in %INCLUDE statement for code reuse

jcromwell77 — Mon, 01 Nov 2021 19:28:23 GMT

I am creating a Main program to execute 5 sub programs, and I want to reuse a file path for better code management.

For example:

LIBNAME home 'C:\Users\user\Documents' ;

%LET path = C:\Users\user\Documents ;

And later I have 5 INCLUDE statements as such:

%INCLUDE 'C:\Users\user\Documents\program01.sas' ;

%INCLUDE 'C:\Users\user\Documents\program02.sas' ;

etc...

Is there a way to use a LIBNAME or variable instead of having to use 'C:\Users\user\Documents' over and over? Such as:

$INCLUDE '&path\program01.sas' ;

etc...

So far I've had no luck with using either a variable or LIBNAME, both give me errors. Ultimately, I want to be able to use the LIBNAME, variable or whatever to update the file path for all sub programs. Currently I have 5 subs and likely to have more in the future, so this would make code management a lot easier.

Re: Using LIBNAME or variable (%LET statement) in %INCLUDE statement for code reuse

PaigeMiller — Mon, 01 Nov 2021 19:31:16 GMT

Such as:

$INCLUDE '&path\program01.sas' ;

You type the INCLUDE command with a % sign not a $ sign. It should also use double quotes instead of single quotes.

Re: Using LIBNAME or variable (%LET statement) in %INCLUDE statement for code reuse

Tom — Tue, 02 Nov 2021 13:40:26 GMT

The macro processor will ignore strings that are quoted on the outside with single quote characters. If you want the macro variable to be expanded then use double quote characters instead.

%LET path = C:\Users\user\Documents ;
%INCLUDE "&path\program01.sas" ;

Libnames are for storing SAS datasets (or other binary SAS files like catalog), not for referencing text files. If you want to make a nickname to point to directory for finding text files then use a FILENAME statement to define a fileref you can then use with your %INCLUDE, INFILE or FILE statements.

filename root "C:\Users\user\Documents" ;
%INCLUDE root("program01.sas");

Editor's note: adding other helpful replies. This one from @Kurt_Bremser :

Try this
%LET path = C:\Users\user\Documents ; %INCLUDE "&path.\program01.sas"; %INCLUDE "&path.\program02.sas";

From @Reeza :

Just as an FYI you can also wildcard your %includes using an *
%include "&path/Program0*.sas" / source2;

And @ChrisHemedinger :

+1 for Tom's tip of using a FILENAME statement to indicate a folder. I use this all of the time as I have some programs that use different paths whether I run them on my local machine (Windows) or on a central server (Linux). Example:

%let tgtpath = %sysfunc(ifc(&SYSSCP. = WIN, \\network\root\u\&sysuserid.\.creds, /u/&sysuserid./.creds) ); filename creds "&tgtpath."; %include creds(signon.sas);
Note that the quotes are not required for the "member name" you're including here.

Re: Using LIBNAME or variable (%LET statement) in %INCLUDE statement for code reuse

jcromwell77 — Mon, 01 Nov 2021 19:34:38 GMT

You're correct, and I fat-fingered the include statement. I meant %INCLUDE not $INCLUDE, and it is correct in my code, just not in my question above.

Re: Using LIBNAME or variable (%LET statement) in %INCLUDE statement for code reuse

Reeza — Mon, 01 Nov 2021 19:35:24 GMT

Just as an FYI you can also wildcard your %includes using an *

%include "&path/Program0*.sas" / source2;

Re: Using LIBNAME or variable (%LET statement) in %INCLUDE statement for code reuse

jcromwell77 — Mon, 01 Nov 2021 19:37:34 GMT

Thank you! I did not know about filename, and I used the syntax you gave me and was able to execute the code properly.

Re: Using LIBNAME or variable (%LET statement) in %INCLUDE statement for code reuse

Kurt_Bremser — Mon, 01 Nov 2021 19:38:25 GMT

Try this

%LET path = C:\Users\user\Documents ;

%INCLUDE "&path.\program01.sas";
%INCLUDE "&path.\program02.sas";

Re: Using LIBNAME or variable (%LET statement) in %INCLUDE statement for code reuse

ChrisHemedinger — Mon, 01 Nov 2021 19:40:45 GMT

+1 for Tom's tip of using a FILENAME statement to indicate a folder. I use this all of the time as I have some programs that use different paths whether I run them on my local machine (Windows) or on a central server (Linux). Example:

%let tgtpath = %sysfunc(ifc(&SYSSCP. = WIN, \\network\root\u\&sysuserid.\.creds, /u/&sysuserid./.creds) ); filename creds "&tgtpath."; %include creds(signon.sas);

Note that the quotes are not required for the "member name" you're including here.

Re: Using LIBNAME or variable (%LET statement) in %INCLUDE statement for code reuse

jcromwell77 — Mon, 01 Nov 2021 19:41:19 GMT

Thank you, this worked as well. I wish I could add this as a solution too.