Date:         Wed, 11 Dec 2002 16:50:38 GMT
Reply-To:     Tim Berryhill <tim@AARTWOLF.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Tim Berryhill <tim@AARTWOLF.COM>
Organization: Aartwolf Technology
Subject:      Re: Help in Manipulating Dataset.

John, It looks like you want to get all of the information about a single
category in a single observation.  The tool which does this, and avoids
having several variables named Grs in a single dataset, is PROC TRANSPOSE.

Having said that, allow me to suggest you ask for strategic advice rather
than tactical advice.  I believe you will make your programming much more
difficult by stringing the observations together.  What are you trying to
do?
Tim Berryhill

"John Hewitt" <john_hewitt2003@YAHOO.COM> wrote in message
news:20021210194932.94209.qmail@web14502.mail.yahoo.com...
> Dear All:
>
> Can anyone kindly suggest how to convert a dataset in
> the following format:
>
> Wk  Categ Grs  Net
> 1    AA1  380  280
> 1    BB1  260  200
> 1    AA2  320  240
> 2    BB1  240  180
> 2    AA2  220  140
> 3    BB1  400  320
> 3    AA2  350  260
>
> to a dataset in the following format
>
> Wk Categ Grs   Net  Wk Categ Grs Net Wk Categ Grs  Net
> 1    AA1  380  280
> 1    BB1  260  200  2  BB1  240  180 3    BB1  400
> 320
> 1    AA2  320  240  2  AA2  220  140 3    AA2  350
> 260
>
>
> Thanks in advance for your suggestions.
>
> John
>
>
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
> http://mailplus.yahoo.com