topic proc freq-show null values dist in SAS Programming

proc freq-show null values dist

Ronein — Sun, 07 May 2023 07:09:02 GMT

Hello

In the output data set "Want" I don't see the freq of null values.

So under variables F_X and F_Y I would like to see how many observations with null value.

What is the way to do it please?(See in output data set the freq of null values for each var in tables statement)

data have;
input x Y;
cards;
1 2
1 3
1 2
. 1
. .
2 1
2 .
;
Run;
proc freq data=have;
ods output onewayfreqs= want;
tables X Y; 
run;

Re: proc freq-show null values dist

Kurt_Bremser — Sun, 07 May 2023 07:31:46 GMT

Maxim 1: Read the Documentation.

See the MISSING and MISSPRINT options for the TABLES Statement

Re: proc freq-show null values dist

Ronein — Sun, 07 May 2023 20:32:53 GMT

Great,

I see that both options (Missing/Missprint) provide same output data set (with attention to distribution of null category).

The only difference is the printed output

data have;
input x Y;
cards;
1 .
1 3
1 2
. 1
. .
2 1
2 .
;
Run;
proc freq data=have;
ods output onewayfreqs= want;
tables X Y /missing; 
run;
proc freq data=have;
ods output onewayfreqs= want;
tables X Y /MISSPRINT; 
run;