LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (October 2010, week 5)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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****************************


Back to: Top of message | Previous page | Main SAS-L page