topic Re: ERROR: Physical file does not exist in New SAS User

ERROR: Physical file does not exist

Veer1 — Tue, 22 Jun 2021 19:19:26 GMT

Hi,

I am new to the SAS community and I am using the SAS On Demand for academics browser version and I want to know how can I define the input and output path and also set the working directory?

Thanks

Re: ERROR: Physical file does not exist

Kurt_Bremser — Tue, 22 Jun 2021 19:34:40 GMT

On Demand runs on a UNIX cloud server where you have a home directory (/home/user-id). You upload to that location when you upload files with SAS Studio.

Don't rely on the concept of a working directory, always use an absolute path for files.

Re: ERROR: Physical file does not exist

Kurt_Bremser — Tue, 22 Jun 2021 19:36:04 GMT

Since you get a "file does not exist" error, please post your code and log.

Re: ERROR: Physical file does not exist

ballardw — Tue, 22 Jun 2021 19:36:14 GMT

On demand is a cloud based service. So you upload files to their storage area, work there and then download results. You can create folders in your work "area" but "path", if you are thinking your computer hard drive, is right out.

Re: ERROR: Physical file does not exist

Reeza — Tue, 22 Jun 2021 19:59:56 GMT

All files are stored on the cloud server.

You can set your working directory the same way as in desktop.

For file paths, it's usually under this main file path:

/home/fkhurshed/

If you go to the Servers Files and Folders pane you can see the folder structure. In that pane you can right click any file/folder and select properties. The full path will be there for you to use in your code.

@Veer1 wrote:

Hi,

I am new to the SAS community and I am using the SAS On Demand for academics browser version and I want to know how can I define the input and output path and also set the working directory?

Thanks

Re: ERROR: Physical file does not exist

Veer1 — Tue, 22 Jun 2021 21:08:23 GMT

options nodate pageno=1;
title; footnote; libname _all_;

%Let infile= "~/home/u58836540/TRY-SAS/Base_Report_raw_data.xlsx";
%Let outpath=~/home/u58836540/TRY-SAS/Output;/

options validvarname=v7;
PROC IMPORT DATAFILE=&infile
OUT=Base
DBMS=XLSX REPLACE;
GETNAMES=YES;
SHEET='CLOC & IMS';
RUN;

Re: ERROR: Physical file does not exist

Reeza — Tue, 22 Jun 2021 21:43:01 GMT

Please include the log as well.

Re: ERROR: Physical file does not exist

Veer1 — Tue, 22 Jun 2021 21:55:05 GMT

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

74 %Let infile= "~/home/u58836540/TRY-SAS/Base_Report_raw_data.xlsx";/* Change the file path */

75 %Let outpath=~/home/Output;/* Change the file path */

78 ****************************************

79 READ IN DEVELOPMENT DATA

80 ***************************************;

81 options validvarname=v7;

82 PROC IMPORT DATAFILE=&infile

83 OUT=Base

84 DBMS=XLSX REPLACE;

85 GETNAMES=YES;

86 SHEET='CLOC & IMS';

87 RUN;

ERROR: Physical file does not exist, /home/u58836540/home/u58836540/CTE-SAS//Baseline_Report_raw_data.

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.00 seconds

system cpu time 0.00 seconds

memory 2054.21k

OS Memory 33700.00k

Timestamp 22/06/2021 09:51:38 PM

Step Count 145 Switch Count 0

Page Faults 0

Page Reclaims 462

Page Swaps 0

Voluntary Context Switches 0

Involuntary Context Switches 0

Block Input Operations 0

Block Output Operations 0

90 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

102

Re: ERROR: Physical file does not exist

Tom — Tue, 22 Jun 2021 21:58:13 GMT

You have included your home directory twice in the path. Once use the Unix trick of just use tilda character. And them as subdirectories of your home directory. Use one method or the other.

%let infile= "/home/u58836540/TRY-SAS/Base_Report_raw_data.xlsx";
%let infile= "~/TRY-SAS/Base_Report_raw_data.xlsx";

Re: ERROR: Physical file does not exist

Veer1 — Tue, 22 Jun 2021 22:06:57 GMT

same error even when i used these options

Re: ERROR: Physical file does not exist

Reeza — Tue, 22 Jun 2021 22:19:39 GMT

options validvarname=v7;
PROC IMPORT DATAFILE="/home/u58836540/TRY-SAS/Base_Report_raw_data.xlsx"
OUT=myData
DBMS=XLSX REPLACE;
SHEET='CLOC & IMS';
RUN;

Please post the log from exactly the code above.

Re: ERROR: Physical file does not exist

Veer1 — Tue, 22 Jun 2021 23:12:26 GMT

I did not create a library earlier which was the reason for the error.