topic proc import error in New SAS User

proc import error

saipriya92 — Mon, 05 Aug 2019 20:06:22 GMT

What is wrong in this statement ?

proc import datafile="C:\Users\manya\Documents\DATA\BRFFS_data.xls" 
	dbms = xls
	out = work.data1 
	replace ;
	getnames = YES ;
run ;

the log says this

 
 1          OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 70         
 71         proc import datafile="C:\Users\manya\Documents\DATA\BRFFS_data.xls"
 72         dbms = xls
 73         out = work.data1
 74         replace ;
 75         getnames = YES ;
 76         run ;
 
 ERROR: Physical file does not exist, /pbr/biconfig/940/Lev1/SASApp/C:\Users\manya\Documents\DATA\BRFFS_data.xls.
 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              685.90k
       OS Memory           27028.00k
       Timestamp           08/05/2019 08:04:30 PM
       Step Count                        70  Switch Count  0
       Page Faults                       0
       Page Reclaims                     146
       Page Swaps                        0
       Voluntary Context Switches        0
       Involuntary Context Switches      0
       Block Input Operations            0
       Block Output Operations           0
       
 77         
 78         
 79         
 80         
 81         
 82         
 83         OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 95

Re: proc import error

SASKiwi — Mon, 05 Aug 2019 20:26:09 GMT

There is nothing syntactically wrong with your program but it looks like you are making the classic mistake of trying to read a spreadsheet stored on your local PC drive, but SAS runs on a remote Unix server. The clue is here - /pbr/biconfig/940/Lev1/SASApp/ - this is the SAS installation folder on a Unix server.

You need to move the spreadsheet to a folder readable by your SAS server. I suggest you talk to your SAS administrator to identify where that is. If you are using SAS Enterprise Guide it contains a task for copying your spreadsheet (or files in general) to the SAS server.

Re: proc import error

Kurt_Bremser — Tue, 06 Aug 2019 08:32:50 GMT

Just to add:

This part

/pbr/biconfig/940/Lev1/SASApp/

is the Current Working Directory (CWD) of your SAS workspace server process on the UNIX server.

You do not have write permissions there (unless your SAS admin erred catastrophically during the installation), so you need to put your file somewhere where you have those permissions. One place is your home directory, where you MUST have write permission for anything to work, and where you automatically "land" when logging on to the server directly (ie with WinSCP) using your SAS credentials.

In your code, you can use $HOME to address this home directory:

proc import datafile="$HOME/BRFFS_data.xls"