Good afternoon everyone! As always, I thought its pretty simple but got stuck. Here is the data-   Data have; input code $ description $ totalSum totalUnits year; cards; A APPLE 100 3 2016 A APPLE 200 4 2015 A APPLE 300 5 2014 B BANANA 234 7 2015 C CIDER 20 1 2016 C CIDER 25 3  2016 C CIDER 12 1 2015 C CIDER 21 4 2015 C CIDER 23 4 2014 D DATE 200 4 2015 D DATE  567 34 2016 ; RUN;   What I'm looking for is that for those records within the same code, description and year, totalsum and totalunits values are added. For ex, if there is only one unique value for C, Cider and 2014, it should remain the same, but when C, Cider and 2014 are repeated again, totalsum values should be added to give one unique record for that year. To make it more clear-here is what I want-   data want; input code $ description $ totalSum totalUnits year; cards; A APPLE 100 3 2016 A APPLE 200 4 2015 A APPLE 300 5 2014 B BANANA 234 7 2015 C CIDER 45 4 2016 C CIDER 33 5 2015 C CIDER 23 4 2014 D DATE 200 4 2015 D DATE  567 34 2016 ; RUN;   Thanks so much! ... View more

Merry Xmas to all you talented people! I have the data in following format below-   I'm looking to extract following information- 1. Number of members each year who have claims, number of those claims and claim amounts (I solved this part by using simple sas code, but had to do for each year seperately and then merge all six datasets-im sure there is more efficient way to do it)   2. Member progression each year- new distinct members each year who enter and exit the system- many members have claims in multiple years, but i want to find out how many new members enter the system each year or exit the system permanently, list of those members by gender, county type etc. The tricky part here is that member could have claim in 2011 and then again in 2014 and 2016, so those members should not be counted as new members, but still be identified.     Person ID Unencrypted Gender Date of Birth County Claims Paid_2011 Payment Amount Prof & Fac_2011 Claims Paid_2012 Payment Amount Prof & Fac_2012 Claims Paid_2013 Payment Amount Prof & Fac_2013 Claims Paid_2014 Payment Amount Prof & Fac_2014 Claims Paid_2015 Payment Amount Prof & Fac_2015 Claims Paid_2016 Payment Amount Prof & Fac_2016 0001 Female 09/13/1991 Aroostook     1 $57.50                 0002 Female 10/12/1959 Aroostook 6 $141.31 17 $169.56 18 $632.27 11 $355.29 10 $367.13 6 $298.35 0003 Female 05/22/1960 Aroostook             3 $0.00 7 $92.40 3 $28.57 0004 Male 12/07/1965 Aroostook             1 $71.52         0005 Male 10/23/1964 Somerset     6 $689.52                 0006 Male 05/04/1942 Cumberland     1 $48.44 5 $44.04 4 $0.00 1 $71.70 3 $71.29 ... View more