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
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
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
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.