tabulate and negative numbers in Excel

steve_citi — Mon, 21 Jun 2010 01:32:19 GMT

I am using Excexp tagset and cannot seem to get negative numbers to come out as numeric. They are currently coming out as text.

My code looks correct, but I cannot seem to get it to work.
[pre]
glrecovery =''*sum='Recovery $' *f=dollar21.2*
[style=[tagattr="format:$###,###,## ; $-###,###,##"]]
[/pre]

Re: tabulate and negative numbers in Excel

Cynthia_sas — Mon, 21 Jun 2010 13:49:26 GMT

Hi:
I find that if I remove the dollar21.2 from the SAS end and ONLY have the Excel format, that in SAS 9.2 and Excel 2007 and tagset version v1.94, that the negative numbers -are- numeric fields in Excel. This means that any SAS output will not have $$, but if you are only using Excel, this should not be an issue.

cynthia
[pre]
data test;
set sashelp.class;
glrecovery = height *weight*age;
if sex = 'F' then glrecovery = glrecovery * -1;
run;

ods html file='c:\temp\testneg.html' style=sasweb;
ods tagsets.excelxp file='c:\temp\testneg.xls' style=sasweb;
proc tabulate data=test;
class age sex;
var glrecovery;
table sex*age,
glrecovery =''*sum='Recovery $' *f=best21.2*[style=[tagattr="format:$###,###,## ; $-###,###,##"]];
run;
ods _all_ close;
[/pre]

topic tabulate and negative numbers in Excel in ODS and Base Reporting

tabulate and negative numbers in Excel

Re: tabulate and negative numbers in Excel