Filling Zeros where data is null in proc tabulate.

[Kirito1]

I am working on proc tabulate and I want to fill all the null entry cell with zeros what should I do.

Following is the code and ss of the result while i used proc tabulate.

proc tabulate data=DST_EMP3 out= F1 (drop=_TYPE_ _PAGE_ _TABLE_);
  class EMP_CODE DATE_OF_APPROVAL;
  table EMP_CODE, DATE_OF_APPROVAL;
run;

I want where data is showing .(dot) it should be replaced by 0(zero).

Thanks

[Kurt_Bremser]

Set

options missing=0;

before running TABULATE.

[Patrick · Accepted solution]

Add the following line of code before your Proc Tabulate

options missing='0';

Alternatively if you don't want to change this globally something like below would also work.

proc format;
  value missingToZero
    .='0'
    ;
run;

proc tabulate data=DST_EMP3 out= F1 (drop=_TYPE_ _PAGE_ _TABLE_);
  class EMP_CODE DATE_OF_APPROVAL;
  table EMP_CODE, DATE_OF_APPROVAL*f=missingToZero.;
run;