q**j
发帖数: 10612 | 1 if column:
look at tagattr
proc report data = yourdata nowd;
define money / style(column) = {tagattr =$#,##0};
define percentage / style(column) = {tagattr =0%};
define order / style(column)=[background = Light Orange];
run;
if row:
use compute block and do something similar. |
|
d******9
发帖数: 404 | 2 Finally, I find below info from SAS support.
Usage Note 32414: How can I prevent loss of leading zeroes when generating
Microsoft Excel output with ODS
http://support.sas.com/kb/32/414.html
Microsoft Excel uses the general format when importing data values that do
not have an Excel format applied. This general format attempts to determine
how the value should be formatted. For example, an account number that is
not alpha numeric and has leading zeroes will lose the leading zero. The
same problem... 阅读全帖 |
|
q**j
发帖数: 10612 | 3 定义列的格式就是用我说的format. 用 {tagattr ='#,##0'}
其他的格式你用excel做好，存成xml，就可以在特定的地方看到这样的格式写法。
定义行的格式我没有试过，应该类似。你给sas打电话好了。 |
|
y****d
发帖数: 432 | 4 ★★★★★★★★★★★★★★★★★★★★★★★★★★★★★
前面说明：
需要的童鞋请到我的签名档的博客查找！谢谢！发E-mail太累了！
觉得有价值的话可以顶一下，以便更多的人看到！谢谢！
★★★★★★★★★★★★★★★★★★★★★★★★★★★★★
SAS2010全球论坛文章
1-10
Getting Connected to Your Data with SAS/CONNECT®
A Robust and Flexible Approach to Automating SAS® Jobs Under UNIX
Using SAS® Output Delivery System (ODS) Markup to Generate Custom
PivotTable and PivotChart Reports
Creating Easily Reusable and Extensible Processes: Code That Thinks for
Itself
ODS HTML Evolution, HTML that scrolls, panels, ... 阅读全帖 |
|
l****u
发帖数: 529 | 5 This one:define your_variable_name / display style(column)={tagattr='format:
##0.0'};?
This one: your_variable_name
/ style(column)={htmlstyle="mso-number-format:\@"} |
|
