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
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;
Thanks a lot Reeza its working absolutely fine.
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.
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"
Thanks it was just a syntax error of semicolumn
Seems to be a duplication of https://communities.sas.com/message/196596#196596
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: