Date:         Tue, 28 Aug 2007 18:35:21 +0000
Reply-To:     toby dunn <tobydunn@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         toby dunn <tobydunn@HOTMAIL.COM>
Subject:      Re: Transforming multiple records to one record
Comments: To: venkateshnt@GMAIL.COM
In-Reply-To:  <1188325668.574686.101560@g4g2000hsf.googlegroups.com>
Content-Type: text/plain; format=flowed

Untested but try:

Data Need ;
UpDate Sam1 ( Obs = 0 )
           Sam1 ;
By ID ;
Run ;





Toby Dunn


Two wrongs are only the beginning.

Success always occurs in private and failure in full view.

Experience is something you don't get until just after you need it.





From: Nat <venkateshnt@GMAIL.COM>
Reply-To: Nat <venkateshnt@GMAIL.COM>
To: SAS-L@LISTSERV.UGA.EDU
Subject: Transforming multiple records to one record
Date: Tue, 28 Aug 2007 18:27:48 -0000

Hi everyone,

I have a dataset with multiple records for same ID like this:

data sam1;
         input id a1 a2 a3 a4 a5 $ a6 $;
cards;
101 1 . . . *
101 . 2 . . *
101 . . 3 . *
101 . . . 4 *
102 1 . 3 . * .
102 . 2 . 4 .
;

I would like to have my output dataset to look like this: one record
per id;

  id   a1  a2  a3  a4  a5  a6
===================
101  1   2    3    4    *
102  1   2    3    4    *

I tried to use both array and proc transpose to get the output, but
the variables are different data types (Character & Numeric), it gives
me an error.

Please input your suggestions. Thanks for your help.

Regards!
Nat

_________________________________________________________________
A new home for Mom, no cleanup required. All starts here.
http://www.reallivemoms.com?ocid=TXT_TAGHM&loc=us