DATA Step, Macro, Functions and more

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

Reply
N/A
Posts: 1

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

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?


Attachment
Valued Guide
Posts: 2,177

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

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

Super Contributor
Posts: 273

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

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

Ask a Question
Discussion stats
  • 2 replies
  • 375 views
  • 0 likes
  • 3 in conversation