Date: Fri, 29 Oct 2010 03:50:25 -0400
Reply-To: "SUBSCRIBE SAS-L Joe H. Smith" <peesari.mahesh@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "SUBSCRIBE SAS-L Joe H. Smith" <peesari.mahesh@GMAIL.COM>
Subject: how can i convert _null_ report(datstep report) which is there in
rtf into pdf
Hi
I have a report, the name of sample_report.rtf
That report is there in .rtf I need to convert into .PDF
Can you help in this?
Code and report (.rtf) is there in down side
---------------------------------------------------------------------------
-------------------------------code----------------------------------------
data wghtclub;
input idno 1-4 name $ 6-24 team $ strtwght endwght;
loss=strtwght-endwght;
cards;
1023 David Shaw red 189 165
1049 Amelia Serrano yellow 145 124
1219 Alan Nance red 210 192
1246 Ravi Sinha yellow 194 177
1078 Ashley McKnight red 127 118
1221 Jim Brown yellow 220 .
1095 Susan Stewart blue 135 127
1157 Rose Collins green 155 141
1331 Jason Schock blue 187 172
1067 Kanoko Nagasaka green 135 122
1251 Richard Rose blue 181 166
1333 Li-Hwa Lee green 141 129
1192 Charlene Armstrong yellow 152 139
1352 Bette Long green 156 137
1262 Yao Chen blue 196 180
1087 Kim Blackburn red 148 135
1124 Adrienne Fink green 156 142
1197 Lynne Overby red 138 125
1133 John VanMeter blue 180 167
1036 Becky Redding green 135 123
1057 Margie Vanhoy yellow 146 132
1328 Hisashi Ito red 155 142
1243 Deanna Hicks blue 134 122
1177 Holly Choate red 141 130
1259 Raoul Sanchez green 189 172
1017 Jennifer Brooks blue 138 127
1099 Asha Garg yellow 148 132
1329 Larry Goss yellow 188 174
;
run;
data _null_;
d=today();
t=time();
file 'C:\Documents and Settings\tsipl0403\Desktop\sas\krishna5.rtf'
linesize=200 mod;
put' ';
put ' ';
put @2 'REQUEST # I11796-S'
@35 'ABC HEALTH COMPANY '
@60 "PAGE 1 ";
put @2 'RUN DATE : ' d ddmmyys10.
@30 'INFORMATION CENTER REQUEST'
@60'RUNTIME : ' t time8.;
put ' ';
put ' ';
put ' ';
put @2 'NPD VOLUMES BY GROUP NUMBER - DAYS IN
HOUSE';
put @2 'SUMMARY REPORT';
put ;
put ;
run;
data _null_;
file 'C:\Documents and Settings\tsipl0403\Desktop\sas\krishna5.rtf'
linesize=200 mod;
put @2 'IDNO' @10 'NAME' @30 'TEAM' @42 'STRWGHT' @52 'ENDWGHT'
@62 'LOSS' ;
/* HERE WE ARE GIVING COLUMN NAMES HOW EVER WE NEED , LIKE LABEL
STATEMENT /*
/*put @2 'idno' @10 'name' @30 'team' @42 'strtwght' @55 'endwght';*/ /*--
---Small letters in display--*/
run;
proc sort data=wghtclub out=wghtclub2;
by team;
run;
data _null_;
set wghtclub2;
by team;
file 'C:\Documents and Settings\tsipl0403\Desktop\sas\krishna5.rtf'
linesize=200 mod;
put @2 idno @10 name @30 team @42 strtwght @52 endwght @62 loss;
if first.team then do;
sw=0;ew=0;lo=0;;
end;
sw+strtwght;
ew+endwght;
lo+loss;
if last.team then do;
put @2"SUB TOTAL" @44 sw @54 ew @64 lo;
end;
run;
proc sql noprint;
select sum(strtwght) into:gsw from wghtclub2;
select sum(endwght) into:ges from wghtclub2;
select sum(loss) into:los from wghtclub2
quit;
%put &gsw.;
%put &ges.;
data _null_;
file 'C:\Documents and Settings\tsipl0403\Desktop\sas\krishna5.rtf'
linesize=200 mod;
put;
put @2 "GRAND TOTAL" @42 "&gsw" @52 "&ges" @62 "&los";
put;
put;
put @2 '*************************END OF REPORT
************************I***********';
put @2 '****************GENERATED BY RADHAKRISHNA
REDDY****************************';
run;
---------------------------------------------------------------------------
-----------------------Rrport output--------------------------------------
REQUEST # I11796-S ABC HEALTH COMPANY PAGE 1
RUN DATE : 06/06/2008 INFORMATION CENTER REQUEST RUNTIME :
16:08:22
NPD VOLUMES BY GROUP NUMBER - DAYS IN HOUSE
SUMMARY REPORT
IDNO NAME TEAM STRWGHT ENDWGHT LOSS
1095 Susan Stewart blue 135 127 8
1331 Jason Schock blue 187 172 15
1251 Richard Rose blue 181 166 15
1262 Yao Chen blue 196 180 16
1133 John VanMeter blue 180 167 13
1243 Deanna Hicks blue 134 122 12
1017 Jennifer Brooks blue 138 127 11
SUB TOTAL 1151 1061 90
1157 Rose Collins green 155 141 14
1067 Kanoko Nagasaka green 135 122 13
1333 Li-Hwa Lee green 141 129 12
1352 Bette Long green 156 137 19
1124 Adrienne Fink green 156 142 14
1036 Becky Redding green 135 123 12
1259 Raoul Sanchez green 189 172 17
SUB TOTAL 1067 966 101
1023 David Shaw red 189 165 24
1219 Alan Nance red 210 192 18
1078 Ashley McKnight red 127 118 9
1087 Kim Blackburn red 148 135 13
1197 Lynne Overby red 138 125 13
1328 Hisashi Ito red 155 142 13
1177 Holly Choate red 141 130 11
SUB TOTAL 1108 1007 101
1049 Amelia Serrano yellow 145 124 21
1246 Ravi Sinha yellow 194 177 17
1221 Jim Brown yellow 220 . .
1192 Charlene Armstrong yellow 152 139 13
1057 Margie Vanhoy yellow 146 132 14
1099 Asha Garg yellow 148 132 16
1329 Larry Goss yellow 188 174 14
SUB TOTAL 1193 878 95
GRAND TOTAL 4519 3912 387
*************************END OF REPORT
************************I***********
****************GENERATED BY RADHAKRISHNA
REDDY****************************
