topic Re: reduce a data base on time point in SAS Procedures

Keep records that are duplicated - remove unique records

desireatem — Sun, 07 May 2017 19:09:30 GMT

Hello ,

I want to create data "B" from data "A". That is , I want to keep only data with at least two time points;

Data a,
Input id timepoint;
Cards;
001     1
001     2
001     3
002    1
003    1
003    2
004    1
005    1
;
 
Run;

Data "B" is created from data "A". id 002 , 004 and 005 are dropped because they are just one time points.

Data B;
Input id timepoint;
Cards;
 
001     1
001     2
001     3
 
003    1
003    2
;
run;

Re: reduce a data base on time point

novinosrin — Sun, 07 May 2017 18:20:46 GMT

proc sql;

create table b as

select *

from a

group by id

having count(id)>1;

quit;

Re: Keep records that are duplicated - remove unique records

Reeza — Sun, 07 May 2017 19:11:15 GMT

You can use the NOUNIQUEKEY option on PROC SORT.

proc sort
     data = sashelp.adomsg
          out = duplicates
          uniqueout = singles
          nouniquekey;
     by msgid;
run;

Re: reduce a data base on time point

desireatem — Sun, 07 May 2017 21:07:37 GMT

Thanks

Re: Keep records that are duplicated - remove unique records

Jagadishkatam — Mon, 08 May 2017 02:11:31 GMT

With datastep as well


data a2;
do until(last.id);
set a;
by id timepoint;
if first.id then count=1;
else count+1;
end;
do until(last.id);
set a;
by id timepoint;
if count>1 then output ;
end;
run;