Date:         Thu, 16 May 2002 00:06:16 GMT
Reply-To:     Shawn Edney <sedney@NC.RR.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Shawn Edney <sedney@NC.RR.COM>
Organization: Road Runner - NC
Subject:      Re: how to code this

Hello Doug,
I would offer another route.

data one;
input id @;
  do i=1 to 8;
        input value @;
       drop i;
       output;
  end;
cards;
102 22 43 22 12 21 56 98 71
103 19 21 62 53 23 22 18 22
;
run;

Good luck,

Shawn Edney


"Doug" <queanbeyan@hotmail.com> wrote in message
news:d72455ac.0205151526.5378d24d@posting.google.com...
> Hi,
>
> Could someone please show me how to code the following (I tried for
> about an hour and just can't get it right).
>
> I have data such as that contains a category and several values;
> 102 22 43 22 12 21 56 98 71
> 103 19 21 62 53 23 22 18 22
>
> and I want to get a table with one row for each category such as;
>
> 102 22
> 102 43
> 102 22
> ....
> 101 22
> 101 18
> 101 22
>
> Thanks
>
> Doug