SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Delete Syntax Error

Reply
Contributor
Posts: 58

Delete Syntax Error

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

         )

   ;

Frequent Contributor
Posts: 106

Re: Delete Syntax Error

Its same as

Ask a Question
Discussion stats
  • 1 reply
  • 231 views
  • 0 likes
  • 2 in conversation