DATA Step, Macro, Functions and more

Error Message "Physical Path doesn't exist" . Unable to Import CSV file from Physical Path

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 5
Accepted Solution

Error Message "Physical Path doesn't exist" . Unable to Import CSV file from Physical Path

[ Edited ]

Dear All,

 

I am mporting the CSV file form my local pc location .But Facing error as "Path Dosen't exist' for below code.Can any one help me what's wrong in my below code and how can I solve it

 

filename mycsvfile 'D:\Softwares\SASUniversityEdition\SuperstoreSales.csv' termstr=crlf;
proc import datafile=mycsvfile
      out=mylib.tableaudata
      dbms=csv
      replace;
run;

proc print data=mycsvfile;
run;
  

Accepted Solutions
Solution
‎05-15-2017 08:40 AM
Trusted Advisor
Posts: 1,356

Re: Error Message "Physical Path doesn't exist" . Unable to Import CSV file from Physical

[ Edited ]

Using SAS UE the filename path shoul be like:

 

filename mycsvfile '/folders/myshortcuts/My_Folders/SuperstoreSales.csv' termstr=crlf;

 

View solution in original post


All Replies
Super User
Posts: 6,928

Re: Error Message "Physical Path doesn't exist" . Unable to Import CSV file from Physical

If you are using SAS University Edition, you have tro use the proper UNIX path to your shared folder.

 

In case of ERRORs, always post the log. Use the {i} button to open a window that preserves the text formatting.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Solution
‎05-15-2017 08:40 AM
Trusted Advisor
Posts: 1,356

Re: Error Message "Physical Path doesn't exist" . Unable to Import CSV file from Physical

[ Edited ]

Using SAS UE the filename path shoul be like:

 

filename mycsvfile '/folders/myshortcuts/My_Folders/SuperstoreSales.csv' termstr=crlf;

 

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 110 views
  • 0 likes
  • 3 in conversation