Date:         Thu, 2 Jan 2003 13:16:04 -0500
Reply-To:     "Chen, Jian" <ozz6@CDC.GOV>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Chen, Jian" <ozz6@CDC.GOV>
Subject:      appending a dataset
Content-Type: text/plain

Dear All:

  I am trying to append a small dataset to a big base dataset and delete the
duplicate accounts. Do you have an idea why I couldn't delete the
duplicates? Do you have any other better method? Thanks in advance!

Bei

options nodate;

data one;
 input x $ y;
 cards;
 a  12
 a  34
 b  45
 a  35
 b  75
 ;
 run;

data two;
 input x $ y;
 cards;
 a 23
 b 35
 a 34
 ;
 run;

proc datasets library=work memtype=data;
 append base=one data=two;
 *modify one;
 * index create x;
 run;

proc sort data=one noduplicates ;
 by x;
 run;

proc print data=one;
run;