Table totals

[peter_bolin]

I'm looking for the total value for those in the brackets only (s/b 53). Total should replace the 893. I can't figure out how to do it. Thanks for any help

Thought this would do it, but it didn't.

[Lisa_P]

One solution would be to use Set Analysis in your expression of Summing or counting your cancels to only show a cancel code of one character.

Sum({$<'Cancel code'={"?"}>}[# of cancels])

[Digvijay_Singh]

May be this -

Sum({$<[Cancel code]={"=len(trim([Cancel Code))>0"}>}[# of cancels])

or may be

Sum(if(len(trim([Cancel Code))>0,[# of cancels]))

[peter_bolin]

Thanks for the help.

[peter_bolin]

Thanks for the help

[Digvijay_Singh]

May be [# of Cancels] is your field name. You can check in your fields list and correct if you know how to do it.

[peter_bolin]

This gets me close. Thanks for your help help! I don't want to take up too much of your time. Thanks again! 

proc freq data=out.success_rate_aphs;

where '27JAN18'D<=aph_date1<'26FEB18'D

    and RB_YES_NO=1;

table CANCEL_CODE /nocol norow nocum nopercent;

run;