I'm sorry for leaving out so many details. I am using the latest version of the ExcelXP tagset. This appears in the SAS log (NOTE: This is the Excel XP tagset (SAS 9.1.3, v1.86, 04/15/08)).
I am using the following to create the header and output:
DATA _NULL_;
RC = STPSRV_HEADER('Content-type','application/vnd.ms-excel;');
RC = STPSRV_HEADER('Content-disposition','attachment; filename=graduate_retention.xls');
RUN;
ods tagsets.excelxp file=_webout style=seaside_ft;
I am running the stored process from the Information Delivery Portal and I use a JSP page to collect the parameters.
The odd thing is that it works sometimes and not others. It seems to depend on which graduate program the user selects for the report.
I thought it might have something to do with the absolute_column_width so I made them wider but that didn't help. The resulting report is only 16 columns wide.
... View more