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();
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
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.