msoffice2k percentage format in call define of proc report

Eva — Thu, 14 Jun 2012 12:27:41 GMT

Dear all,

I have a proc report which I output to ods tagset.msoffice2k. I use SAS 9.2 and Office XP.

In the proc report I'd like to format a number with the format percent10.2. Here is the code for the html output which works:

compute myfield;

call define(_col_,'FORMAT',"percent10.2");

endcomp;

Can anybody tell me how to do this for the tagset msoffice2k ?

In a define statement this works with msoffice2k:

define myfield2 / style={htmlstyle='mso-number-format:0.00%'};

Unfortunately this does not work with the call define:

compute myfield;

call define(_col_,'style',"style=[htmlstyle='mso-number-format:0.00%']");

endcomp;

nor anything similar like:

call define(_col_,'style',"htmlstyle=['mso-number-format:0.00%']");

Best wishes

Eva

Re: msoffice2k percentage format in call define of proc report

Eva — Thu, 14 Jun 2012 12:49:26 GMT

Dear all,

I tried a little mor and was surprised what works:

compute myfield;

call define(_col_,'style','style={htmlstyle="mso-number-format:0.00%"}');

endcomp;

just changing the brackets to "style={htmlstyle='mso-number-format:0.00%'}" didn't work, but having single quotation marks around the style and double quotation marks around the mso-number-format worked.

Best wishes

Eva

topic Re: msoffice2k percentage format in call define of proc report in ODS and Base Reporting

msoffice2k percentage format in call define of proc report

Re: msoffice2k percentage format in call define of proc report