topic Re: Duplicate variables warning in Proc SQL merge in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/Duplicate-variables-warning-in-Proc-SQL-merge/m-p/74361#M21552 Thanks. Fri, 09 Apr 2010 09:15:07 GMT VD 2010-04-09T09:15:07Z Duplicate variables warning in Proc SQL merge https://communities.sas.com/t5/SAS-Procedures/Duplicate-variables-warning-in-Proc-SQL-merge/m-p/74359#M21550 On merging two tables with same variable names, SAS gives the warning of 'variables already exist'.<BR /> <BR /> One way out given in the forums is to use mention each variable by its name.<BR /> <BR /> Is there any other method in Proc SQL to merge the tables without getting this warning?<BR /> Thanks.<BR /> <BR /> Vikas Thu, 08 Apr 2010 15:56:36 GMT https://communities.sas.com/t5/SAS-Procedures/Duplicate-variables-warning-in-Proc-SQL-merge/m-p/74359#M21550 VD 2010-04-08T15:56:36Z Re: Duplicate variables warning in Proc SQL merge https://communities.sas.com/t5/SAS-Procedures/Duplicate-variables-warning-in-Proc-SQL-merge/m-p/74360#M21551 You can rename one of the variables in the FROM clause of the SELECT. Thu, 08 Apr 2010 16:09:13 GMT https://communities.sas.com/t5/SAS-Procedures/Duplicate-variables-warning-in-Proc-SQL-merge/m-p/74360#M21551 Doc_Duke 2010-04-08T16:09:13Z Re: Duplicate variables warning in Proc SQL merge https://communities.sas.com/t5/SAS-Procedures/Duplicate-variables-warning-in-Proc-SQL-merge/m-p/74361#M21552 Thanks. Fri, 09 Apr 2010 09:15:07 GMT https://communities.sas.com/t5/SAS-Procedures/Duplicate-variables-warning-in-Proc-SQL-merge/m-p/74361#M21552 VD 2010-04-09T09:15:07Z