topic Re: %include error: in SAS Programming

%include error:

RAVI2000 — Wed, 24 Jun 2020 18:51:51 GMT

I was trying to create a SDTM Domain using macros. I wanted to give a permanent path to store. I use %let path = "Locaton of the path";

and then %include "&path\Location of the path";

and i get an error

7 option mprint mlogic symbolgen source source2;
8 %let path = C:\Users\jasti\OneDrive\Desktop\Sdtm\DS;
9 %include "&path/C:\Users\jasti\OneDrive\Desktop\Sdtm\DS.sas";
SYMBOLGEN: Macro variable PATH resolves to C:\Users\jasti\OneDrive\Desktop\Sdtm\DS
WARNING: Physical file does not exist, C:\Users\jasti\OneDrive\Desktop\Sdtm\DS\C:\Users\jasti\OneDrive\Desktop\Sdtm\DS.sas.
ERROR: Cannot open %INCLUDE file C:\Users\jasti\OneDrive\Desktop\Sdtm\DS/C:\Users\jasti\OneDrive\Desktop\Sdtm\DS.sas.

I just started learning macros. I know i am doing dumb wrong here. Can anyone help me where am going wrong in giving the path ?

option mprint mlogic symbolgen source source2;
%let path = C:\Users\jasti\OneDrive\Desktop\Sdtm\DS;
%include "&path/C:\Users\jasti\OneDrive\Desktop\Sdtm\DS.sas";

This was the only code i started with and got error.

Re: %include error:

Reeza — Wed, 24 Jun 2020 18:59:54 GMT

ERROR: Cannot open %INCLUDE file C:\Users\jasti\OneDrive\Desktop\Sdtm\DS/C:\Users\jasti\OneDrive\Desktop\Sdtm\DS.sas.

Look at your error and look at what you coded. It literally takes the path and puts it where you have &path so it becomes the statement above. This is not valid SAS code. That's the key to making macros initially - treat it as basic text/code generation and the code must be valid SAS code. So if you remove one of the paths below it will work, either the macro variable or the path that you've hard coded. You only need one.

%let path = C:\Users\jasti\OneDrive\Desktop\Sdtm\DS;
%include "&path/C:\Users\jasti\OneDrive\Desktop\Sdtm\DS.sas";

Re: %include error:

mklangley — Wed, 24 Jun 2020 19:00:52 GMT

In your code, you're calling the path twice (once in the macro variable &path, once in the typed-out path). The two paths are being concatenated, which produces a non-existent path.

WARNING: Physical file does not exist, C:\Users\jasti\OneDrive\Desktop\Sdtm\DS\C:\Users\jasti\OneDrive\Desktop\Sdtm\DS.sas.
ERROR: Cannot open %INCLUDE file C:\Users\jasti\OneDrive\Desktop\Sdtm\DS/C:\Users\jasti\OneDrive\Desktop\Sdtm\DS.sas.

Try changing your %include line to this:

%include "&path\DS.sas";

Re: %include error:

Patrick — Wed, 24 Jun 2020 19:01:33 GMT

Look at the path that gets generated:

WARNING: Physical file does not exist, C:\Users\jasti\OneDrive\Desktop\Sdtm\DS\C:\Users\jasti\OneDrive\Desktop\Sdtm\DS.sas.

Would your code eventually work if you just use the &path macro variable?

%include "&path\DS.sas";

Re: %include error:

Kurt_Bremser — Wed, 24 Jun 2020 19:04:04 GMT

You repeat the path in the %INCLUDE statement. I would start with

%let path = C:\Users\jasti\OneDrive\Desktop\Sdtm\;
%include "&path.DS.sas";

If that does not do it, please post the %INCLUDE statement that worked before you used the macro variable.

Re: %include error:

Astounding — Wed, 24 Jun 2020 20:18:03 GMT

Assuming that the file really does exist, you just need to spell it correctly. Change the "/" to "\". Then this combination would work (but would be somewhat confusing):

%let path = C:\Users\jasti\OneDrive\Desktop\Stdm\DS;
%include "&path..sas";

This would be more straightforward:

%let path = C:\Users\jasti\OneDrive\Desktop\Stdm;
%include "&path\DS.sas";

Re: %include error:

RAVI2000 — Wed, 24 Jun 2020 22:41:46 GMT

Thank you all for really explaining it in depth and providing possible solutions. I resolved it !

Re: %include error:

Reeza — Thu, 25 Jun 2020 15:29:54 GMT

Please select an answer and mark this question as solved.