Date:         Tue, 12 Dec 2006 13:17:59 -0500
Reply-To:     Arthur Tabachneck <art297@NETSCAPE.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Arthur Tabachneck <art297@NETSCAPE.NET>
Subject:      Re: How to split out the file
Comments: To: SUBSCRIBE SAS-L Irin Ros <irinfigvam@YAHOO.COM>

Irin,

Depends upon the rules concerning the records with different cov_term_dt.

Would something like the following suffice:

data have;
  input mem_num cov _term_dt date9.;
  cards;
1 10May2006
1 11May2006
2 10May2006
3 10May2006
4 10May2006
4 10May2006
;
run;
proc sort data=have;
  by mem_num;
run;
data duplicates uniques;
  set have;
  by mem_num;
  if first.mem_num and last.mem_num then output uniques;
  else output duplicates;
run;

HTH,
Art
------
On Tue, 12 Dec 2006 09:55:30 -0800, Irin later <irinfigvam@YAHOO.COM>
wrote:

>I have a file with two fields:
>
>   mem_num (IDs)
>  cov _term_dt
>
>   I need to split out the file into two files:
>
>
>   the first file have isolated records of members who have the same
mem_num and  different cov _term_dt
>   Another one to have just those members with unique mem_num
>  How can I implement it in code?
>
>  Thank you in advance
>
>  Irin
>
>
>
>---------------------------------
>Have a burning question? Go to Yahoo! Answers and get answers from real
people who know.