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.
Yep. There are all sorts of things you can do. borders, fonts, colors, just like in HTML, RTF and PDF... Within the limitations of Excel of course. Url style links work too so it is possible
to create drill down reports...
Gentle suggestion to the OP with these forum submissions - create a new post which you author and paste a link to a prior post, if useful -- suggest not piggy-backing on a 2 year old post from someone else.
SAS Forums Admin: This concern along with other forum posting guidelines really needs to be added as a sticky on the main page, if that is possible?
In the future, it really would be better to start an new post and then refer back to this post.
For TABULATE purposes, the VAR statement STYLE= override only impacts the variable HEADER cells. To impact the calculated statistics for one variable differently from another variable, you would need to use the STYLE= override in the table statement.