Hi:
I'm not sure what you mean...if you mean the value for mso-number-format as a style attribute is not being applied how you want??? If you mean to conditionally change ONE cell in a report row, they you could do this...let's say this is your COLUMN statement and you want VAR1 and VAR2 to have one mso-number-format and XXX to have a different mso-number-format:
[pre]
column var1 var2 xxx;
compute xxxx;
if _break_ ne '_RBREAK_' then do;
call define('var1','style','style={........}');
call define(''var2', 'style',"style={.......}");
call define(_col_,'style',"style=(......)");
end;
endcomp;
[/pre]
Rather than using CALL DEFINE on the entire ROW, you could set attributes, including HTML style and mso-number-format separately for each report item. I don't know what the mso-number-format is for percent, which is why I didn't show anything here...that's because I find I always have to look in the Microsoft doc or reverse engineer the mso-number-format everytime I do something out of the ordinary (decimal places, currency and dates).
I'm not sure what you mean by a problem with the quotation, you can nest single quotes inside double quotes and vice versa. If you need to, you can use macro quoting function to quote or unquote or protect your values.
Also, in SAS 9.2, you can investigate the new possibilities of 'STYLE/MERGE' and 'STYLE/REPLACE' in the CALL DEFINE statement -- which can have an impact on how you specify style attributes in multiple places.
http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/a002473624.htm
describes:
In SAS 9.2, the STYLE and STYLE/REPLACE attributes specify the style element to be used for the Output Delivery System. If a style already exists for this cell or row, these STYLE attributes tell CALL DEFINE to replace the style specified by the STYLE= value. The STYLE/MERGE attribute tells CALL DEFINE to merge the style specified by the STYLE= value with the existing style attributes that are in the same cell or row. If there is no previously existing STYLE= value to merge, STYLE/MERGE acts the same as the STYLE or STYLE/REPLACE attributes. See Using Style Elements in PROC REPORT for more details.
Restriction: This option affects only the HTML, RTF, Printer destinations.
If you continue to have issues, you might consider opening a track with Tech Support, as they could look at all your code and your data and consider your ODS destination (ODS HTML, ODS TAGSETS.EXCELXP, ODS MSOFFICE2K??) and help you come up with the best solution.
cynthia
... View more
