Good Evenening, Appreciate all the help in learning 🙂 Love sas! Im trying to create a mail list, and in order for myself to do this, i need search for NOT null values in the death_Dt field, I tried NE. and <>"." but its not working %SASTABLE(ONE.CUST, SELECT CU.CUST_ID ,CU.death_dt , MAFOCU.FIRST_NA , MAFOCU.LAST_NA , MAFOCU.CUST_TYPE_MN , MAFOCU.FULL_BUSNES_NA1 , MAFOCU.CONTRY_MN , MAFOCU.MAIL_ROUTE_CD , MAFOCU.FORMAT_ATTN_LINE_TX , MAFOCU.FORMAT_SPECL_ADDR_TX , MAFOCU.FORMAT_STREET_ADDR_TX , MAFOCU.FORMAT_MNCPTY_ADDR_TX FROM EDW.CUST CU JOIN EDW.MAIL_FORMAT_CURRNT MAFOCU ON MAFOCU.CUST_ID = CU.CUST_ID WHERE (CU.DEATH_DT <>.)); endrsubmit;
... View more