topic Create a list of Excel files on Linux and then PROC IMPORT them. in SAS Programming

Create a list of Excel files on Linux and then PROC IMPORT them.

jerry_h — Thu, 19 Jul 2012 20:31:52 GMT

The program in question reads an established list of Excel spreadsheets residing in a Linux directory. The purpose of this step in the program is to pass a refined set of those file names to another location in Linux and then read them in, one at a time, for processing. I have tried the following using DATA _NULL_;FILE...;PUT...; It has not mattered if I allocate that file like /dir1/dir2/dir3/tempdir ro /dir1/dir2/dir3/tempdir/tempfile.dat. If I use just the directory (temdir) SAS says it has written the files but there is nothing in the directory. When I use the .dat approach, it does full that file but will not read it in proc import. Any ideas?

Re: Create a list of Excel files on Linux and then PROC IMPORT them.

Peter_C — Thu, 19 Jul 2012 21:29:22 GMT

pardon my lack of confident knowledge, but does proc import import from excel files on unix/linux?

Re: Create a list of Excel files on Linux and then PROC IMPORT them.

Andre — Fri, 20 Jul 2012 07:39:04 GMT

Hi Peter,

Yes this code is working under 9.2.3

filename s "~wi/tourism.xls";

proc export data=sashelp.tourism outfile=s replace dbms=xls;

newfile=yes; version=2003 ;run;

proc import datafile="~wi/tourisme.xls" out=sp4test dbms=xls;run;

proc import datafile="~wi/testpoursas.xls" out=sp4test3 dbms=xls;

sheet='Feuil2'n;

run;

proc import datafile="~wi/Fichecp.xls" out=sp4test4 dbms=xls;

sheet='Feuil1'n;

run;

Andre