Date:         Mon, 27 Sep 2004 14:17:15 -0700
Reply-To:     David Fickbohm <DavidF@HOMEGAIN.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         David Fickbohm <DavidF@HOMEGAIN.COM>
Subject:      how to turn data
Content-Type: text/plain; charset="iso-8859-1"

People,
I have a dataset where fielda has a value that repeats up to 8 times.
Fieldb has a zipcode. Fieldc is a count.   I would like to turn output so I
have one iteration of the value in column a and as many iterations of field
b abd c as there are next to fielda;

example of current data

123  12345  2
123  23456  4
123  34567  3
234  67890  6
234  78900  9
234  87654  8

output wanted

123    12345  2  23456 4  34567 3
234    67890  6  78900 9  87654 8


I tried transpose and got all the possible zipcodes across then the count
below.

All thoughts, help, suggestions, will be greatly appreciated.
Thanks
Dave

Dave Fickbohm
Data Mining Analyst
Homegain+
2450 45th St.
Emeryville, CA, 94608
Phone 510 655 0800 ext 4151