Thank you again, Art! This is exactly what I want! Thank you for all your helps! ... View more

Hi, I have a further question regarding the data suppression. I need to suppress data according to the following rules (a third rule is added): If any cell is less than 20, the cell is suppressed for the purpose of confidentiality. When there is suppression of a single cell, the next smallest cell(s) will need to be suppressed so that the value of the suppressed cell cannot be calculated by subtracting the other values from the total for a region. If two or more of the cells within a region are less than 20 (will be suppressed), then the next smallest cell(s) will NOT be suppressed, as the values of suppressed cells cannot be determined.   The sample data is here: Region1 Group1 70 Region1 Group2 30 Region1 Group3 10 Region1 Total 110 Region2 Group1 210 Region2 Group2 90 Region2 Group3 50 Region2 Total 350 Region3 Group1 170 Region3 Group2 15 Region3 Group3 60 Region3 Total 245 Region4 Group1 55 Region4 Group2 15 Region4 Group3 10 Region4 Total 80   And I want the data is like this: Region1 Group1 70 Region1 Group2 Region1 Group3 Region1 Total 110 Region2 Group1 210 Region2 Group2 90 Region2 Group3 50 Region2 Total 350 Region3 Group1 170 Region3 Group2 Region3 Group3 Region3 Total 245 Region4 Group1 55 Region4 Group2 Region4 Group3 Region4 Total 80   Thank you! ... View more

Hi Art,   Thank you, thank you!!! ... View more

Thank you Art and Ballardw for you help! The code below solved my question!   data have; input Region $ Group $ Count; cards; Region1 Group1 70 Region1 Group2 30 Region1 Group3 10 Region1 Total 110 Region2 Group1 210 Region2 Group2 90 Region2 Group3 50 Region2 Total 350 Region3 Group1 170 Region3 Group2 15 Region3 Group3 60 Region3 Total 245 ; run;   proc sort data=have out=want; by Region Count; run; 　 data want(drop=supp last_supp);; set want; by Region; if count lt 20 then supp=1; last_supp=ifn(first.Region,.,lag(supp)); if last_supp then supp=1; if supp = 1 then count=.; run;   proc sort; by Region group; run; ... View more

Hi Art,   Thank you very much for your quick response! I tried the code and it's working well! The only thing is that I'd like a blank for suppressed data, instead of deleting them. I'd like the data like this: Region Group Count Region1 Group1 70 Region1 Group2 Region1 Group3 Region1 Total 110 Region2 Group1 210 Region2 Group2 90 Region2 Group3 50 Region2 Total 350 Region3 Group1 170 Region3 Group2 Region3 Group3 Region3 Total 245 Thank you! ... View more