Yes, that worked also thank you. What I ended up using was a proc sql where I just summarized the data based on category. It looked like this proc sql; create table FINAL as select memberid , month , sum(case when category = 'bookds' then paid_amt else 0 end) as Book_total ...etc... from previous table group by memberid, month order by memberid, month ;quit; This returned the data in a format that I can left join to another table that has memberid and zip code. From there I am going to try to see if there is any correlation between variables. Thanks for all the help, I really appreciate it. And if any of you know any good ways to compare multiple variables (zip code) to other dependent variables ( paid amount by category) please let me know I am always interested in learning new things. Thanks!
... View more
