TRY THIS >>>>>>>>

DATA A; INPUT FIRM $ YEAR $ ISSUE ; INFORMAT ISSUE DOLLAR6.; CARDS; A 1999 $100 A 1999 $130 B 1998 $200 B 1998 $100 ; RUN; PROC REPORT DATA = A HEADSKIP ; COLUMN FIRM YEAR ISSUE ; DEFINE FIRM / ' F I R M ' GROUP WIDTH = 9 ; DEFINE YEAR / ' Y E A R ' GROUP WIDTH = 9 ; DEFINE ISSUE / ' I S S U E ' SUM WIDTH = 12 F=DOLLAR6.; RUN;

ray <dh42714@GOODNET.COM> on 10/05/99 12:17:40 PM

Please respond to ray <dh42714@GOODNET.COM>

To: SAS-L@LISTSERV.UGA.EDU cc: (bcc: Girish S Patel/TEB/CEC) Subject: data problem

Dear Sassers: I have the following data which is as follows:

Firm Year Issue A 1999 $100 A 1999 $130 B 1998 $200 B 1998 $100

I need to arrange such that the firm appears only once per year. In the above case, it should be as follows:

Firm Year Issue A 1999 $230 B 1998 $300

Any reference to a SAS manual would be helpful. Thanks in advance.

ray