Manuel:

Bail on DBLOAD and instead check out the SAS docs for Proc Import/Export and the "sheet" option.

HTH

Later

At 05:59 PM 11/27/2000 -0500, Manuel Guerra wrote: >Can somebody tell me how (if possible) a second spreadsheet can be created >from a SAS v8.1 program. >The DBLOAD proc documentation says that you can output to Excel files, but >it does not tell me that I can select the Spreadsheet name to which it can >write to. > From my reading of the documentation It does not seem possible, but It may >be an inventive way to do this, maybe with DDE or something like that, until >the proc DBLOAD is upgraded to allow for this. > >I need to retain formats and formulas of an Excel Spreadsheet, which I can >keep in one Spreadsheet, but I need to have SAS to pass the data to another >spreadsheet in the same file and merge the best part of SAS with the best >part of Excel (from the two spreadsheets). > >To have a couple of files I can do this with cut and paste, but the >application call for thousands of different files to be shown and downloaded >from a website. > >The user will drop the whole web application if this can not be done since >they live and die by the Excel program and E-mailing. (We are trying to >convert to SAS and the web). > >Note: Each recipient individually will work with his/her Excel file >resulting from this application after logging on the web site and >downloading his/her file with multiple spreadsheets inside one Excel file.

---------------------------------------------------------------------------- William W. Viergever Voice : (916) 483-8398 Viergever & Associates Fax : (916) 486-1488 Sacramento, CA 95835 E-mail : wwvierg@ibm.net ----------------------------------------------------------------------------