topic Re: Saving data set in specific excel sheet in SAS/IML Software and Matrix Computations

Saving data set in specific excel sheet

aya123 — Sun, 01 May 2011 11:46:27 GMT

How can I save sas data set in a specific excel sheet ?

MKhandelwal — Mon, 02 May 2011 09:48:01 GMT

You can use Proc Export.

Proc Export data= outfile='' replace;
Run;

aya123 — Tue, 03 May 2011 12:33:46 GMT

If I want to save sas data set in a specific sheet in the excel file suppose in sheet3, what can I do?

Rick_SAS — Tue, 03 May 2011 13:08:55 GMT

This question isn't related to SAS/IML, so I think it would be better to ask follow-ups in a different forum such as
http://support.sas.com/forums/forum.jspa?forumID=6

That said, here are two references you might find useful:
http://www.nesug.org/proceedings/nesug04/io/io09.pdf
http://www.lexjansen.com/pharmasug/2006/posters/po13.pdf

aya123 — Tue, 03 May 2011 18:50:50 GMT

thanks alot