About cooool

cooool · ‎07-14-2015

Thank you. I have contacted Tech support. She said the problem was my tagset file is old. Once I use the shipped version of the tagset, the program runs without errors. One can also add "ODS path sashelp.tmplmst(read); " to direct the program to use the latest tagset.

cooool · ‎07-10-2015

Thanks for your reply. Those were transcription errors. In my real program, format is working. I tried creating svar and I still got the same error. I suspect it is related to version of ExcelXP and version of SAS (9.3). the error came from ExcelXP - define event style_over_ride ; ...... if ^$style_overrides [$key]; set $cell_class lowcase(htmlclass); do / if contains ($cell_class,"ata") | contains ($cell_class, "eader"); /*Header*/ set $cell_class $cell_class "___" just /if ^$style_with_just[$cell_class]; done; do / if $style_list[$cell_class]; set $cell_class $cell_class "__"; eval $style_list[$cell_class] $style_list[$cell_class] + 1; <-- error came from here else; eval $style_list[$cell_class] 1; done

cooool · ‎07-09-2015

Hi all, I used ExcelXP.sas to create a .xml in SAS 9.1.3. The program worked fine. But after upgraded to SAS9.3, I got this error: Warning: In Event: style_over_ride, Invalid Expression: eval $style_list[$cell_class] $style_list[$cell_class] + 1 in a nutshell, I want to do traffic lighting in compute block based on the value of variables : proc format ; value color 0='black', 1='yellow', 2='red'; value fntsyle 0='roman' 1='italic'; run; Dataset: Var1 Var2 Var3 grade 0 0 0 grade 2 1 0 grade 4 2 1 ODS tagsets.excelXP options (sheet_interval='bygroup' suppress_bylines='yes' frozen_headers='yes'); proc report nowindows; column var1 var2 var3 dummy; define var1/display; define var2/display noprint; define var3/display noprint; define dummy/computed noprint; compute dummy; call define ('var1', 'style', 'style=[background=' || put (var2, color.) || ' font_style=' || put (var3, fntstyle.) || ']' ); endcomp; run; quit;

Online Status	Offline
Date Last Visited	‎09-01-2015 07:12 AM

Re: ExcelXP -- Warning: In Event: style_over_ride, Invalid expression

Re: ExcelXP -- Warning: In Event: style_over_ride, Invalid expression

ExcelXP -- Warning: In Event: style_over_ride, Invalid expression

Re: ExcelXP -- Warning: In Event: style_over_ride, Invalid expression

Re: ExcelXP -- Warning: In Event: style_over_ride, Invalid expression

Re: ExcelXP -- Warning: In Event: style_over_ride, Invalid expression

ExcelXP -- Warning: In Event: style_over_ride, Invalid expression