Date:         Tue, 17 Jul 2001 13:30:46 -0400
Reply-To:     Howard Schreier <howard_schreier@ITA.DOC.GOV>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Howard Schreier <howard_schreier@ITA.DOC.GOV>
Subject:      Re: update format questions

When I test using SAS 8.1 (Windows), I find that for variables which are in
both TAB1 and TAB2, TAB3 inherits formats from TAB1.

To override this, insert the following statement (important) *before* the
UPDATE statement:

   if 0 then set tab2(obs=0);

This does not bring in any data and in fact is never executed, but it will
give attributes from TAB2 priority. But if in fact you want the attributes
from TAB1 to have priority, no such statement should be necessary.

On Tue, 17 Jul 2001 11:46:47 -0400, Isson, Jean-Paul
<Jean-Paul.Isson@MICROCELL.CA> wrote:

>Hi everyone,
>I  have  two  data  sets  say: tab1 with  variables  var1,var2,var3
....,varn;
>                                 and    tab2 with  variables  var3...
varn-1,varp1, varq;
>I would like to  update  tab1 with information from tab2  for
var3,...varn-1;
>The  update commande did  well ,but  I have a problem with format
>variables var3,var4,...varn-1 are not defined in the same format in both
data sets tab1 and tab2.
>How  can I update tab1 by keeping only tab1 format or how can I fixe this
problem.
>
>The  code  I run is :
>data tab3;
>update tab1 tab2;
>by id ;
>run;
>
>Does  anyone know  how to  do that or  give some hint?
>Thanks.
>
>
>
>---------------------------------------------------------------
>Jean-Paul Isson
>Statistical specialist
>DWH-CURT'S Pilot Microcell Solutions
>fido:514-814-5519
>mail  to: jean-paul.isson@microcell.ca
>---------------------------------------------------------------------------
-