Include statement not working

VALLY — Wed, 15 Sep 2021 10:20:56 GMT

Good day expects.

am running the include statement however am getting the below error message.

Code /Script

/*03 - IMPORT PARAMETERS*/

DATA _NULL_;

%LET TABLE= &SYSPARM.;
CALL SYMPUT("TABLE",COMPRESS("&TABLE"));

RUN;

%MACRO IMPORT_MIG();

%INCLUDE "/SAS/data/Import_Migration/IMPORT_SOURCE_&TABLE..sas";

%MEND IMPORT_MIG;

%IMPORT_MIG();

LOG

1 The SAS System 10:16 Wednesday, September 15, 2021

1 ;*';*";*/;quit;run;
2 OPTIONS PAGENO=MIN;
3 %LET _CLIENTTASKLABEL='Program (4)';
4 %LET _CLIENTPROCESSFLOWNAME='Process Flow';
5 %LET _CLIENTPROJECTPATH='';
6 %LET _CLIENTPROJECTPATHHOST='';
7 %LET _CLIENTPROJECTNAME='';
8 %LET _SASPROGRAMFILE='';
9 %LET _SASPROGRAMFILEHOST='';
10
11 ODS _ALL_ CLOSE;
12 OPTIONS DEV=PNG;
13 GOPTIONS XPIXELS=0 YPIXELS=0;
14 FILENAME EGSR TEMP;
15 ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR
16 STYLE=HtmlBlue
17 STYLESHEET=(URL="file:///C:/Program%20Files/SASHome/SASEnterpriseGuide/7.1/Styles/HtmlBlue.css")
18 NOGTITLE
19 NOGFOOTNOTE
20 GPATH=&sasworklocation
21 ENCODING=UTF8
22 options(rolap="on")
23 ;
NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR
24
25 GOPTIONS ACCESSIBLE;
26 %MACRO IMPORT_MIG();
27
28 %INCLUDE "/SAS/data/RiskDataManagement/data/NWOW/data/VBM/BRACC/03_Scripts/Import_Migration/IMPORT_SOURCE_&TABLE..sas";
29
30 %MEND IMPORT_MIG;
31
32 %IMPORT_MIG();
WARNING: Physical file does not exist,
/SAS/data/RiskDataManagement/data/NWOW/data/VBM/BRACC/03_Scripts/Import_Migration/IMPORT_SOURCE_.sas.
ERROR: Cannot open %INCLUDE file
/SAS/data/RiskDataManagement/data/NWOW/data/VBM/BRACC/03_Scripts/Import_Migration/IMPORT_SOURCE_.sas.
33
34 GOPTIONS NOACCESSIBLE;
35 %LET _CLIENTTASKLABEL=;
36 %LET _CLIENTPROCESSFLOWNAME=;
37 %LET _CLIENTPROJECTPATH=;
38 %LET _CLIENTPROJECTPATHHOST=;
39 %LET _CLIENTPROJECTNAME=;
40 %LET _SASPROGRAMFILE=;
41 %LET _SASPROGRAMFILEHOST=;
42
43 ;*';*";*/;quit;run;
44 ODS _ALL_ CLOSE;
45
46
47 QUIT; RUN;
48

Re: Include statement not working

Kurt_Bremser — Wed, 15 Sep 2021 10:53:34 GMT

The message is very clear: the file does not exist.

Make sure that the spelling is 100% correct, UNIX is case sensitive.

And also see if the path is available in the context of the SAS session. E.g. log on to the SAS server with SSH and navigate to the path.

topic Re: Include statement not working in SAS Programming

Include statement not working

Re: Include statement not working