06-20-2013 01:19 PM
I have a report that generates a spreadsheet with multiple tabs. The code works on 9.2 32 bit server 2003 but when moved to 64 bit 9.3 I get a style error
I've narrowed it down to on part of the code that creates the error
WARNING: In Event: style_over_ride, Invalid Expression:
ERROR: WHERE clause operator requires numeric variables.
the ods part of the code is as follows. what has changed from 9.2 to 9.3?
ods tagsets.ExcelXP options(embedded_footnotes='yes' embedded_titles='yes'
suppress_bylines='yes' sheet_interval='bygroup' sheet_label=' '
autofit_height='yes' frozen_headers='3' center_horizontal ='yes');
ods tagsets.excelxp close;
06-20-2013 01:22 PM
Your error is in a WHERE statement, not shown.
The warning about a style override means some appearance may not be as desired in teh output and the overrides are not shown.
06-20-2013 02:45 PM
yep...someone wrote a custom template and some other code long ago I think the where was in there maybe because when I took it out the problem went away
06-20-2013 07:14 PM
When you have code that involves a custom template and involves TAGSETS.EXCELXP and different behavior between 9.2 and 9.3, then you have the perfect set of reasons to work with SAS Tech Support.
06-20-2013 07:18 PM
calling SAS is part of my plan.
today I went through as much of the code as I could to see what worked and try to make adjustments. I think many of the custom stuff is now doable in SAS....some of this stuff was written years ago.