IF WANT ONLY UNIQUE VALUE FROM TABLE A (WHICH IS NOT PRESENT IN TABLE B) YOU CAN USE THIS. PROC SQL NOPRINT; CREATE TABLE REFDATE_PORTFOLIOS AS SELECT A.PERMNO, /*A.DATE,*/ A.CUSIP/*, A.SHRCD, A.PRC, A.VOL, A.RET, A.SHROUT, A.VWRETD, B.R_RET*/ FROM /*PERFECT.*/CRSP_COMMONSTOCKS as A LEFT JOIN /*PERFECT.*/MAX_DECILED as B ON A.REFDATE=B.REFDATE and A.CUSIP=B.CUSIP WHERE B.CUSIP IS NULL; quit;
... View more