Error: physical file does not exist Proc Import SAS On Demand for Academics

[Agollenb]

Hello, I have been using SAS On Demand for awhile now and recently having trouble with the Proc Import process.

I get the following error, and it seems to be something odd with a double slash. Can someone please help me? I've been doing the import process in SAS On Demand for awhile and never had this problem! My file is already has already been uploaded to the SAS On Demand online system.

OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

68

69 /* Generated Code (IMPORT) */

70 /* Source File: CLEAN.3Month.InfantDrivenFeeding3M.DATA_2022.Final.xlsx */

71 /* Source Path: /home/agollenb0 */

72 /* Code generated on: 9/15/22, 10:02 AM */

73

74 %web_drop_table(WORK.IMPORT);

75

76

77 FILENAME REFFILE '/home/agollenb0/CLEAN.3Month.InfantDrivenFeeding3M.DATA_2022.Final.xlsx';

78

79 PROC IMPORT DATAFILE=REFFILE

80 DBMS=XLSX

81 OUT=WORK.IMPORT;

82 GETNAMES=YES;

83 RUN;

ERROR: Physical file does not exist, /home/agollenb0//CLEAN.3Month.InfantDrivenFeeding3M.DATA_2022.Final.

NOTE: The SAS System stopped processing this step because of errors.

[Reeza]

Find the file under Servers Folders and Files, right click it and select properties. Copy the path from the file to the your code and see if that works. If it doesn't, please show a screenshot of the properties pane.

---

@Agollenb wrote:

Hello, I have been using SAS On Demand for awhile now and recently having trouble with the Proc Import process.

I get the following error, and it seems to be something odd with a double slash. Can someone please help me? I've been doing the import process in SAS On Demand for awhile and never had this problem! My file is already has already been uploaded to the SAS On Demand online system.

OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

68

69 /* Generated Code (IMPORT) */

70 /* Source File: CLEAN.3Month.InfantDrivenFeeding3M.DATA_2022.Final.xlsx */

71 /* Source Path: /home/agollenb0 */

72 /* Code generated on: 9/15/22, 10:02 AM */

73

74 %web_drop_table(WORK.IMPORT);

75

76

77 FILENAME REFFILE '/home/agollenb0/CLEAN.3Month.InfantDrivenFeeding3M.DATA_2022.Final.xlsx';

78

79 PROC IMPORT DATAFILE=REFFILE

80 DBMS=XLSX

81 OUT=WORK.IMPORT;

82 GETNAMES=YES;

83 RUN;

ERROR: Physical file does not exist, /home/agollenb0//CLEAN.3Month.InfantDrivenFeeding3M.DATA_2022.Final.

NOTE: The SAS System stopped processing this step because of errors.

---

[Agollenb]

Here is the screenshot. I believe the path is correct. Still showing errors. I also tried in Chrome.

[Reeza]

You didn't do the copy/paste...your picture shows a folder MT2 but that's not in your path before the file name.

---

@Agollenb wrote:

Here is the screenshot. I believe the path is correct. Still showing errors. I also tried in Chrome.

---

[Agollenb]

I used the auto generated proc import. I verified the path.

[Reeza]

Post the error from that last screenshot to confirm it's the same error as your original post. 

Please also note that your screenshot does not show the path included in your first post. 

[Agollenb]

Here is the error output: I can't figure out why there is an extra slash in the error code.

 Errors (2)

 Warnings

 Notes (7)

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

68

69 libname MT2 "/home/agollenb0/MT2";

NOTE: Libref MT2 refers to the same physical library as _TEMP6.

NOTE: Libref MT2 was successfully assigned as follows:

Engine: V9

Physical Name: /home/agollenb0/MT2

70 run;

71

72 /* Generated Code (IMPORT) */

73 /* Source File: 3Month.xlsx */

74 /* Source Path: /home/agollenb0/MT2 */

75 /* Code generated on: 9/15/22, 11:10 AM */

76

77 %web_drop_table(WORK.IMPORT);

78

79

80 FILENAME REFFILE '/home/agollenb0/MT2/3Month.xlsx';

81

82

83

84 PROC IMPORT DATAFILE=REFFILE

85 DBMS=XLSX

86 OUT=WORK.IMPORT;

87 GETNAMES=YES;

88 RUN;

ERROR: Physical file does not exist, /home/agollenb0/MT2//3Month.

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE IMPORT used (Total process time):

real time 0.00 seconds

[Agollenb]

I tried renaming the file. And it still doesn't work. I'm sorry for the trouble, I have a big deadline and cannot figure out why my data will not import.

[Reeza]

None of the code or errors posted match your screenshots. 

Post the log from teh following but I can't be sure that the file name is correct because it's cut off in your shots. Note that the file paths are case sensitive which is why I'm saying to copy/paste the filepath from the properties.

FILENAME REFFILE '/home/agollenb0/MT2/CLEAN.3Month.InfantDrivenFeeding3M.DATA_2022.Final.xlsx';

 PROC IMPORT DATAFILE=REFFILE
 DBMS=XLSX
 OUT=WORK.IMPORT;
 GETNAMES=YES;
 RUN;

[Agollenb]

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

68

69 /* Generated Code (IMPORT) */

70 /* Source File: CLEAN.3Month.InfantDrivenFeeding3M.DATA_2022.Final.xlsx */

71 /* Source Path: /home/agollenb0/MT2 */

72 /* Code generated on: 9/15/22, 11:33 AM */

73

74 %web_drop_table(WORK.IMPORT);

75

76

77 FILENAME REFFILE '/home/agollenb0/MT2/CLEAN.3Month.InfantDrivenFeeding3M.DATA_2022.Final.xlsx';

78

79 PROC IMPORT DATAFILE=REFFILE

80 DBMS=XLSX

81 OUT=WORK.IMPORT;

82 GETNAMES=YES;

83 RUN;

ERROR: Physical file does not exist, /home/agollenb0/MT2//CLEAN.3Month.InfantDrivenFeeding3M.DATA_2022.Final.

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE IMPORT used (Total process time):

real time 0.00 seconds

user cpu time 0.01 seconds

system cpu time 0.00 seconds

memory 2355.87k

OS Memory 28840.00k

Timestamp 09/15/2022 03:33:22 PM

Step Count 119 Switch Count 0

Page Faults 0

Page Reclaims 511

Page Swaps 0

Voluntary Context Switches 3

Involuntary Context Switches 0

Block Input Operations 0

Block Output Operations 0

84

85 PROC CONTENTS DATA=WORK.IMPORT; RUN;

ERROR: File WORK.IMPORT.DATA does not exist.

[Agollenb · Accepted solution]

I figured it out! It was because the spreadsheet was password protected!

[Reeza]

Good catch!