Date:         Wed, 15 May 2002 15:44:27 -0700
Reply-To:     prasad.s.ravi@HOUSEHOLD.COM
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Prasad Ravi <prasad.s.ravi@HOUSEHOLD.COM>
Subject:      Re: Creating duplicate records
Comments: To: Daren Austin <daren.austin@LINEONE.NET>
Content-type: text/plain; charset=us-ascii

Daren:

         Simple way to do this is to output all the single.dose records
into another temporary dataset and append it to the original dataset.

         Like:

        data temp;
                 set original;
                 by dose;
                 if first.dose then output;
       run;

       proc append base=original data=temp;
       run;



Prasad Ravi







                        Daren Austin           To:    SAS-L@LISTSERV.UGA.EDU
                        <daren.austin@LIN      cc:
                        EONE.NET>              Subject:    Creating duplicate records
                        Sent by: "SAS(r)
                        Discussion"
                        <SAS-L@LISTSERV.U
                        GA.EDU>


                        05/15/2002 03:17
                        PM
                        Please respond to
                        Daren Austin





For some obscure reason I need to INSERT duplicates of a record at
certain points in a database with a single variable changed (I'm
creating a control file for a pharmacokinetic analysis using NONMEM if
that means anything to anyone here). Could someone point me in the
correct direction please.

Essentially I want something like:

if first.dose then... duplicate this record only

The record will ultimately not be exactly identical but I'll change
the single parameter (called CMT) on a second data step.

I searched the archive and there is plenty on removing them :-)

Kind regards,

Daren