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

[jerry_h]

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?

[Peter_C]

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

[Andre]

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