topic Re: Date Function in SAS Studio

Date Function

marianhabesland — Tue, 10 Oct 2017 22:59:48 GMT

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?

Re: Date Function

SASKiwi — Tue, 10 Oct 2017 23:19:24 GMT

MDY is the one to use here:

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

Re: Date Function

marianhabesland — Tue, 10 Oct 2017 23:21:18 GMT

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

Re: Date Function

SASKiwi — Tue, 10 Oct 2017 23:28:56 GMT

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