Proc SQL left join warning message

[HitmonTran]

Hi All,

I need help removing this warning log message:

"WARNING: Variable USUBJID already exists on file WORK.DS0."

I've searched for answers in other posts but nothing was able to fix.  Can anyone help me?? Thanks.

proc sql noprint;  
	create table DS0 as
	select A.* ,B.USUBJID, B.RFSTDTC, B.RFENDTC, B.RFXSTDTC, B.RFXENDTC 
	from ct as A left join
             sdtm.dm as B 
	on A.usubjid = B.usubjid;
quit;

[PGStats · Accepted solution]

Remove B.subjid from the select columns. You don't need it since it is already in table ct.

[HitmonTran]

wow thanks PGStats! I spend a couple hours reading and testing different solutions until I decided to post. Thank you! you made my Friday