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

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

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
  • 965 views
  • 3 likes
  • 2 in conversation