topic Re: How to count nonmissing number of observations in SAS Programming

How to count nonmissing number of observations

SeanZ — Thu, 05 Sep 2013 05:19:17 GMT

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.

Re: How to count nonmissing number of observations

RichardinOz — Thu, 05 Sep 2013 05:56:51 GMT

The N() function counts nonmissing values.

Richard

Re: How to count nonmissing number of observations

RichardinOz — Thu, 05 Sep 2013 06:03:00 GMT

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

Base SAS(R) 9.2 Procedures Guide

Richard