| Date: | Tue, 29 Jul 2008 12:34:31 -0500 |
|---|
| Reply-To: | "data _null_," <datanull@GMAIL.COM> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | "data _null_," <datanull@GMAIL.COM> |
|---|
| Subject: | Re: data set summary |
|---|
|
| In-Reply-To: | <OFA72E0CC9.42D503D7-ON86257495.0056EC24-86257495.005E0BE6@fd9ns01.okladot.state.ok.us> |
|---|
| Content-Type: | text/plain; charset=ISO-8859-1 |
|---|
Perhaps PROC REPORT is adequate.
proc plan seed=1577618964;
factors
vendor = 3 ordered
items = 6 of 12
price = 1 of 100
;
output out=vendors;
run;
quit;
proc report nowd;
columns items vendor, price;
define items / group;
define vendor / across;
run;
On 7/29/08, Masoud Pajoh <mpajoh@odot.org> wrote:
> 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
>
|
