topic Re: count the number of occurrence certain value and missing values in column in SAS Programming

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

leeshea06 — Wed, 20 Jan 2021 14:23:46 GMT

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
;

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

Tom — Wed, 20 Jan 2021 14:29:00 GMT

PROC FREQ is an easy way to count.

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

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

novinosrin — Wed, 20 Jan 2021 14:29:28 GMT

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;

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

PeterClemmensen — Wed, 20 Jan 2021 14:31:02 GMT

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;

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

Ksharp — Thu, 21 Jan 2021 12:47:07 GMT

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;