瀚海星云 发表于 2012-12-3 09:47 
请先给出代码吧
data delay;
input flight $3. +5 date date7. +2 orig $3. +3 dest $3. +3
delaycat $15. +2 destype $15. +8 delay;
informat date date7.;
format date date7.;
cards;
114 01MAR94 LGA LAX 1-10 Minutes Domestic 8
202 01MAR94 LGA ORD No Delay Domestic -5
622 01MAR94 LGA FRA No Delay International -5
132 01MAR94 LGA YYZ 11+ Minutes International 14
302 01MAR94 LGA WAS No Delay Domestic -2
114 02MAR94 LGA LAX No Delay Domestic 0
202 02MAR94 LGA ORD 1-10 Minutes Domestic 5
219 02MAR94 LGA LON 11+ Minutes International 18
622 02MAR94 LGA FRA No Delay International 0
132 02MAR94 LGA YYZ 1-10 Minutes International 5
271 02MAR94 LGA PAR 1-10 Minutes International 4
302 02MAR94 LGA WAS No Delay Domestic 0
114 03MAR94 LGA LAX No Delay Domestic -1
;
run;
ods html style=default path = "C:\Documents and Settings\ywang3\桌面\SAS FUNCTION" body = "flights.xls" ;
title;
title '<th colspan = 3><font size=4> Flight Check Result</th>';
proc report data = delay nowd split='~'
style(report) = {just = center}
style(header) = {font_weight = bold just = center BACKGROUNDCOLOR = yellow}
style(column) = {just = center};
column flight date orig dest delaycat destype delay;
DEFINE flight / "航班" display;
DEFINE date / "时间" display;
DEFINE orig / "始发地" display;
DEFINE dest / "目的地" display ;
DEFINE delaycat / "延迟情况" display;
DEFINE destype / "类型" display;
DEFINE delay / "推迟时间" display;
run;
footnote;
ods _all_ close;