Date:         Thu, 19 Feb 2004 18:48:24 -0500
Reply-To:     "Braten, Michael (Exchange)" <mbraten@BEAR.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Braten, Michael (Exchange)" <mbraten@BEAR.COM>
Subject:      Re: proc report:
Comments: To: Toby Dunn <tdunn@OAKHILLTECH.COM>
Content-Type: text/plain; charset="us-ascii"

You may  want

1) to sort the data by ID and  use standard
             BY ID;
   ( with NOBYLINE in system options so that you can create your own
byline)

2) on the proc statement say SPACING=1 or to minimize the space between
columns .



-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
Toby Dunn
Sent: Thursday, February 19, 2004 6:04 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: proc report:

Look at the options linesize and pagesize.

HTH
Toby Dunn

-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
Liyan
Liu
Sent: Thursday, February 19, 2004 4:43 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: proc report:

Dear fellow SAS professionals,

I wish to print out all the variables for each person
in one page. Right now my program produces the results
in 2 pages, how could I modify it so the results will
all fall within one page for each person? Attached is
my program.

Thanks so much,

Liyan

%MACRO PRN(START,STOP);
%DO I=&START %TO &STOP;
  PROC REPORT DATA=one SPLIT='/' HEADSKIP HEADLINE;
  WHERE ID=&I;
  COLUMN id MRN beg_memb end_memb dob datedx dplace
          RACE;
  DEFINE id  / ORDER SPACING=2 LEFT "ID";
  DEFINE MRN / ORDER SPACING=2 LEFT;
  DEFINE BEG_MEMB/ORDER WIDTH=12 FORMAT=DATE9.
    SPACING=2 LEFT 'Date of/enrollment';
  DEFINE end_memb/DISPLAY FORMAT=date9. WIDTH=14
    SPACING=2 LEFT 'Date of/disenrollment';
  DEFINE end_memb/DISPLAY FORMAT=date9. WIDTH=14
    SPACING=2 LEFT  'Date of/disenrollment';
 DEFINE dob    / DISPLAY WIDTH=12 SPACING=2
    LEFT "Date of/birth" format=date9.;
 DEFINE datedx /dISPLAY WIDTH=12 SPACING=2 LEFT "Date
    of/diagnosis" format=date9.;
 DEFINE dplace/DISPLAY WIDTH=10 SPACING=2
    LEFT "State of/death" format=$place.;
 DEFINE race  /DISPLAY WIDTH=10 SPACING=2
    LEFT "Ethnic/group" format=race.;
run;
%MEND;

%PRN(1,3);



__________________________________
Do you Yahoo!?
Yahoo! Mail SpamGuard - Read only the mail you want.
http://antispam.yahoo.com/tools


***********************************************************************
Bear Stearns is not responsible for any recommendation, solicitation,
offer or agreement or any information about any transaction, customer
account or account activity contained in this communication.
***********************************************************************