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
Depends upon the rules concerning the records with different cov_term_dt.
Would something like the following suffice:
input mem_num cov _term_dt date9.;
proc sort data=have;
data duplicates uniques;
if first.mem_num and last.mem_num then output uniques;
else output duplicates;
On Tue, 12 Dec 2006 09:55:30 -0800, Irin later <irinfigvam@YAHOO.COM>
>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
>Have a burning question? Go to Yahoo! Answers and get answers from real
people who know.