Percentage when value is equal to 0

polpel — Tue, 15 Oct 2019 12:04:09 GMT

Hello,

I'm facing a problem with a percentage.

Basically, I'm doing a PROC tabulate with multiple variable for which I need the individual percentage (colpctsum).

Only problem: one of the columns has all the values to 0 which means I have all the values of the percentage column set to '.'

I need to add this value to another one later on which just isn't possible when it's set to '.'

Any solution, like a force format or something?

Thanks in advance!

Re: Percentage when value is equal to 0

Ksharp — Tue, 15 Oct 2019 12:14:52 GMT

Add one more option PRINTMISS:

proc tabulate .........

class ......./missing ;

table ........../ printmiss ;

run;