Date:         Thu, 1 Sep 2005 12:24:04 -0400
Reply-To:     "Howard Schreier <hs AT dc-sug DOT org>" <nospam@HOWLES.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Howard Schreier <hs AT dc-sug DOT org>" <nospam@HOWLES.COM>
Subject:      Re: How can I rearrange this data?

Assuming the input is an external file and the output is to be a SAS data
set, try:

   length USERID $ 13
          DATAID $  6
          RACE   $  1
          SEX    $  1 ;
   input @'USERID' USERID
         @'DATAID' DATAID
         @'RACE'   RACE
         @'SEX'    SEX   ;

On Wed, 31 Aug 2005 08:17:53 -0700, Alex Pavluck <apavluck@GMAIL.COM> wrote:

>USERID 1123341571190
>DATAID 123144
>RACE  W
>SEX   F
>USERID 1144341571190
>DATAID 123214
>RACE  W
>SEX   F
>
>USERID           DATAID      RACE  SEX
>1123341571190    123144      W      F