topic Re: Filling Zeros where data is null in proc tabulate. in New SAS User

Filling Zeros where data is null in proc tabulate.

Kirito1 — Mon, 16 Jan 2023 07:22:37 GMT

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

Re: Filling Zeros where data is null in proc tabulate.

Kurt_Bremser — Mon, 16 Jan 2023 07:26:55 GMT

Set

options missing=0;

before running TABULATE.

Re: Filling Zeros where data is null in proc tabulate.

Patrick — Mon, 16 Jan 2023 07:35:40 GMT

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;