Date: Thu, 13 Mar 2003 15:43:36 -0500
Reply-To: Dan Schuster <dan_schuster@MEDCOHEALTH.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Dan Schuster <dan_schuster@MEDCOHEALTH.COM>
Subject: SAS to Excel Question
We use DDE to copy Proc Freq Reports to Excel that have been going to a
couple of people. Since the end users were familiar with the reports they
were okay with the Sheet1-Sheetn names in the tabs. But know a wider group
of people will be looking at the reports and they would like more
meaningful sheet names.
For instance, the first sheet is for frequency by carrier, the second for
Does any one know how to dynamically change the sheet name to 'Carrier'
or 'Group_number' when exporting the SAS files to Excel. We are in a NT
environment using v8.2.