topic Re: Working with dates in SAS Programming

Working with dates

madhu — Mon, 14 Jul 2008 19:46:53 GMT

Hi guys,

I was working with some clinical data where I need calculate the age from date of birth variables and current date variable.But the date of birth variable is divided into three different variables as day, month and year.How do i do this.

Re: Working with dates

deleted_user — Mon, 14 Jul 2008 21:56:11 GMT

You can use MDY() function.

Re: Working with dates

SushilNayak — Tue, 15 Jul 2008 08:30:39 GMT

suppose the 3 birth date vairables are brtyr (birth year) brtmon( birth month) and btrdat (bith date).
Then just do
birth_dt=mdy(brtmon,btrdat ,brtyr);
age=int((today()-birth_dt)/365.25);

hope that helps.

Re: Working with dates

madhu — Tue, 15 Jul 2008 20:38:53 GMT

Thanks guys!!