A warning in PROC SQL.

deleted_user — Tue, 28 Apr 2009 09:18:58 GMT

I have TAB1 with some variables. One of them is an identity variabel, called ID. In TAB2 I have only the variabel ID. I want to create TAB3, with records from TAB1, for the identities found in TAB2. The code below runs, but I get a warning:

WARNING: Variable ID already exists on file WORK.TAB3.

Q1: Why do I get that warning?

Q2: Is my code correct for the purpose I have described?

My code:

proc sql;
create table tab3 as
select * from tab1, tab2
where tab1.id=tab2.id;
quit;

Re: A warning in PROC SQL.

msg — Tue, 28 Apr 2009 10:03:26 GMT

While you merge the datasets thru. proc sql code, the identical variables are not overwritten, unlike datastep merge. This can be visualized when this code is run removing the "Create table tab3 as" statement.

It is rationale that the variable's name should be unique.

So, you can do either of the following.

A) Select variables explicitly from the datasets.

proc sql;
create table tab3 as
select a.id, a. from tab1 a, tab2 b
where a.id=b.id;
quit;

By this way, you are not asking SAS to keep two "ID" variables, which it wont.

B) Using datastep merge.

Hope this is is useful.

Thanks

topic A warning in PROC SQL. in SAS Procedures

A warning in PROC SQL.

Re: A warning in PROC SQL.