topic Re: How to grab observations with particular count of any value of variable in SAS Programming

How to grab observations with particular count of any value of variable

Sarvendra — Mon, 10 Feb 2014 17:51:08 GMT

I have a dataset with ACCNO as a variable.

we need to grab all the observations with ACCNOs with COUNT 3 or more .(or to create a new dataset with COUNT 3 or more)

I was thinking to implement this logic using first and last temporary variables but it was giving error.

When it will read the first observation of any individual account number then initialize n=0 and increment each iterating time and when it will read last observation of any individual account then if value of n greator than or equal to 3 the it should

Create a new dataset satisfying this condition.

Can there be any better logic for this .as below logic not working

data ssingh.FINADVNEWariable

set ssingh.FINADV

by ACCNO;

if first.ACCNO then n = 0;

n + 1;

if last.ACCNO and n gt 3 then output ;

run;

Please reply

Re: How to grab observations with particular count of any value of variable

Reeza — Mon, 10 Feb 2014 19:08:31 GMT

A Proc SQL step works nicely (untested)

proc sql;

create table want as

select * from

have where accno in (select accno from have group by accno having count(accno)>3);

quit;

Re: How to grab observations with particular count of any value of variable

SASKiwi — Mon, 10 Feb 2014 19:10:37 GMT

Your code has syntax errors. You are missing semicolons on the first two lines:

data ssingh.FINADVNEWariable;

set ssingh.FINADV;

Otherwise your code should work as long as the dataset on the SET statement is sorted.

Re: How to grab observations with particular count of any value of variable

Fugue — Mon, 10 Feb 2014 19:18:21 GMT

Seems to be a duplication of https://communities.sas.com/message/196596#196596

Re: How to grab observations with particular count of any value of variable

Astounding — Mon, 10 Feb 2014 19:19:07 GMT

Perhaps a smaller issue ...

Your original post asks for count greater than or equal to 3.

gt means "greater than"

ge means "greater than or equal"

Re: How to grab observations with particular count of any value of variable

Sarvendra — Tue, 11 Feb 2014 07:08:38 GMT

Thanks a lot Reeza its working absolutely fine.

Re: How to grab observations with particular count of any value of variable

Sarvendra — Tue, 11 Feb 2014 07:09:15 GMT

Thanks it was just a syntax error of semicolumn