topic How could I get rid of this warning! in SAS Procedures

How could I get rid of this warning!

Mirisage — Mon, 03 Sep 2012 16:45:56 GMT

Hi Colleagues,

I have these 2 datasets.

data table_1;

input Account_number;

cards;

11111111

12222222

;

run;

data table_2;

input Account_number Account_name $ 10-26;

cards;

11111111 AAAAA IIIII LLLL

100000 WWWWWWW SSSSS DDD

100002 TTTTTT EEEEEEE

102222 NNNNNN

12222222 OOOOOO YYYYYYY

;

run;

Question:

When join the above 2 tables using below code, it does the job correctly but a warming comes in the log like this:

/*WARNING: Variable Account_number already exists on file WORK.ANY_NAME.

How come this? How could I get rid of it?

proc sql;

create table any_name as

select a.* ,

b.*

from table_1 a,

table_2 b

where a.account_number=b.account_number;

quit;

Your heilp is greatly appreciated.

Thanks

Mirisage

Re: How could I get rid of this warning!

DanielSantos — Mon, 03 Sep 2012 17:03:34 GMT

Just loose the a.* in the select

proc sql;

create table any_name as

select a.* ,

b.*

from table_1 a,

table_2 b

where a.account_number=b.account_number;

quit;

Since you're selecting just the key from A, and the where clause restricts the query to a inner join (same value on both sides), it' doesn't matter from which table comes the Account_Number.

Cheers from Portugal.

Daniel Santos @ www.cgd.pt

Re: How could I get rid of this warning!

JerryH — Fri, 07 Sep 2012 18:23:37 GMT

In case you have two data sets that have multiple variables you wish to keep, you can use the <dsnam>* approach for one but for the other you need to specify the variables you wish to extract from it but not the key variable. You will then not get tthat warning

Re: How could I get rid of this warning!

Mirisage — Mon, 10 Sep 2012 19:20:58 GMT

Hi Jerry,

Thank you very much for your inputs.

Regards

Mirisage