Date:         Tue, 29 Jul 2008 12:07:45 -0500
Reply-To:     mpajoh@ODOT.ORG
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Masoud Pajoh <mpajoh@ODOT.ORG>
Subject:      data set summary
Content-Type: text/plain; charset="US-ASCII"

Hi All:
I have:

vendor           item               price
1                         2                     10
1                         3                     5
1                         5                     6
1                         6                     3
1                         10                   12
1                         12                   8
2                         2                     6
2                         3                     8
2                         5                     3
2                         6                     7
2                         10                   9
2                         12                   18
.                            .                      .
.                            .                      .
.                            .                      .

I want:
item                vendor1                  vendor2 vendor3
...................
2                          10                              6
...................                ...................
3                          5                                8
.................                ...................
5                          6                                3
.................
.                            .                                 .


any pointers are appreciated.

Masoud

I use SAS v9.1.3 SP4