topic Re: Replace value in SAS Programming

Replace value

jitendrakoli — Mon, 24 May 2021 10:48:33 GMT

Dear All,

I want to replace 0 by "Zero" and missing values by "M" in the given data using SAS

Please help me to solve this problem.

dummy data is attached for reference.

Re: Replace value

Kurt_Bremser — Mon, 24 May 2021 11:11:41 GMT

Create a format and use it:

proc format;
value myfmt
  0 = "zero"
  . = "missing"
;
run;

Values not covered by the format will be displayed as is with the default format (best12.).

Please provide your example data in code, as data step with datalines, so we can show you tested code.

Re: Replace value

jitendrakoli — Mon, 24 May 2021 11:24:12 GMT

Dear Sir,

Please find following data in SAS code,

data Conc;

infile datalines delimiter='09'x;

input Subject Seq$ form$ period C1 C2 C3 C4 C5 C6 C7 C8 C9 C10;

cards;

1 AB A 1 0 0.3 7.2 10.3 11.3 12.1 10.3 12.5 13.5 .

1 AB B 2 0 0 4.8 12.7 17.7 17.8 . 24.4 . .

2 BA B 1 0 1.1 9.6 14.5 15.6 13.4 13.6 14.4 14.3 14.3

2 BA A 2 0 0.4 8.1 16.8 15.4 14.4 12.4 13.9 13.9 15.7

3 AB A 1 0 0 0 14.6 16.1 19.7 18 17.8 15.3 15.1

3 AB B 2 0 0.9 8.1 14.2 17.7 20.4 18.5 15.7 14.2 13.2

4 BA B 1 0 0 3.9 9.2 6.2 7.1 7.7 7.9 . 9.1

4 BA A 2 0 0 0 0 14.3 19.7 17.5 13.7 14.3 12.7

5 AB A 1 0 0.4 3.5 6.7 10.9 12 16.8 . 22.3 18.7

5 AB B 2 0 1.1 6.9 11.3 17.4 16.6 15.1 15.1 15.3 15

;;;;

run;

Re: Replace value

Kurt_Bremser — Mon, 24 May 2021 11:33:01 GMT

Just apply the format:

proc format;
value myfmt
  0 = "zero"
  . = "missing"
;
run;

data Conc;
infile datalines;
input Subject  Seq$ form$ period  C1 C2 C3 C4 C5 C6 C7 C8 C9 C10;
format c1-c10 myfmt.;
cards;
1    AB   A    1    0    0.3  7.2  10.3 11.3 12.1 10.3 12.5 13.5 .
1    AB   B    2    0    0    4.8  12.7 17.7 17.8 .    24.4 .    .
2    BA   B    1    0    1.1  9.6  14.5 15.6 13.4 13.6 14.4 14.3 14.3
2    BA   A    2    0    0.4  8.1  16.8 15.4 14.4 12.4 13.9 13.9 15.7
3    AB   A    1    0    0    0    14.6 16.1 19.7 18   17.8 15.3 15.1
3    AB   B    2    0    0.9  8.1  14.2 17.7 20.4 18.5 15.7 14.2 13.2
4    BA   B    1    0    0    3.9  9.2  6.2  7.1  7.7  7.9  .    9.1
4    BA   A    2    0    0    0    0    14.3 19.7 17.5 13.7 14.3 12.7
5    AB   A    1    0    0.4  3.5  6.7  10.9 12   16.8 .    22.3 18.7
5    AB   B    2    0    1.1  6.9  11.3 17.4 16.6 15.1 15.1 15.3 15
;

Re: Replace value

jitendrakoli — Mon, 24 May 2021 12:20:40 GMT

Thank you very much