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

[hyejung7890]

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.

80

81

82 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

94

[Kurt_Bremser]

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.

[hyejung7890]

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. 

[hyejung7890]

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;

[andreas_lds]

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;

---

[hyejung7890]

Hi,
Many thanks for your reply.

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