Untested but try:
Data Need ;
UpDate Sam1 ( Obs = 0 )
By ID ;
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 < XXXX@XXXXX.COM >
Reply-To: Nat < XXXX@XXXXX.COM >
Subject: Transforming multiple records to one record
Date: Tue, 28 Aug 2007 18:27:48 -0000
I have a dataset with multiple records for same ID like this:
input id a1 a2 a3 a4 a5 $ a6 $;
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
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.
A new home for Mom, no cleanup required. All starts here.