ods _all_ close;
ods listing close;
ods tagests.excelxp path ="C:\users"
file = "price.xls" style=minimal;
ods tagsets.excelxp
options(sheet_name= 'time'
frozen_headers="yes"
absolute_column_width='8.75, 6.25, 10.57, 7.43, 15, 8.14, 30.86, 10.57'
autofit_height='yes');
proc report data=Driver_Disc_Def nowd
STYLE(REPORT) = [BACKGROUND=WHITE FOREGROUND=BLACK]
STYLE(COLUMN) = [BACKGROUND=WHITE FOREGROUND=BLACK FONT_SIZE=2]
STYLE(HEADER) = [BACKGROUND=WHITE FOREGROUND=BLUE BOLD FONT_SIZE=2];
columns xx yy ;
define yy /'yy' display style={tagattr='format:##0.0000'};
run;
ods _all_ close;
still same error
22 GOPTIONS ACCESSIBLE;
23 ods _all_ close;
24 ods listing close;
25 ods tagests.excelxp path="C:\users"
26 file = "price.xls" style=minimal;
WARNING: Tagset TAGESTS.EXCELXP not found; the default tagset will be used instead.
NOTE: Writing TAGSETS.DEFAULT Body file: price.xls
27
28 ods tagsets.excelxp
29 options(sheet_name= "time"
30 frozen_headers="yes"
31
32 absolute_column_width='8.75, 6.25, 10.57, 7.43, 15, 8.14, 30.86, 10.57'
33
34 autofit_height='yes');
ERROR: No body file. TAGSETS.EXCELXP output will not be created.
35 proc report data=gg nowd
36 STYLE(REPORT) = [BACKGROUND=WHITE FOREGROUND=BLACK]
37
38 STYLE(COLUMN) = [BACKGROUND=WHITE FOREGROUND=BLACK FONT_SIZE=2]
39
40 STYLE(HEADER) = [BACKGROUND=WHITE FOREGROUND=BLUE BOLD FONT_SIZE=2];
41
42 columns xx yy;
43 define yy / 'yy' display style={tagattr='format:##0.0000'};
44 run;
... View more
