I don't think that it's documented, but you can use the nowarn option in proc sql to get rid of the warning message.
proc sql nowarn;
create table a_comb as
select *
from a1, a2
where a1.msgid = a2.msgid
;
Per @SASKiwi :
please note that the NOWARN option will block all warnings in that step, so if something unexpected happens you may end up blocking other warnings you may prefer to see. Also you are still left with the duplicate columns in the dataset. As long as you are OK with these limitations then no problem!
I don't think that it's documented, but you can use the nowarn option in proc sql to get rid of the warning message.
proc sql nowarn;
create table a_comb as
select *
from a1, a2
where a1.msgid = a2.msgid
;
Per @SASKiwi :
please note that the NOWARN option will block all warnings in that step, so if something unexpected happens you may end up blocking other warnings you may prefer to see. Also you are still left with the duplicate columns in the dataset. As long as you are OK with these limitations then no problem!
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.