Help making one value that was entered as -8 into missing for one variable.

[gtucke1]

The variable ci_2n has a value that was entered as -8. This should be changed to be missing. Below is the code I've tried:

Data unmet.original5;
Set unmet.original4;
If ci_2n = -8 then ci_2n_fix = '.';
Run;

Proc freq data = unmet.original5;
Table ci_2n_fix;
Run;

The table now shows all 637 observations as missing.

I don't know how to make the -8 vale as missing without making all of the observations as

: 

[PaigeMiller]

Data unmet.original5;
Set unmet.original4;
If ci_2n = -8 then ci_2n_fix = .;
else ci_2n_fix = ci_2n;
Run;

or

Data unmet.original5;
Set unmet.original4;
If ci_2n = -8 then ci_2n = .;
Run;

[Anne_A]

A few questions:

• Why is your new variable a character one while the original is numeric?
• What is the frequency of ci_2n being equal to -8 in your original dataset?