I am expecting data as shown below Dollars $23,100 $5,183 $3,326 $2,070 $18 $0 but i am getting the data as below Dollars $23,100 $5,183 $3,326 $2,070 $18 $ when i click on the cell it shows 0 but it displays as $. what i shoul do to display as $0 Please see the code below and the code is customized for security purposes. proc format picture dfmt (round) low - < 0 = '0000,009)' (mult=.001 prefix='($') 0 - high = '000,009' (mult=.001 prefix='$'); run; ods tagsets.excelxp file = "test.xls" ; ods tagsets.ExcelXP options(embedded_titles="no" autofit_height="yes" autofit_width="yes" sheet_interval="none" ABSOLUTE_COLUMN_WIDTH='10' sheet_name=test") proc report data =test; column amt; define amt / order order=data "Dollars "; compute amt; if amt> 0 then do; call define (_col_,"format","dfmt."); call define (_col_,"style","style={tagattr='format:$###,###'}"); end; else if amt < 0 then do; call define (_col_,"format","dfmt."); call define (_col_,"style","style={tagattr='format:$###,###'}"); end; else do; call define (_col_,"format","dollar4."); call define (_col_,"style","style={tagattr='format:$#'}"); end; endcomp; run; ods tagsets.excelxp close;
... View more
