An error is occurring when running the command below in SAS DI.
The SAS does not accept the IN command with more than one parameter?
proc sql;
delete from LIB_REF1.ODS_CUSTOMER
where
(ODS_CUSTOMER.ID1, ODS_CUSTOMER.ID2) IN (
select CUST.ID1,CUST.ID2 from LIB_REF2.CUST
)
;
Its same as
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
Save the date!
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.