topic Re: Recoding for missing data? in New SAS User

Recoding for missing data?

superman1 — Sun, 14 Mar 2021 23:24:38 GMT

Hello

I am recoding some values with proc format statement and I want to recode the "blanks" or the missing data to "Missing" ? How would I do that?

I already tried this and it didnt work. it still says "Frequency missing= 5" in my proc freq statement and does not recode my missing data.

Proc format library=example;

value $catjt    '.'= 'Missing'; 
run; 

"proc freq statement"

Re: Recoding for missing data?

PGStats — Mon, 15 Mar 2021 00:58:23 GMT

No need to recode the missing values.Try using option MISSING on the TABLES statement instead.

Re: Recoding for missing data?

superman1 — Mon, 15 Mar 2021 01:26:01 GMT

So I would code like this or how so?

Proc freq data=Example.mydata;
tables cat missing ;
format cat $catjt.;
run;

Re: Recoding for missing data?

superman1 — Mon, 15 Mar 2021 01:29:39 GMT

also my assignment requires to label missing values so I need to have it say "missing" for the missing values

Re: Recoding for missing data?

SASKiwi — Mon, 15 Mar 2021 02:04:18 GMT

This is the correct syntax - you can look it up yourself in the documentation. If you select a statement in the SAS editor with your mouse and press F1 then you should get syntax help.

Proc freq data=Example.mydata;
tables cat / missing ;
format cat $catjt.;
run;

Re: Recoding for missing data?

SASKiwi — Mon, 15 Mar 2021 02:07:15 GMT

Try this to get a Missing label:

Proc format;
  value $catjt 
  ' ' = 'Missing'; 
run;

Re: Recoding for missing data?

superman1 — Mon, 15 Mar 2021 02:14:08 GMT

Thank you that worked along with the proc freq comment!