BookmarkSubscribeRSS Feed
TurnTheBacon
Fluorite | Level 6

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.

1 REPLY 1
Patrick
Opal | Level 21

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

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 781 views
  • 3 likes
  • 2 in conversation