Date Function

[marianhabesland]

I am trying to create a function that creates a numeric variable called BirthDt that basically combines the BirthYear, BirthMonth and BirthDay into one numerical variable, ie so the BirthDt for the first observation would be 199. I am struggling with which function to actually use for this. Any advice?

[SASKiwi · Accepted solution]

MDY is the one to use here:

BirthDate = mdy(BirthMonth, BirthDay, BirthYear);
format BirthDate date9.; 

[marianhabesland]

Thanks! That worked perfectly. There are so many date functions, I was struggling finding one to use.

[SASKiwi]

Good to hear. You are right, there are a lot of date functions and it can be hard to find a suitable one.