Hi:
As far as I know, you cannot put DDE calls into a Stored Process (SP). If you have the SAS Add-in for Microsoft Office, for example, you would create a multi-sheet workbook by opening Excel, running your SP and then choosing where the SP populates in the sheet. To populate a new sheet, you would run a second SP and tell that SP where to populate (new sheet, existing sheet, new workbook).
Your scenario :
My SP needs to write out the results into specific cell ranges in the Data tab that will populate all the metrics required in the report tab.
sounds like the kind of thing that folks do with Excel -- have a Data tab that feeds a report tab. Is it not possible to produce all your metrics -- what's in your report tab with SAS???? If the information from the DATA tab is coming from SAS, there's a very good chance that you don't need it anymore and can go straight to producing the report with SAS -- that's the beauty of the Enterprise Intelligence Platform - you have the ability to create complex analytical reports without going through the whole Data tab/Report tab scenario.
The SAS Add-in for Microsoft Office is .COM technology. There is no automated way, that I know of to make an SP automatically open an existing sheet, populate an existing sheet or automatically save a sheet.
On the other hand, -outside- the world of the SAS Add-in, you still have the ability to run batch jobs and those batch jobs could, theoretically, run programs to create files for the users to open in the morning. However, if the batch job requires user-input (such as to supply parameters), then you may not be able to use batch jobs to create your Excel file.
One thing you might do is consult with Tech Support to see whether they have any other suggestion for what you want to do. At the very least, they could take a look at what's on your Report tab and make some recommendations about how to produce the report with SAS procedures/programs in a SP.
cynthia