BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
Barkat
Pyrite | Level 9

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
;
1 ACCEPTED SOLUTION

Accepted Solutions
Barkat
Pyrite | Level 9

The below solution by ballardw worked

 

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

View solution in original post

1 REPLY 1
Barkat
Pyrite | Level 9

The below solution by ballardw worked

 

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

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 440 views
  • 1 like
  • 1 in conversation