Date:         Mon, 29 Jul 2002 06:22:27 -0700
Reply-To:     Xavier Autret <xav_x@NOOS.FR>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Xavier Autret <xav_x@NOOS.FR>
Organization: http://groups.google.com/
Subject:      Re: question about update statement...
Content-Type: text/plain; charset=ISO-8859-1

Well see that very simple example:
Update statement can append new obs in final dataset.
See also the update rule for ID=2.

data OLD;
   input ID 2. CHARA $4.;
   cards;
1 TOTO
2 TITI
3 TUTU
;
run;

data NEW;
   input ID 2. CHARA $4.;
   cards;
1 toto
2
4 NEW
;
run;

data UPDATED;
   update OLD NEW;
   by ID;
run;

UPDATED dataset:

ID   CHARA
----------
1    toto
2    TITI
3    TUTU
4    NEW

Xavier

jimmy.chan@HEC.CA (tin-shun-jimmy chan) wrote in message news:<1a40bc1a0162.1a01621a40bc@hec.ca>...
> Hello,
>
> I have a very strange problem in my program, can you tell me what would be the cause ?
>
> Here is the log file of my program, everything seems correct, but when I check the number of
> observation after update statement, I find out that it doesn't correspond to the number of observations of
> the initial file. In opposite, it works with other datasets (I have extracted smaller samples from this very
> big dataset)
>

...

>
> The final file has 3270350 obs. but the initial file has only 3267213 obs.
>
> Thanks you.
>
> Jimmy