topic Re: Create a Date variable from day, month and year variable. in SAS Enterprise Guide

Create a Date variable from day, month and year variable.

Sharan — Tue, 05 Apr 2022 12:40:28 GMT

Hi there!

I have 3 variables: a month column and a year column and a day column. The day column with have the value 15 referring to mid-month and will be constant. Now using the 3 fields, I would like to create a Date column in Date9. Format. How do I do this?

Sample Data

Obs	Month	Year	Day
1	5	2008	15
2	8	2009	15
3	4	2010	15
4	9	2005	15

New Data

Obs	Month	Year	Day	New_Date
1	5	2008	15	15May2008
2	8	2009	15	15Oct2009
3	4	2010	15	15Apr2010
4	9	2005	15	15Sep2005

Re: Create a Date variable from day, month and year variable.

PaigeMiller — Tue, 05 Apr 2022 12:42:24 GMT

data want;
    set have;
    new_date=mdy(month,day,year);
    format new_date date9.;
run;

Re: Create a Date variable from day, month and year variable.

Sharan — Tue, 05 Apr 2022 12:58:56 GMT

Hi Paige Miller, Brilliant!
Thank you for the swift response to my question and yes it worked. Hugely appreciate the support!