topic Re: Help making one value that was entered as -8 into missing for one variable. in New SAS User

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

gtucke1 — Thu, 03 Nov 2022 16:03:46 GMT

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 — Thu, 03 Nov 2022 16:22:56 GMT

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

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

Anne_A — Thu, 03 Nov 2022 16:12:02 GMT

A few questions: