How to count nonmissing number of observations

[SeanZ]

Hi, I have a dataset. Two variables, year and return. What I want to do is for each year I want to count NON-missing observations of return and only keep if number is greater than 10. Now I use a proc sql command, and write something like

proc sql;

     create table a as

     select *

     from b

     group by year

     having count(*) >10

     order by year;

quit;

Will this work? My concern is that count option here will number of observations, no matter there is missing or no missing values in variable return.

Thanks.

[RichardinOz]

The N() function counts nonmissing values.

Richard

[RichardinOz · Accepted solution]

COUNT() and FREQ() are synonyms for N() in Proc SQL so your code should work.

Base SAS(R) 9.2 Procedures Guide

Richard