Combine numbers in three columns to create a date column.

[Barkat]

I have a data set that has three columns (one column mentions day of a month, 2nd column mentions month, and the 3rd column mentions year). I would like to combine the data in those three columns to create a date column.

data have;
input ID $   StartMonth   StartDay   StartYear   ;
cards;
001 10 9 2022
002 4 3 2022
003 2 7 2022
004 7 17 2022
005 10 24 2022
006 11 14 2022
;

[Barkat · Accepted solution]

The below solution by ballardw worked

data want; set have;
   startdate = mdy(startmonth, startday,startyear);
   format startdate date10.;
run;