Help using Base SAS procedures

infile statement issue

Reply
Occasional Contributor
Posts: 15

infile statement issue

proc import datafile= "‪C:\Users\Desktop\bankmarketing.csv"
out=bankmarketing
dbms=csv
replace;
delimiter=';';
getnames=yes;
run;

 

 

Error: physical file does not exist.

Error: import unsuccessful

Super User
Posts: 11,343

Re: infile statement issue

Are you working with a server? The file path would have to be visible from the server.

 

Which version of SAS are you running? University Edition uses 1) Linux path descriptions and 2) the file system starts with the shared folder and not the desktop, the file would have to be in the shared folder set up in the VM AND file path and names are case sensitive.

 

Generally "desktops" are very poor places for data files. Learn your file system and put them somewhere meaningful. And doesn't "USERS" have an actual user name afterwards?

Occasional Contributor
Posts: 15

Re: infile statement issue

the datasets is taking from uci machine learning. i don't know why am find it difficult to access the data.

Super User
Posts: 7,854

Re: infile statement issue

If you are using SAS UE or a server-based SAS, this:

proc import datafile= "‪C:\Users\Desktop\bankmarketing.csv"

can never work, as neither the UE virtual machine nor a server can "see" your C: drive.

 

So it is now essential that you reveal which SAS environment you are using.

 

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Trusted Advisor
Posts: 1,022

Re: infile statement issue

Are you missing a userid in the path (as in MYUSERID below)?

 

Usually it would be "c:\users\MYUSERID\Desktop\bankmarketing.csv"

Occasional Contributor
Posts: 15

Re: infile statement issue

Thank you for concern. I changed my datasets to German credit. I have finished the task already.

Ask a Question
Discussion stats
  • 5 replies
  • 190 views
  • 0 likes
  • 4 in conversation