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?
pardon my lack of confident knowledge, but does proc import import from excel files on unix/linux?
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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.