Update all cell in table based on conditions

[bob021]

Hi

How to update all cell in table based on value in cell no matters in which column they are?

data work;

input week pert sum tar west;

datalines;

18 200  8400 . 100

19 . 6970 6720 .

20 200 . 9766  .

21 .  8400 . 390

22 100 . 8400 .

;

run;

How to update (.) with (0) in whole table?

Thank you in advance

Bob

[Scott_Mitchell · Accepted solution]

DATA WANT;

SET HAVE;

ARRAY NVARS _NUMERIC_;

DO I = 1 TO DIM(NVARS);

NVARS{I} = TRANSLATE(NVARS{I},0,.);

END;

RUN;

[Scott_Mitchell]

If you only want to change the presentation of the missing value, you could use the missing = option:

options missing='0';

data have;

input week pert sum tar west;

datalines;

18 200  8400 . 100

19 . 6970 6720 .

20 200 . 9766  .

21 .  8400 . 390

22 100 . 8400 .

;

run;

[bob021]

Hi Scoot

Thank you very much

Working like a charm.

Bob

[Scott_Mitchell]

Glad I could help.