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
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.