BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
ganeshmule
Fluorite | Level 6
data abcd;
input ID;
cards;
1
1
1
2
2
1
2
3
3
3
;
run;


answer would be like below :
Output:
1
1
1
2
2
3
3
3

 

1 ACCEPTED SOLUTION

Accepted Solutions
mkeintz
PROC Star

I think what you mean is to keep only the first group of records for any given ID:

 

data abcd;
input ID;
cards;
1
1
1
2
2
1
2
3
3
3
;
run;

data want;
  set abcd;
  by id notsorted;
  if _n_=1 then do;
    declare hash h();
      h.definekey('id');
      h.definedone();
  end;
  if h.check()=0 then delete;
  if last.id then h.add();
run;
--------------------------
The hash OUTPUT method will overwrite a SAS data set, but not append. That can be costly. Consider voting for Add a HASH object method which would append a hash object to an existing SAS data set

Would enabling PROC SORT to simultaneously output multiple datasets be useful? Then vote for
Allow PROC SORT to output multiple datasets

--------------------------

View solution in original post

2 REPLIES 2
mkeintz
PROC Star

I think what you mean is to keep only the first group of records for any given ID:

 

data abcd;
input ID;
cards;
1
1
1
2
2
1
2
3
3
3
;
run;

data want;
  set abcd;
  by id notsorted;
  if _n_=1 then do;
    declare hash h();
      h.definekey('id');
      h.definedone();
  end;
  if h.check()=0 then delete;
  if last.id then h.add();
run;
--------------------------
The hash OUTPUT method will overwrite a SAS data set, but not append. That can be costly. Consider voting for Add a HASH object method which would append a hash object to an existing SAS data set

Would enabling PROC SORT to simultaneously output multiple datasets be useful? Then vote for
Allow PROC SORT to output multiple datasets

--------------------------
ganeshmule
Fluorite | Level 6

Thanks it works 

sas-innovate-white.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9.

 

Early bird rate extended! Save $200 when you sign up by March 31.

Register now!

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 635 views
  • 3 likes
  • 2 in conversation