topic Re: Proc SQL left join warning message in SAS Programming

Proc SQL left join warning message

HitmonTran — Fri, 07 Jun 2019 20:00:13 GMT

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;

Re: Proc SQL left join warning message

PGStats — Fri, 07 Jun 2019 20:04:56 GMT

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

Re: Proc SQL left join warning message

HitmonTran — Fri, 07 Jun 2019 20:30:25 GMT

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