Date:         Thu, 10 Apr 2003 13:47:06 -0700
Reply-To:     Mark Terjeson <mark.terjeson@NWCSR.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Mark Terjeson <mark.terjeson@NWCSR.COM>
Subject:      Re: duplicate id while transposing
Comments: To: Sam <gowdar@ADVBIOL.COM>
In-Reply-To:  <259f5610.0304101207.6b8ef4cf@posting.google.com>
Content-Type: text/plain; charset="US-ASCII"

Hi,

give this a try.......


data table1;
  input var1 var2 $ var3 $ var4 $ var5;
cards;
  101 D1 DAN 1   1
  101 D2 DAN 1.1 1
  101 D3 DAN LD  1
  101 D1 DAN 2.2 2
  101 D2 DAN 2.3 2
  101 D3 DAN 2.0 2
;
run;

proc transpose data=table1 out=table2(drop=_name_ var5 where=(col1 ne
''));
    by var5;
        copy var1 var3;
        var var4;
run;


Hope this is helpful,
Mark Terjeson
Northwest Crime and Social Research, Inc.
A SAS Alliance Partner
215 Legion Way SW
Olympia, WA   98501
360.870.2581 - voice,cell
360.570.7533 - fax
mailto:mark.terjeson@nwcsr.com
www.nwcsr.com

"Nothing is particularly hard
if you divide it into small jobs."
- Henry Ford, Industrialist




-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Sam
Sent: Thursday, April 10, 2003 1:07 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: duplicate id while transposing


The data is like this
  101 D1 DAN 1   1
  101 D2 DAN 1.1 1
  101 D3 DAN LD  1
  101 D1 DAN 2.2 2
  101 D2 DAN 2.3 2
  101 D3 DAN 2.0 2

it should be transposed as

 101    DAN      1      1.1    LD
 101    DAN      2.2    2.3    2.0


iF I USE LET IN TRANSPOSING, ITS GOING TO GIVE ONLY LAST OBSERVATION,
SO HOW TO GET THE OUTPUT.I AM USING DATA NULL

THANK YOU