topic Re: Question about part of an expression in a DI Studio job in SAS Data Management https://communities.sas.com/t5/SAS-Data-Management/Question-about-part-of-an-expression-in-a-DI-Studio-job/m-p/117082#M1366 <HTML><HEAD></HEAD><BODY><P>If this code works then fnr_birthdate() looks to me very much like a user defined function using PROC FCMP <A href="http://support.sas.com/documentation/cdl/en/proc/65145/HTML/default/viewer.htm#p10b4qouzgi6sqn154ipglazix2q.htm" title="http://support.sas.com/documentation/cdl/en/proc/65145/HTML/default/viewer.htm#p10b4qouzgi6sqn154ipglazix2q.htm">Base SAS(R) 9.3 Procedures Guide, Second Edition</A></P></BODY></HTML> Mon, 07 Jan 2013 20:54:32 GMT Patrick 2013-01-07T20:54:32Z Question about part of an expression in a DI Studio job https://communities.sas.com/t5/SAS-Data-Management/Question-about-part-of-an-expression-in-a-DI-Studio-job/m-p/117081#M1365 <HTML><HEAD></HEAD><BODY><P>I'm working in a DI Studio job that someone else have created, and have a question.</P><P></P><P>One of the variables in an extract is called Birth_DT. It's mapped in from two variables from the previous work table, namely Birth_DT and Master_ID (which is the PK). It has the following expression:</P><P></P><P style="padding-left: 30px;">coalesce(BIRTH_DT, fnr_birthdate(MASTER_ID))</P><P></P><P>I'm well aware of how coalesce works, but what does "fnr_birthdate(MASTER_ID)" do? The term "fnr_birthdate" doesn't appear anywhere else in the code.</P><P></P><P>Thanks.</P></BODY></HTML> Mon, 07 Jan 2013 09:11:24 GMT https://communities.sas.com/t5/SAS-Data-Management/Question-about-part-of-an-expression-in-a-DI-Studio-job/m-p/117081#M1365 TurnTheBacon 2013-01-07T09:11:24Z Re: Question about part of an expression in a DI Studio job https://communities.sas.com/t5/SAS-Data-Management/Question-about-part-of-an-expression-in-a-DI-Studio-job/m-p/117082#M1366 <HTML><HEAD></HEAD><BODY><P>If this code works then fnr_birthdate() looks to me very much like a user defined function using PROC FCMP <A href="http://support.sas.com/documentation/cdl/en/proc/65145/HTML/default/viewer.htm#p10b4qouzgi6sqn154ipglazix2q.htm" title="http://support.sas.com/documentation/cdl/en/proc/65145/HTML/default/viewer.htm#p10b4qouzgi6sqn154ipglazix2q.htm">Base SAS(R) 9.3 Procedures Guide, Second Edition</A></P></BODY></HTML> Mon, 07 Jan 2013 20:54:32 GMT https://communities.sas.com/t5/SAS-Data-Management/Question-about-part-of-an-expression-in-a-DI-Studio-job/m-p/117082#M1366 Patrick 2013-01-07T20:54:32Z