Syntax error for WHERE clause when using proc sql

Question

I am new to SAS and I need to recreate a query I had running using R. The syntax rules may be different in SAS but I dont see where I am going wrong here

Table "Old" columns: A, B, C, D, E

Table "New" columns: A, B, C, D, E

PROC SQL;
                create table delta as
                SELECT *
                FROM New
                WHERE
                (A, B, C)
                IN(
                SELECT (A, B, C)
                FROM New
                EXCEPT 
                SELECT A, B, C
                FROM Old);

QUIT;

My code should find delta rows based on A, B, C variables.

Error Message on comma

WHERE(A, B, C): ERROR 79-322: Expecting a (.

Is there an easy replacement I can implement for the same logic? Please let me know. Thanks. — BadKarma1122
– BadKarma1122, Commented Jun 5, 2019 at 15:07

ScaisEdge · Accepted Answer · 2019-06-05 15:07:36Z

1

I'm not in sas but could be that this db don't allow the use of tuple in WHERE IN clause.

in this case you could try refactoring your quesry as an inner join

  SELECT *
  FROM New N 
  INNER JOIN  (
      SELECT A, B, C
      FROM New
      EXCEPT 
      SELECT A, B, C
      FROM Old
  ) T ON  T.A  = N.A 
        AND T.B  = N.B  
          AND T.C = N.C

answered Jun 5, 2019 at 15:07

ScaisEdge

133k10 gold badges98 silver badges111 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Syntax error for WHERE clause when using proc sql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related