SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Question about part of an expression in a DI Studio job

Reply
Frequent Contributor
Posts: 89

Question about part of an expression in a DI Studio job

I'm working in a DI Studio job that someone else have created, and have a question.

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:

coalesce(BIRTH_DT, fnr_birthdate(MASTER_ID))

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.

Thanks.

Respected Advisor
Posts: 3,902

Re: Question about part of an expression in a DI Studio job

If this code works then fnr_birthdate() looks to me very much like a user defined function using PROC FCMP Base SAS(R) 9.3 Procedures Guide, Second Edition

Ask a Question
Discussion stats
  • 1 reply
  • 171 views
  • 3 likes
  • 2 in conversation