Hi:   With PROC TABULATE, you can use a format to do some highlighting, such as shown below: However, this format applies to both columns for COLPCTN. Not just the M column. It happened to work because I hardcoded 10.00 and 30.00 which were only found in the M column.     With different values in the format, my format would impact both columns, like this:     The only way to JUST touch one of the cell values in the M column without impacting the F column would be to switch to PROC REPORT or possibly the Report Writing Interface. But for calculating COLPCTN, you might want to use TABULATE to generate the values and then use REPORT for the color coding. Your logic is not entirely clear to me for the color coding your want.   Hope this helps, Cynthia ... View more

I am not going to suggest any "automagic" solution because the solution will require macro coding; the code is likely to be ugly, fragile possibly subject to abuse.   Use the information from your proc freq output to modify the N= clause to match the data you have. I think n= (50 50 50 50 54 46 76 24 81 19 94 6 95 5) Since you have two strata variables the first n is for the first Location and first value of Program, the second is the first Location value and the 2nd program, the third is the second Location and 1st program, second location 2nd program and so forth.     This will at least provide appropriate selection probabilities and weighting values for the different strata sizes. Or use the information to create an appropriate SAMPSIZE data set which would have the desired sample sizes for each combination of strata variables. This set would look a lot like the n= list above. date work.sampsize; input location $ program $ sampsize; datalines; A Alpha 50 A Beta 50 B Alpha 50 B Beta 50 C Alpha 94 C Beta 46 D Alpha 76 D Beta 24 E Alpha 81 E Beta 19 F Alpha 94 F Beta 6 G Alpha 95 G Beta 5 ; run; You reference the data set name on the N= (or SAMPSIZE= ) option in the proc statement.   The data set approach would be the easiest to create an automagic and could be done to adjust either Alpha or Beta sampsizes. But since you are using EG and the code you show looks to be pretty straight from the interface menus that might be just a bit past your experience level. This would be where one of my professors used to say "Left as an exercise for the interested reader." ... View more