Prev: proc logistic with odds ratio in output table
Next: ? countw
From: Yi on 7 May 2010 12:54
I am using the tagsets.excelXP with the style set to minimal to output
to an excel file. The code works for over a year without any problem
until this month.

If I use a different style, such as Statistical, excel opens the file
with no problems. The following is my ods setting. Thanks.

FILENAME F1 "c:\temp\haha.xls" ;

ods tagsets.excelxp file=f1 style=minimal
options(
embedded_titles='no'
embedded_footnotes='no'
frozen_headers='yes'
frozen_rowheader ='1'
Autofit_height='yes'
)
RS = NONE ;

PROC PRINT DATA=sashelp.class;

run;

ods tagsets.excelxp close;
 | 
Pages: 1
Prev: proc logistic with odds ratio in output table
Next: ? countw