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;
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
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.
Ready to level-up your skills? Choose your own adventure.