09-05-2013 01:19 AM
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
create table a as
group by year
having count(*) >10
order by year;
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.
Need further help from the community? Please ask a new question.