I need to suppress data according to the following rules: 1. If any cell is less than five (includes 0), the cell is suppressed. 2. When there is suppression of a single cell, the next smallest cell(s) is suppressed until the total of the data in the suppressed cells adds up to at least five. 3. If any single category contains all of the data, the entire group of data is suppressed. Here is sample data: School Proficiency level 2011 2012 2013 2014 Washington HS 1 1 0 1 2 Washington HS 2 2 3 2 2 Washington HS 3 6 3 2 2 Washington HS 4 18 12 9 4 Monroe HS 1 10 12 4 6 Monroe HS 2 4 5 4 0 Monroe HS 3 8 7 9 5 Monroe HS 4 20 15 18 10 Truman HS 1 0 20 15 14 Truman HS 2 0 18 16 19 Truman HS 3 0 34 20 28 Truman HS 4 60 28 25 24 In this example, the data of concern are the 4 numbers within each year for each school. So, for example, for Washington HS for 2011, there are 4 numbers: 1, 2, 6, 18. As 1 and 2 are both less than 5, they will need to be suppressed. Since the total of 3 ( 1 + 2) is less than 5, the 6 will also need to be suppressed. Another example: Washington HS for 2012, there are 4 numbers: 0, 3, 3, 12. The first 3 will need to be suppressed as they are all less than 5. Since the total of these 3 numbers is 6, we keep the 12. Another example: Washington HS for 2014, there are 4 numbers: 2, 2, 2, 4. Since all are under 5, all will need to be suppressed. Another example: Truman HS for 2011, there are 4 numbers: 0, 0, 0, 60. Since all of the data are in one cell, all cells must be suppressed. Can this be achieved in SAS? Thank you.
... View more
