Date:         Tue, 24 Sep 2002 20:08:13 +0200
Reply-To:     Jan Selchau-Hansen <jan@SELCHAU-HANSEN.DK>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Jan Selchau-Hansen <jan@SELCHAU-HANSEN.DK>
Organization: TDC Internet
Subject:      Re: Duplicated Records - SORRY TYPO

SORRY  for the TYPO !
it should have been
 ...
 if sum(first.acctno,LAST.acctno) ne 2
....
"Jan Selchau-Hansen" <jan@selchau-hansen.dk> wrote in message
news:3d902cd5$0$39016$edfadb0f@dspool01.news.tele.dk...
> Sort the dataset by ACCTNO.
> Use a datastep like this.
>
> data dup;
>  set orginaldata.
>  if sum(first.acctno,first.acctno) ne 2 ;
> run;
>
> thats it !
>
> Jan Selchau-Hansen
> "Jassim Rahma" <jassimrahma@HSBC.COM> wrote in message
> news:OF547E9E4D.85FC6B98-ON44256C3E.00286F13@systems.uk.hsbc...
> > How can I check if the dataset contains duplicated account numbers
> (ACCTNO)
> > and send duplicated records to a new dataset for future checking?
> >
> > Many Thanks,
> > Jassim Rahma
> >
> >
> >
> > ** HSBC's website is at www.hsbc.com **
> >
> > ********************************************************************
> >  This message and any attachments are confidential to the ordinary
> >  user of the e-mail address to which it was addressed and may also
> >  be privileged. If you are not the addressee you may not copy,
> >  forward, disclose or use any part of the message or its
> >  attachments and if you have received this message in error, please
> >  notify the sender immediately by return e-mail and delete it from
> >  your system.
> >
> >  Internet communications cannot be guaranteed to be secure or
> >  error-free as information could be intercepted, corrupted, lost,
> >  arrive late or contain viruses. The sender therefore does not
> >  accept liability for any errors or omissions in the context of
> >  this message which arise as a result of Internet transmission.
> >
> >  Any opinions contained in this message are those of the author and
> >  are not given or endorsed by the HSBC Group company or office
> >  through which this message is sent unless otherwise clearly
> >  indicated in this message and the authority of the author to so
> >  bind the HSBC entity referred to is duly verified.
> >
> > ********************************************************************
>
>