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 (June 2003, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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 **********************************************************************


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