Date:         Thu, 8 May 2008 19:10:57 -0400
Reply-To:     "Howard Schreier <hs AT dc-sug DOT org>"
              <schreier.junk.mail@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Howard Schreier <hs AT dc-sug DOT org>"
              <schreier.junk.mail@GMAIL.COM>
Subject:      Re: A Short cut transpose question

On Thu, 8 May 2008 13:44:07 -0400, Tom Smith <need_sas_help@YAHOO.COM> wrote:

>I have a following dataset:
>
>
>
>Person    Blue    Red    White   Full-time   Part-time  Terminated
>-------------------------------------------------------------------
>124        N      Y       Y        Y           N           N
>245        N      Y       N        N           Y           N
>589        Y      N       N        N           N           Y
>
>
>
>Need to combine the variables (Blue, Red, White) to a new variable named
>Color and
>variables (Full Time, part time and terminated) to a new variable named
>Status and
>the new dataset will look like as follows ( also all the transpose I need
>to do in
>as short as possible):
>
>Person   Color        Status
>--------------------------------
>
>124       Red         Full-time
>          White
>245       Red         Part-Time
>
>589       Blue        Terminated
>
>
>Thanks you so much

Let's focus on the value of COLOR in the observation having PERSON=124. Is
it "Red" or "White" or some composite? It cannot be "Red" and "White".