Combine numbers in three columns to create a date column.

Barkat — Mon, 21 Aug 2023 20:58:41 GMT

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
;

Re: Combine numbers in three columns to create a date column.

Barkat — Mon, 21 Aug 2023 20:54:21 GMT

The below solution by ballardw worked

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

topic Combine numbers in three columns to create a date column. in SAS Programming

Combine numbers in three columns to create a date column.

Re: Combine numbers in three columns to create a date column.