| Date: | Thu, 31 Jan 2002 09:17:27 -0500 |
|---|
| Reply-To: | Kim Nhac Le <kle@CID.ALCATEL.COM> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | Kim Nhac Le <kle@CID.ALCATEL.COM> |
|---|
| Organization: | Alcatel Canada Inc. |
|---|
| Subject: | Newbie Question, please help :( |
|---|
| Content-Type: | text/plain; charset=us-ascii |
|---|
I was wondering on the most efficient way to do the following task.
Suppose I have data that looks like this
Name Family Quantity
Bob A 1
Bob A 1
Bob B 1
Bob C 2
Susan B 1
Susan B 1
Mike C 3
And I want to get something like this:
Name FamilyA FamilyB FamilyC
Bob 2 1 1
Susan 0 2 0
Mike 0 0 3
Thanks,
(sorry to ask such question)
| 
