Help using Base SAS procedures

Duplicate variables warning in Proc SQL merge

Reply
Frequent Contributor
Frequent Contributor
Posts: 94

Duplicate variables warning in Proc SQL merge

On merging two tables with same variable names, SAS gives the warning of 'variables already exist'.

One way out given in the forums is to use mention each variable by its name.

Is there any other method in Proc SQL to merge the tables without getting this warning?
Thanks.

Vikas
Trusted Advisor
Posts: 2,116

Re: Duplicate variables warning in Proc SQL merge

You can rename one of the variables in the FROM clause of the SELECT.
Frequent Contributor
Frequent Contributor
Posts: 94

Re: Duplicate variables warning in Proc SQL merge

Thanks.
Ask a Question
Discussion stats
  • 2 replies
  • 148 views
  • 0 likes
  • 2 in conversation