topic Re: how do i retain observations with more than 4 reportdates in SAS Procedures

how do i retain observations with more than 4 reportdates

aarony — Fri, 18 Apr 2014 01:45:17 GMT

hi, thank you in advance for your kind attention.

i have 2 variables: COMPANYID and YEAR

COMPANYID is between 1-100. YEAR can be anywhere between 1950-2013

I want to keep the COMPANYIDs that have more than 10 years within them.

for example:

companyID 1 may have year 1950, 1951 only. i want to drop companyID 1 completely because i only see 2 years and my threshold is 10.

Can you provide me your guidance?

thank you!

Reeza — Fri, 18 Apr 2014 02:40:36 GMT

Do the years need to be consecutive, or do any 10 years count?

proc sql;

create table want as

select companyid, year, count(*) as count_years

from have

group by companyid

having count(year)>10;

quit;

aarony — Fri, 18 Apr 2014 02:43:41 GMT

thank you for your reply reeza.

what if i want them to fall in a specific time period? ie: 1950-1960? thank you much!

Reeza — Fri, 18 Apr 2014 02:53:59 GMT

Add in a where clause, 1950 to 1960 is an 11 year period though.