topic Re: Importing several files into SAS in SAS Programming

Importing several files into SAS

rajiv436 — Tue, 05 Apr 2016 07:08:41 GMT

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.

Re: Importing several files into SAS

BrunoMueller — Tue, 05 Apr 2016 07:22:18 GMT

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

Re: Importing several files into SAS

Kurt_Bremser — Tue, 05 Apr 2016 07:52:53 GMT

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.

Re: Importing several files into SAS

rajiv436 — Tue, 05 Apr 2016 08:47:36 GMT

Thanks KurtBremser. I got the a very smart answer from you and came to know another way with PC files server.

May i know how to use PC files server for excel files import ? Where can i get the detailed information about it?

Thanks alot for the above information.

Re: Importing several files into SAS

Kurt_Bremser — Tue, 05 Apr 2016 08:56:46 GMT

Instructions for installing and using the PC Files Server 9.3 can be found here: http://support.sas.com/kb/43/802.html