topic Re: Error: physical file does not exist Proc Import SAS On Demand for Academics in SAS Software for Learning Community

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

Agollenb — Thu, 15 Sep 2022 14:40:50 GMT

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;

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 */

74 %web_drop_table(WORK.IMPORT);

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

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.

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

Reeza — Thu, 15 Sep 2022 14:52:58 GMT

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.
 

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

Agollenb — Thu, 15 Sep 2022 14:59:35 GMT

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

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

Reeza — Thu, 15 Sep 2022 15:15:49 GMT

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.

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

Agollenb — Thu, 15 Sep 2022 15:22:39 GMT

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

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

Reeza — Thu, 15 Sep 2022 15:26:55 GMT

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.

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

Agollenb — Thu, 15 Sep 2022 15:27:08 GMT

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;

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;

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 */

77 %web_drop_table(WORK.IMPORT);

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

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

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

Agollenb — Thu, 15 Sep 2022 15:28:30 GMT

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.

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

Reeza — Thu, 15 Sep 2022 15:31:17 GMT

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;

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

Agollenb — Thu, 15 Sep 2022 15:35:40 GMT

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

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 */

74 %web_drop_table(WORK.IMPORT);

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

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

85 PROC CONTENTS DATA=WORK.IMPORT; RUN;

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

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

Agollenb — Thu, 15 Sep 2022 16:14:26 GMT

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

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

Reeza — Thu, 15 Sep 2022 16:54:35 GMT

Good catch!