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.
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
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.
Ready to level-up your skills? Choose your own adventure.