topic Re: SAS onDemand for Academics_SAS programming activity_Error: physical file does not exist in New SAS User

SAS onDemand for Academics_SAS programming activity_Error: physical file does not exist

hyejung7890 — Thu, 07 Jan 2021 11:41:20 GMT

Good day,

I somehow keep getting the below error message while I carry out the activities for each lesson of SAS programming.

I have tried copying and pasting as well as typing each letters knowing it might be case-sensitive. Should I delete and re-download the EPG1V2 file?

Many thanks in advance.

-----------------------------------------------------------------------------------------

73 proc import datafile="home/u51562302/EPG1V2/data/np_traffic.csv"

74 dbms=csv

75 out=traffic

76 replace;

77 run;

NOTE: Unable to open parameter catalogue: SAS USER.PARMS.PARMS.SLIST in update mode. Temporary parameter values will be saved to

WORK.PARMS.PARMS.SLIST.

ERROR: Physical file does not exist, /home/u51562302/home/u51562302/EPG1V2/data/np_traffic.csv.

ERROR: Import unsuccessful. See SAS Log for details.

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

NOTE: PROCEDURE IMPORT used (Total process time):

real-time 0.02 seconds

user CPU time 0.02 seconds

system CPU time 0.01 seconds

memory 8217.25k

OS Memory 39196.00k

Timestamp 2021/01/07 11:34:20 AM

Step Count 61 Switch Count 5

Page Faults 0

Page Reclaims 1184

Page Swaps 0

Voluntary Context Switches 25

Involuntary Context Switches 0

Block Input Operations 0

Block Output Operations 8

78 proc contents data=traffic;

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

79 run;

NOTE: Statements not processed because of errors noted above.

NOTE: PROCEDURE CONTENTS used (Total process time):

real-time 0.00 seconds

user CPU time 0.00 seconds

system CPU time 0.00 seconds

memory 468.03k

OS Memory 34732.00k

Timestamp 2021/01/07 11:34:20 AM

Step Count 62 Switch Count 0

Page Faults 0

Page Reclaims 50

Page Swaps 0

Voluntary Context Switches 0

Involuntary Context Switches 0

Block Input Operations 0

Block Output Operations 8

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

82 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

Re: SAS onDemand for Academics_SAS programming activity_Error: physical file does not exist

Kurt_Bremser — Thu, 07 Jan 2021 11:45:58 GMT

On UNIX systems, you always need to use an absolute path (starting at the root directory). So your statement should be this:

proc import datafile="/home/u51562302/EPG1V2/data/np_traffic.csv"

Note the leading slash (indicates root as starting point) in the path name.

Re: SAS onDemand for Academics_SAS programming activity_Error: physical file does not exist

hyejung7890 — Fri, 08 Jan 2021 05:15:48 GMT

Thank you for your help!

I now see the output data but not the results. And it's still giving me:

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

What can I do?

Thank you for your time.

Re: SAS onDemand for Academics_SAS programming activity_Error: physical file does not exist

hyejung7890 — Fri, 08 Jan 2021 05:16:34 GMT

The new code I have is:

proc import datafile="/home/u51562302/EPG1V2/data/np_traffic.csv"
dbms=csv
out=traffic
replace;
run;

proc contents data=np_traffic;
run;

Re: SAS onDemand for Academics_SAS programming activity_Error: physical file does not exist

andreas_lds — Fri, 08 Jan 2021 06:18:48 GMT

I have marked the reason for the error message in your code:

@hyejung7890 wrote:
The new code I have is:

proc import datafile="/home/u51562302/EPG1V2/data/np_traffic.csv"
dbms=csv
out=traffic
replace;
run;

proc contents data=np_traffic;
run;

Re: SAS onDemand for Academics_SAS programming activity_Error: physical file does not exist

hyejung7890 — Fri, 08 Jan 2021 10:47:57 GMT

Hi,
Many thanks for your reply.

I assume that those highlighted ones must be the same?
i.e. np_traffic ?