https://communities.sas.com/t5/SAS-Procedures/How-to-combine-three-columns-to-one-date-variable/m-p/20854#M4352 Hi,<BR /> <BR /> In my data I have three variables - year, month and day that I want to combine into one date variable with the format ddmmyy8.<BR /> <BR /> How can I do that?<BR /> <BR /> Thanks - Bodil Fri, 22 Oct 2010 05:40:28 GMT Boni 2010-10-22T05:40:28Z https://communities.sas.com/t5/SAS-Procedures/How-to-combine-three-columns-to-one-date-variable/m-p/20854#M4352 Hi,<BR /> <BR /> In my data I have three variables - year, month and day that I want to combine into one date variable with the format ddmmyy8.<BR /> <BR /> How can I do that?<BR /> <BR /> Thanks - Bodil Fri, 22 Oct 2010 05:40:28 GMT https://communities.sas.com/t5/SAS-Procedures/How-to-combine-three-columns-to-one-date-variable/m-p/20854#M4352 Boni 2010-10-22T05:40:28Z https://communities.sas.com/t5/SAS-Procedures/How-to-combine-three-columns-to-one-date-variable/m-p/20855#M4353 use mdy function.<BR /> <BR /> data test;<BR /> input month day year;<BR /> format new ddmmyy8.;<BR /> new=mdy(month,day,year);<BR /> datalines;<BR /> 10 22 2010<BR /> 10 23 2010<BR /> 10 24 2010<BR /> ;<BR /> run; Fri, 22 Oct 2010 07:00:12 GMT https://communities.sas.com/t5/SAS-Procedures/How-to-combine-three-columns-to-one-date-variable/m-p/20855#M4353 piggy 2010-10-22T07:00:12Z https://communities.sas.com/t5/SAS-Procedures/How-to-combine-three-columns-to-one-date-variable/m-p/20856#M4354 I knew that a very easy solution was there somewhere... Thanks! Fri, 22 Oct 2010 10:14:49 GMT https://communities.sas.com/t5/SAS-Procedures/How-to-combine-three-columns-to-one-date-variable/m-p/20856#M4354 Boni 2010-10-22T10:14:49Z