| Date: | Thu, 13 Jul 2000 15:45:06 -0400 |
|---|
| Reply-To: | Howard Schreier <Howard_Schreier@ITA.DOC.GOV> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | Howard Schreier <Howard_Schreier@ITA.DOC.GOV> |
|---|
| Subject: | Thinking Outside the Box :-) |
|---|
| Content-Type: | text/plain; charset=US-ASCII |
|---|
Maybe Toni and George can just trade jobs. :-)
>Date: Thu, 13 Jul 2000 07:40:46 PDT
>From: Toni Zhang <thesis8@HOTMAIL.COM>
>Subject: ASk for advise
>
>In my data, I have a long record for each indivdial and their shopping
>behavor in each store - look like this
>
>
>person1 store1 store1sell... store2 store2sell... store3 store3sell...
>person2 store1 store1sell... store2 store2sell... store3 store3sell...
>
>I want to breakdown this long recard into serval ones by store such as:
>
>person1 store1 store1sell
>person1 store2 store2sell
>person1 store3 store3sell
>person2 store1 store1sell
>person2 store2 store2sell
>person2 store3 store3sell
>
>Please indicate how to do this. What will be the snytax. Please also
>write some explanation statement in /* */ - It always very helpful to
>me.
>
>Date: Thu, 13 Jul 2000 18:23:52 GMT
>From: George Smith <anirdesh@HOTMAIL.COM>
>Subject: <No subject given>
>
>I have following data :
>
>SSN NAME DEPDNT DEPNAME
>
>123 JOHN 345 A11
>123 JOHN 346 A22
>124 JACK
>135 JULI 890 B11
>135 JULI 891 B22
>135 JULI 892 B33
>
>OUTPUT :
>
>SSN NAME DEP1 DEPNAM1 DEP2 DEPNAM2 DEP3 DEPNAM3
>
>123 JOHN 345 A11 346 A22
>124 JACK
>135 JULI 890 B11 891 B22 892 B33
>
>How should I get above output. Is there any macro who can share ?
>( In general there are nine depdents.)
|
