topic Re: Update all cell in table based on conditions in SAS Procedures

Update all cell in table based on conditions

bob021 — Wed, 28 Aug 2013 09:42:10 GMT

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 — Wed, 28 Aug 2013 09:48:04 GMT

DATA WANT;

SET HAVE;

ARRAY NVARS _NUMERIC_;

DO I = 1 TO DIM(NVARS);

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

END;

RUN;

Scott_Mitchell — Wed, 28 Aug 2013 09:52:04 GMT

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 — Wed, 28 Aug 2013 10:53:51 GMT

Hi Scoot

Thank you very much

Working like a charm.

Bob

Scott_Mitchell — Wed, 28 Aug 2013 11:36:51 GMT

Glad I could help.