Date:         Thu, 26 Feb 2004 11:44:05 -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 Qn.
Comments: To: Jeff Morison <jmt_mtf@YAHOO.COM>
Content-Type: text/plain; charset="us-ascii"

The answer is both!

Create a new character variable that is the length of the maximum length
of each of the 3 plus 2 for the slashes and 2 more for the asterisks.

NEWVAR = VAR1 || '/*' || VAR2 || '/*' || VAR3 ;

On the DEFINE statement use Flow, but make sure that the WIDTH is set to
the maximum possible length of any of the 3 vars in question ( plus the
'/').  Set the Format= the length of the concatenated variable.



-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
Jeff Morison
Sent: Thursday, February 26, 2004 11:33 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Proc Report Qn.

   I have a data set with few variables which I need
to generate a listing using proc report, but the
format I was given is little hard, can some one
provide some pointers.

I need to display three different variables data
values in one column as follows.  How can I do this in
proc report.  I need to put slashes too.


                   Age(Yrs.)/
                    Race/
Subject            Gender
_________________________________________________

100                 45/
                   Caucasian/
                    Male

200                 55/
                    Asian/
                    Male

and so on ....

The way I was thinking was to convert the Age variable
to character and concatenate with other two variables
add slashes in between, thus creating one variable,
but how do I get the values in different lines.  Does
split='*' work here or should I use FLOW option.

There must be an easy way.

TIA,
Jeff









__________________________________
Do you Yahoo!?
Get better spam protection with Yahoo! Mail.
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.
***********************************************************************