代码如下:
proc template;
define style styles.test;
parent=styles.sasweb;
replace document from container /
protectspecialchars =off
;
end;
run;
title;
ods noproctitle;
ods listing close;
ods results off;
ods excel file="&root\output\medical review_&date..xlsx" style=styles.test;
ods excel options( sheet_interval='none' suppress_bylines='no' embedded_titles='yes' sheet_interval='none'
sheet_name="表3-1)AE计数表"
/* absolute_column_width='15' */
gridlines='yes' autofilter='yes'
frozen_headers='0' embedded_titles='yes');
proc report data=mrf.t31 split="|" style(report)={tagattr='WRAP:NO'} style={protectspecialchars=off } ;
run;
ods excel close;
ods listing;
ods results;
|