BookmarkSubscribeRSS Feed
rajiv436
Fluorite | Level 6

Hi,

I'm trying to import several files into SAS EG 5.1 from local machine, after executing proc import procedure i'm getting the below error.

 

15 proc import datafile='C:\Users\admin\Desktop\CpiSampleData.xls' out=asdf dbms=xls;
16 run;

ERROR: Physical file does not exist, /SASCONF/conf93/Lev1/SASApp/C:\Users\admin\Desktop\CpiSampleData.xls.
NOTE: The SAS System stopped processing this step because of errors.

 

If i use dbms as excel it pops the error not a valid dbms.

 

15 proc import datafile='C:\Users\admin\Desktop\CpiSampleData.xls' out=asdf dbms=excel;
ERROR: DBMS type EXCEL not valid for import.
NOTE: The SAS System stopped processing this step because of errors.

 

Please help on this.

 

 

 

Thanks& Regards,
Rajiv Santosh.
4 REPLIES 4
BrunoMueller
SAS Super FREQ

Hi

 

From the error message it looks like your code is running on a Unix/Linux using SAS9.3

 

Your SAS server does not have access to your local filesystem on your PC

 

Use the File -> Import Data task to import xls files

 

Bruno

Kurt_Bremser
Super User

Your SAS is running in UNIX, so you won't be able to import .xls files with PROC IMPORT, as that only works on Windows (requires MS-supplied Windows-only module).

Importing .xlsx is possible on any platform starting with SAS version 9.4.

Either set up a PC Files Server on your Windows machine, or export to a platform-independent file transfer format (.CSV) and store that file in a location that is accessible by your UNIX SAS server; or transfer the file via SFTP to that server.

(export to .csv from Excel, use WinSCP or similar to log onto your SAS server with your ID/PW used in Enterprise Guide, store to your home directory, and then use '$HOME/filename.csv' as your infile)

 

If you could be a little more specific about your setup, we could provide more help.

 

 

rajiv436
Fluorite | Level 6

Thanks 

 

Thanks& Regards,
Rajiv Santosh.

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 4 replies
  • 1417 views
  • 0 likes
  • 3 in conversation