topic How to get the number of different ID for each year? in Statistical Procedures

How to get the number of different ID for each year?

thdang — Mon, 25 Mar 2013 16:38:18 GMT

Hi, Does anyone know how to count the number of different id for each year.

I have a data sample from 1990-2010 which contains time series data of different id. The number of different id is different per year.

proc sql;

create table dataout as

select

count(distinct id)

from

datain;

quit;

codes above work for the whole data set but not per year. Thanks in advance

Reeza — Mon, 25 Mar 2013 16:41:24 GMT

Add a group by year clause in.

thdang — Mon, 25 Mar 2013 16:46:17 GMT

thanks Reeza