topic Counting number of observations in a period in SAS Procedures

Counting number of observations in a period

Benn — Wed, 13 Feb 2013 12:00:08 GMT

Hi guys,

I currently have data such as this:

DATE CODE

196507 01384

196507 34098

196507 56565

196508 34354

196508 34353

196508 57098

I'm trying to count the number of observations within a month. So I should get

DATE COUNT

196507 3

196508 3

Thanks a lot guys!

Re: Counting number of observations in a period

damanaulakh88 — Wed, 13 Feb 2013 12:06:10 GMT

Hi Benn,

Please find attached the code for the same:-

data raw;

input date code ;

datalines;

196507 01384

196507 34098

196507 56565

196508 34354

196508 34353

196508 57098

;

run;

proc sql;

create table cnt as select date,count(code) as count from raw group by date;

run;

proc print data=cnt;

run;

/Daman

Re: Counting number of observations in a period

Jagadishkatam — Wed, 13 Feb 2013 12:18:59 GMT

we can get the same result in base sas

data test;

input DATE CODE;

cards;

196507 01384

196507 34098

196507 56565

196508 34354

196508 34353

196508 57098

;

run;

proc sort data=test;

by date;

run;

data want;

set test;

retain count;

by date;

if first.date then count=1;

else count+1;

if last.date then output want;

run;

Thanks,

Jagadish