count the number of occurrence certain value and missing values in column

[leeshea06]

Hi, is there a quick way to count number of occurrence of "2", and number of missings (count separately) for x? thanks! Lee
data have;
input id x;
datalines;
id x
1 1
2 2
3 2
4 .
5 1
6 2
7 .
8 1
;

[Tom]

PROC FREQ is an easy way to count.

proc freq data=have ;
  where x in (. 2);
  tables x / missing;
run;

[novinosrin]

data have;
input id x;
datalines;
1 1
2 2
3 2
4 .
5 1
6 2
7 .
8 1
;

proc freq data=have;
 where x in (.,2);
 tables x/list missing;
run;

[PeterClemmensen]

Use PROC FREQ and remember the Missing Option.

data have;
input id x;
datalines;
id x
1 1
2 2
3 2
4 .
5 1
6 2
7 .
8 1
;

proc freq data = have;
   tables x / missing nocum nopercent;
run;

[Ksharp]

Maybe I am full head of SQL.

data have;
input id x;
datalines;
id x
1 1
2 2
3 2
4 .
5 1
6 2
7 .
8 1
;

proc sql;
select sum(x=2) as n_2,nmiss(x) as n_miss
from have;
quit;