Date: Fri, 8 Jan 1999 21:13:40 GMT
Reply-To: Douglas Small <dsmall@BPFL.COM>
Sender: "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From: Douglas Small <dsmall@BPFL.COM>
Subject: Export SAS data set directly to .xls file
Content-Type: text/plain; charset=us-ascii
I've been trying to Export a SAS data set to an .xls file (Excel 97
format) without involving Excel at all.
I have tried putting SAS variables into an Excel spread sheet using
_null_ data statements with 'Excel|System' commands, but find this more
difficult than manually exporting with the Export wizard in SAS. I have
also tried copying the SAS code created when exporting a SAS file to
.csv (comma delimited) with the export wizard, but this code is rather
cumbersome and difficult to apply to different data sets and I still
have to import it into excel.
Does anybody know of any efficient methods of exporting an entire SAS
data set to an .xls file? Your help is appreciated.
Thanks,
Doug
--
----------------------------------------
Douglas Small - Credit Policy
Em: dsmall@bpfl.com Ph: 407.370.7688
Banco Popular, N.A. (Florida)
U.S. Card Division
5551 Vanguard St., Suite 200
Orlando, FL 32819
----------------------------------------
| 
