kking0104@COX.NET wrote: >I have a dataset imported from Excel that consists of names, zip codes, >donations, dates and account identifiers. I want to collapse each donor's >records into one observation. > >We want to do several things, such as identify more like indiv1, below, who >jumped from $35 a year to $100 a year. We also want to sum the amounts and >plot them by year/qtr/etc. > >Sorry for the lengthy example below, but I wanted to show that some fields >are missing depending on whether the donor is an indivdual or a business. >Also, the dates and amounts vary significantly, and the dates and amounts >are often not unique due to accounting adjustments. (See the last three >rows.) > >Any suggestions to transpose this either using transpose or an array would >be appreciated. Additionally, if anyone has done similar analysis, any >other >examples are welcome.

I agree with Toby (et al.) . Don't just collapse the data. And most certainly don't transpose it. You have the data in the right form now. You can study it by any time interval you want, using PROC SUMMARY (or PROC MEANS or...) and a date format.

When you want to plot the data to see how it is behaving over time (overlaying many different donors, you can also use the summarized results to see how the totals change over time.. and who is changing.

So keep your data as is, and use the flexibility of SAS analyses accordingly.

HTH, David -- David L. Cassell mathematical statistician Design Pathways 3115 NW Norwood Pl. Corvallis OR 97330

_________________________________________________________________ On the road to retirement? Check out MSN Life Events for advice on how to get there! http://lifeevents.msn.com/category.aspx?cid=Retirement