Hello Jenny,
The thousands separator option is to indicate what the separator is, so it can be detected by
the tagset. Numbers cannot have anything in them except numbers and a decimal separator as
recognized by your version of Excel. So all formatting that occurs in SAS must be removed before
numbers will be numbers in Excel.
That works fine, except all SAS formatting is lost. The Tagset detects numbers and currency, and percentages, and sets the formats and types for those things. If you don't want the standard Excel number format, then an excel format needs to be applied to that column in your report.
In proc report;
define mynumber / style = {tagattr="format:###,###,###"};
Here is a fancier format for 2 columns in proc print.
var predict actual / style={tagattr='format:$#,##0_);[Red]\($#,##0\)'};
It is not generally necessary to force the type of a variable, but if that comes up, this is how
you would do that.
var weight / style(data)={tagattr="type:Number format:#0.00"};
Tagattr also allows for rotating the text in the cell and hiding the row.
style = {tagattr="rotate:45"};
style = {tagattr="hidden:yes"};
... View more