Help using Base SAS procedures

A warning in PROC SQL.

Not applicable
Posts: 0

A warning in PROC SQL.

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
Contributor msg
Posts: 21

Re: A warning in PROC SQL.

Posted in reply to deleted_user
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. from tab1 a, tab2 b

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.

Ask a Question
Discussion stats
  • 1 reply
  • 2 in conversation