Hello everybody,   I'm not sure how to convert the following Oracle SQL syntax with DECODE function in to Proc SQL syntax within SAS. Your assistance would be greatly appreciated.   DECODE(( con.AREA_CODE ),NULL,NULL,'('||( con.AREA_CODE )||') ')||( con.CONTACT_NUMBER )||DECODE(( con.EXTENSION ),NULL,NULL,' ext.'||( con.EXTENSION )) as Ind_Home_Phone ,     Thanks ... View more