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 2009, week 1)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Mon, 5 Oct 2009 18:52:40 -0400
Reply-To:     John Birken <zbq5@CDC.GOV>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         John Birken <zbq5@CDC.GOV>
Subject:      Proc Report --- unwanted blank rows

The routine at the end runs fine with 6 UNWANTED ROWS marked with XXX (They're blank in the real report. They've been immune to many approaches - ghosts early for Halloween? I've cut horizontal content for brevity. Punctuation should remain. Dots ... added to indicate brevity. HOW do I get rid of the blank (XXX) lines. 4 of them would be adequate.

Many Thanks, John, jbirken@cdc,gov caraj@cox.net

----------------------------------------------------------- Output:

Table 33: Live births by state of residence,race of mother and infant mortality rates by state of residence, race of United States, 2004

[Infants deaths weighted. Infant deaths are under 1 year. early neonatal, 0-6 days; late neonatal,7-27 days; and pos Race is according to race reported on the matching birth

__________________________________________________________

LIVE State of Residence INFANT Race of mother and birthweight BIRTHS __________________________________________________________

White

All birthweights Number..... 12,345 678 Rate....... 1.23 ... ... Not stated Number..... 89 - Rate....... - XXX XXX XXX XXX XXX XXX __________________________________________________________

See footnotes at end of table.

--------------------------------------------------------

SAS routine giving 6 extra blank rows:

PROC REPORT DATA=IN1.TABLE_33 NOWD NOHEADER HEADSKIP; COLUMN BRSTATE RACE BRWT LBN DEA_1 DEA_2 DEA_3 DEA_4 DEA_5; DEFINE LBN / DISPLAY WIDTH=10; DEFINE DEA_1 / DISPLAY WIDTH=10; DEFINE DEA_2 / DISPLAY WIDTH=10; DEFINE DEA_3 / DISPLAY WIDTH=10; DEFINE DEA_4 / DISPLAY WIDTH=10; DEFINE DEA_5 / DISPLAY WIDTH=10; DEFINE BRSTATE/ORDER NOPRINT; DEFINE RACE /ORDER NOPRINT; DEFINE BRWT /DISPLAY FORMAT=BRTW.; COMPUTE BEFORE _PAGE_; _PAGE + 1; LINE @101 "PAGE: " _PAGE; LINE ' '; LINE @3 'Table 33: Live births by state of residenc'; LINE @3 'and infant mortality rates by state of residenc,:'; LINE @3 'United States, 200'; LINE ' '; LINE @3 '[Infants deaths weighted. Infant death; '; LINE @3 'early neonatal, 0-6 days; late neonata,.'; LINE @3 ' Race is according to race reported on ]'; LINE ' '; LINE @3 106*'_'; LINE ' '; LINE @43 'LIVE' @68 'TOTAL' @80 'EARLY' @94 'LATE' @104 'POST- ' ; LINE @5 'State of Residence' @55 'INFANT' ; LINE @3 'Race of mother and birthweight'@43 'BIRTHS' @66 'NEONATAL' ; LINE @3 106*'_'; LINE ' '; ENDCOMP; COMPUTE AFTER _PAGE_; IF _PAGE <161 THEN DO; ULINE1 = REPEAT('_', 103); ULINE2 = REPEAT(' ', 103); ULINE3 = 'See footnotes at end of table. '; ULINE4 = REPEAT(' ', 103); ULINE5 = REPEAT(' ', 103); END; ELSE DO; ULINE1 = REPEAT('_', 103); ULINE2 = REPEAT(' ', 103); ULINE3 = '* Figure does not meet standard '; ULINE4 = "&FTCHAR1 Includes races other than"; ULINE5 = "&FTCHAR2 Includes aleuts and eskimos"; ULINE6 = REPEAT(' ', 103); END; LINE @3 ULINE1 $200.; LINE @3 ULINE2 $200.; LINE @3 ULINE3 $200.; LINE @3 ULINE4 $200.; LINE @3 ULINE5 $200.; LINE @3 ULINE6 $200.; ENDCOMP; COMPUTE BEFORE RACE; LINE ' '; LINE @3 RACE RACE.; LINE ' '; ENDCOMP; BREAK AFTER RACE /OL SUMMARIZE PAGE; COMPUTE BEFORE BRSTATE; LINE ' '; LINE @3 BRSTATE STATE.; LINE ' '; ENDCOMP; TITLE2; RUN;


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