Date:         Fri, 20 Aug 2004 05:46:45 -0400
Reply-To:     Andrew Bolton <Andrew.Bolton@IDENTEX.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Andrew Bolton <Andrew.Bolton@IDENTEX.COM>
Subject:      modify master set with duplicates

I had a look through the archive but couldn't see an answer to this query,
apologies if I've missed it though.

The code below runs fine but - I have duplicates of the indexvar in the
master_dataset.  These are legitimate and I can't remove them, but I'm not
sure how to ammend it to append the data to the second instance of the
index.

I'm sure I've done this (along time ago!) but can't remember the solution.
The online help covers multiple vars in the Transaction table, (and also
the non matched data), but not multiple records in the master table
(again, unless I've missed it).

Any help much appreciated,

Andy.

SAS Code:
data master_dataset;
 set transaction_dataset;
 modify master_dataset key=[indexvar] / Unique;
 select(_iorc_);
   when(%sysrc(_sok))
    do;
     This=That etc;
     replace;
    end;
    when(%sysrc(_dsenom))
     do;
      _error_=0;
     end;
   otherwise;
 end;
run;