BookmarkSubscribeRSS Feed
VD
Calcite | Level 5 VD
Calcite | Level 5
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
2 REPLIES 2
Doc_Duke
Rhodochrosite | Level 12
You can rename one of the variables in the FROM clause of the SELECT.
VD
Calcite | Level 5 VD
Calcite | Level 5
Thanks.

hackathon24-white-horiz.png

The 2025 SAS Hackathon Kicks Off on June 11!

Watch the live Hackathon Kickoff to get all the essential information about the SAS Hackathon—including how to join, how to participate, and expert tips for success.

YouTube LinkedIn

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1351 views
  • 0 likes
  • 2 in conversation