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
;
The below solution by ballardw worked
data want; set have;
startdate = mdy(startmonth, startday,startyear);
format startdate date10.;
run;
The below solution by ballardw worked
data want; set have;
startdate = mdy(startmonth, startday,startyear);
format startdate date10.;
run;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.