topic Re: Replace number by "." in SAS Programming

Replace number by "."

Rodrigue — Wed, 14 Jul 2021 20:53:25 GMT

Dear all,

I have a row (ImplantNYHA) with different values (0,1,2,3,4,99).

I would like to change the 0 and 99 values by "." and keep the 1, 2 , 3 and 4 as they are

I tried

data try; set ICDCRTdatabase;

if ImplantNYHA = 99 then ".";

if ImplantNYHA = 0 then ".";

then ImplantNYHA = ImplantNYHA;

run;

I attached the output.

Thank you !

Re: Replace number by "."

Kurt_Bremser — Wed, 14 Jul 2021 20:59:55 GMT

You need to make a valid assignment, and you can simplify the condition:

data try;
set ICDCRTdatabase;
if ImplantNYHA in (0,99) then ImplantNYHA = .;
run;

Re: Replace number by "."

Rydhm — Wed, 14 Jul 2021 21:05:43 GMT

The variable name is missing and also your variable is Number not char. Use this:

if ImplantNYHA in(0,99) then ImplantNYHA=.;

Re: Replace number by "."

Reeza — Wed, 14 Jul 2021 21:07:02 GMT

Is your variable numeric or character?

If it's character you need to use the quotes around the values, if it's numeric you do not. You use it on one part of the code and then not the other so not sure. SAS didn't error/warn on your comparison so I'm going to assume it's numeric.

FYI you can also use the CALL MISSING() routine where it doesn't matter what the types are.

*for character values;
if imp1nyha in ('0', '99') then call missing(imp1nyha);
*for numeric values;
if imp1nyha in (0, 99) then call missing(imp1nyha);

Re: Replace number by "."

tarheel13 — Wed, 14 Jul 2021 21:03:31 GMT

It looks like it’s a numeric variable so you would not need the “”.

Re: Replace number by "."

Rodrigue — Thu, 15 Jul 2021 10:00:51 GMT

Thank you !