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 (April 2003, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Mon, 14 Apr 2003 18:13:32 -0400
Reply-To:     Sigurd Hermansen <HERMANS1@WESTAT.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Sigurd Hermansen <HERMANS1@WESTAT.COM>
Subject:      Re: Stacking Variables with Proc Report
Comments: To: Mark Lamias <Mark.Lamias@GRIZZARD.COM>
Content-Type: text/plain; charset="iso-8859-1"

Ray's solution probably gives you what you want within PROC REPORT; nonethess, if anyone is looking for a way to print address labels, don't forget about PROC FORMS. Sig

-----Original Message----- From: Mark Lamias To: SAS-L@LISTSERV.UGA.EDU Sent: 4/14/2003 3:06 PM Subject: Stacking Variables with Proc Report

All,

I'm trying to stack several variables from a SAS dataset into one cell of a report produced with proc report and ods. Specifically, I am trying to place the following variables into one cell of the report:

Line1: first_name last_name Line2: primary_address Line3: city_state_zip

Ideally, my report would end up looking something like this:

------------------------------|-----------------------------| Name & Address |Other Variable 1 |. . . ------------------------------|-----------------------------| Mark Lamias | | 229 Peachtree Street |Statistician |. . . Atlanta, GA 30303 | | ------------------------------|-----------------------------| George Bush | | 1600 Pennsylvania Ave. NW |President |. . . Washington, DC. 20500 | | ------------------------------|-----------------------------| American Statistical Assn | | 1429 Duke Street |Organization |. . . Alexandria, VA 22314-3415 | | ------------------------------|-----------------------------| . . . . . .

Does anyone know how to do this in proc report? To do this, will I absolutely have to create a new template definition? I'm just looking for a simpler way to do this (within proc report) than setting up a new template.

Thanks.

Sincerely yours,

Mark J. Lamias Statistical Consultant Grizzard Agency 229 Peachtree Street - 12th Floor Atlanta, GA 30303


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