Date:         Wed, 18 Jun 2003 09:25:15 -0700
Reply-To:     "Huang, Ya" <yhuang@AMYLIN.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Huang, Ya" <yhuang@AMYLIN.COM>
Subject:      Re: PROC Report - Double spacing
Comments: To: Sterling Price <Sterling.Price@WAL-MART.COM>
Content-Type: text/plain; charset="iso-8859-1"

I would be very careful using obsno as a break var,
if you have other 'order' var followed obsno, it won't
work any more:

data class;
set sashelp.class;
obsno=_N_;
run;

proc report data = class nowd;
columns obsno sex name weight;
define obsno / order noprint;
define sex / order ;
break after obsno / skip;
run;

In the above sample, sex will not be shown as
a grouped var.

An alternative method is to use special formchar and box option:

options formchar='          ';

proc report data = sashelp.class nowd split='~' box;
columns sex name weight;
define sex /'Sex~________' order center width=8;
define name /'Name~____________________' width=20;
define weight /'Weight~_____' width=8;
run;

There are some drawbacks of this methods too:

1. All the lines are gone, including headline,
   some of them can be added with split option + dash line
   as shown above.
2. Can't use box option with flow option.

Kind regards,

Ya Huang


-----Original Message-----
From: Sterling Price [mailto:Sterling.Price@WAL-MART.COM]
Sent: Wednesday, June 18, 2003 8:48 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: PROC Report - Double spacing


Gadi,

I asked this question on the list not too long ago. Strangely, there doesn't
seem to be a way to directly specify double spacing using Proc Report, but
you can simulate it by adding an observation number to your report dataset
and then using it as an order variable and breaking after it in your Proc
Report code:

data work.report;
set sashelp.retail;
obsno=_N_;
run;

proc report data = work.report;
columns sales date year month day obsno;
define obsno / order noprint;
define sales / display;
define date / display;
define month / display;
define day / display;

break after obsno / skip;

run;

HTH,

Sterling Price

-----Original Message-----
From: GADI_B@MALAM.COM [mailto:GADI_B@MALAM.COM]
Sent: Wednesday, June 18, 2003 7:00 AM
Subject: PROC Report - Double spacing


Hi,

How do I tell PROC REPORT to use double spacing it the report?

TIA

Gadi


**********************************************************************
This email and any files transmitted with it are confidential
and intended solely for the individual or entity to
whom they are addressed.  If you have received this email
in error destroy it immediately.
**********************************************************************
             Wal-Mart Stores, Inc. Confidential
**********************************************************************