proc sql;
create table test as
SELECT DISTINCT
FC_ATTORNEY_ID, FC_ATTORNEY_NM, REC_CHNG_DT
FROM T_FORECLOSURE T_FORECLOSURE
WHERE (FC_ATTORNEY_ID, REC_CHNG_DT) IN
(
SELECT
FC_ATTORNEY_ID
, MAX (REC_CHNG_DT) AS LST_DT
FROM T_FORECLOSURE T_FORECLOSURE
WHERE REC_CHNG_CD In ('A','C')
GROUP BY FC_ATTORNEY_ID
) AND REC_CHNG_CD In ('A','C')
;quit;
I received the above code from another dept. They use TOAD. When I run this in sas I get the following errors;
22 proc sql;
23 create table test as
24 SELECT DISTINCT
25 FC_ATTORNEY_ID, FC_ATTORNEY_NM, REC_CHNG_DT
26 FROM RDX.T_FORECLOSURE T_FORECLOSURE
27 WHERE (FC_ATTORNEY_ID, REC_CHNG_DT) IN
_
79
ERROR 79-322: Expecting a (.
28 (
29 SELECT
30 FC_ATTORNEY_ID
31 , MAX (REC_CHNG_DT) AS LST_DT
32 FROM RDX.T_FORECLOSURE T_FORECLOSURE
33 WHERE REC_CHNG_CD In ('A','C')
34 GROUP BY FC_ATTORNEY_ID
35 ) AND REC_CHNG_CD In ('A','C')
36 ;
_
79
ERROR 79-322: Expecting a ).
... View more
