Hi,
I have similar issue. The following code works fine in
1. Base SAS, E Guide ( SAS 9.1.3 SP4) but if I create a stored process(in E guide) and try to open through AMO ( MS Office 2007) gives error. Some times does create the excel file but with No frozen headers or filters.
2. Base SAS, E Guide ( SAS 9.2 TS2M2) but if I create a stored process(in E guide) and try to open through AMO ( MS Office 2007), it creates excel file but with No frozen headers or filters.
data a;
input subvar $ xvar mmddyy6. vbar_y plot_y;
datalines;
sub1 010196 10 8
sub1 020196 20 15
sub1 030196 30 55
sub1 040196 40 50
;
ods listing close;
ods tagsets.ExcelXP file="E:\Test\test6.xls" style=sasweb;
ods tagsets.ExcelXP options(sheet_name="mydata" frozen_headers='2' autofilter='all');
proc print data=a;
run;
ods tagsets.ExcelXP close;
ods listing;
Do you know if it is possible to convert existing ODS code containing especially(ExcelXP or msoffice2K tagsets) to a stored process so that it throws same results as in BaseSAS or Eguide?
Sunil
... View more
