I believe Proc Transpose would help you here. Try something like this.

Your variables are ColA, ColB,...ColI.

Proc Transpose data='dataset' out='new dataset'; var ColB ColC ... ColI; by ColA; run;

I believe this should give you the desired output.

Jeremy

-----Original Message----- From: Doug [mailto:queanbeyan@HOTMAIL.COM] Sent: Wednesday, May 15, 2002 7:27 PM To: SAS-L@LISTSERV.VT.EDU Subject: how to code this

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