Date:         Wed, 13 Feb 2008 14:10:32 -0500
Reply-To:     "Howard Schreier <hs AT dc-sug DOT org>"
              <schreier.junk.mail@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Howard Schreier <hs AT dc-sug DOT org>"
              <schreier.junk.mail@GMAIL.COM>
Subject:      Re: Receiving warning using proc sql

On Wed, 13 Feb 2008 13:38:43 -0500, Pareen Patel <mditconsult@GMAIL.COM> wrote:

>When i am witing below code i am receiving warning for common variables in
>other files.
>Warning ; Variables already exits in file x
>Warning ; Variables already exits in file y
>
>Warning ; Variables already exits in file z
>
>Could some one help me please
>
>
>proc sql;
>create table temp_gaz.sflfcgf2 as
>select a.extcmno,
>       b.*,    c.*,    d.*,    e.* , f.* ,g.* ,h.* ,i.*
>from final1 a inner join lac_com.lac_cgf_basic b on (a.extcmno=b.extcmno)
>     inner join lac_com.lac_cgf_supp c on
>(a.extcmno=c.extcmno)
>     inner join can_com.can_cgf_basic d on
>(a.extcmno=d.extcmno)
>     inner join japa_com.japa_cgf_basic e on
>(a.extcmno=e.extcmno)
>     inner join japa_com.japa_cgf_supp f on
>(a.extcmno=f.extcmno)
>     inner join emea_com.emea_cgf_basic g on
>(a.extcmno=g.extcmno)
>     inner join emea_com.emea_cgf_supp h on
>(a.extcmno=h.extcmno)
>     inner join us_com.us_cgf_basic_supp i on
>(a.extcmno=i.extcmno);
>     quit;

Here is a simple, self-contained example of the problem.

   data one; var = 1; run;
   data two; var = 1; run;

   proc sql;
   create table three as select * from one join two on 1;
   quit;

Result includes "WARNING: Variable var already exists on file WORK.THREE.".
You can't have two variables with the same name in a SAS data set.