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
DATA WANT;
SET HAVE;
ARRAY NVARS _NUMERIC_;
DO I = 1 TO DIM(NVARS);
NVARS{I} = TRANSLATE(NVARS{I},0,.);
END;
RUN;
DATA WANT;
SET HAVE;
ARRAY NVARS _NUMERIC_;
DO I = 1 TO DIM(NVARS);
NVARS{I} = TRANSLATE(NVARS{I},0,.);
END;
RUN;
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;
Hi Scoot
Thank you very much
Working like a charm.
Bob
Glad I could help.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.