BookmarkSubscribeRSS Feed
VALLY
Fluorite | Level 6

Good day expects.

 

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

 

Code /Script

Spoiler

/*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();



Spoiler
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




 

1 REPLY 1
Kurt_Bremser
Super User

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.

SAS Innovate 2025: Call for Content

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!

Submit your idea!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 417 views
  • 1 like
  • 2 in conversation