>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
>Any suggestions to transpose this either using transpose or an array would
>be appreciated. Additionally, if anyone has done similar analysis, any
>examples are welcome.
I agree with Toby (et al.) . Don't just collapse the data. And most
transpose it. You have the data in the right form now. You can study it by
time interval you want, using PROC SUMMARY (or PROC MEANS or...) and a date
When you want to plot the data to see how it is behaving over time
many different donors, you can also use the summarized results to see how
totals change over time.. and who is changing.
So keep your data as is, and use the flexibility of SAS analyses
David L. Cassell
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