topic error running ods on 64 bit 9.3 in ODS and Base Reporting

error running ods on 64 bit 9.3

wkossack_nspirehealth_com — Thu, 20 Jun 2013 17:19:01 GMT

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=' '

width_fudge='.75' orientation='landscape'

absolute_column_width='68.5,90.5,150.5,130.5,100.5,100,68.5,68.5,68.5,68.5,68.5,68.5,68.5'

autofit_height='yes' frozen_headers='3' center_horizontal ='yes');

proc print...

run;

quit;

ods tagsets.excelxp close;

run;quit;

ods listing;

Re: error running ods on 64 bit 9.3

ballardw — Thu, 20 Jun 2013 17:22:56 GMT

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.

Re: error running ods on 64 bit 9.3

wkossack_nspirehealth_com — Thu, 20 Jun 2013 18:45:50 GMT

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

Re: error running ods on 64 bit 9.3

Cynthia_sas — Thu, 20 Jun 2013 23:14:39 GMT

Hi:

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.

cynthia

Re: error running ods on 64 bit 9.3

wkossack_nspirehealth_com — Thu, 20 Jun 2013 23:18:57 GMT

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.