topic Proc Format - "Other" option in ODS and Base Reporting

Proc Format - "Other" option

Kevin1712 — Thu, 08 Aug 2019 15:13:00 GMT

Hi,

I have created a format called knums and applied it to a test table.

Proc Format;

value knums

1 = "One"

2 = "Two"

3 = "Three"

4 = "Four"

5 = "Five"

Other = "Other Numbers";

Run;

Data Test;

format nbr knums.;

nbr=1; output;

nbr=2; output;

nbr=.; output;

nbr=5; output;

nbr=4; output;

nbr=.; output;

nbr=3; output;

nbr=.; output;

Run;

When I run a Proc Freq against the table I get missing values returned rather than the value set in the format.

Proc Freq Data=Test;

Table nbr;

Run;

Why is this happening and what do I do to change the output?

Thanks in advance

Cynthia_sas — Thu, 08 Aug 2019 15:20:35 GMT

Hi:

You have to tell PROC FREQ that you want to see the missing values in the tabular output by using the MISSING option:

Proc Freq Data=Test;
Table nbr /missing;
Run;

Then the format that's been permanently assigned in the DATA step program will show the Other Numbers category:

Hope this helps,

Cynthia

Kevin1712 — Thu, 08 Aug 2019 16:05:29 GMT

Thanks for your help!