topic Re: Suggestion. DATETIME function in SAS Programming https://communities.sas.com/t5/SAS-Programming/Suggestion-DATETIME-function/m-p/147963#M29313 <HTML><HEAD></HEAD><BODY><P>Thanks. I thought of doing that but couldn't find the page to do that. Now I have.</P></BODY></HTML> Thu, 30 Oct 2014 17:40:27 GMT rickpaulos 2014-10-30T17:40:27Z Suggestion. DATETIME function https://communities.sas.com/t5/SAS-Programming/Suggestion-DATETIME-function/m-p/147961#M29311 <HTML><HEAD></HEAD><BODY><P>I have to match 2 data sets by id and date/time.&nbsp; One data set has a single datetime var, the second data set has 6 vars: year, month, day, hour, minute, second.</P><P></P><P>My suggestion is for a single function to make a datetime var from the 6 components. </P><P></P><P>Call it either MDYHMS&nbsp; or YMDHMS (or do both).&nbsp; Similar to the MDY function where you provide the appropriate data.</P><P></P><P>I know I can use&nbsp; x=DHMS(MDY(month, day, year), hour, minute, second); but my suggestion would be cleaner.</P><P></P><P>thanks.</P></BODY></HTML> Wed, 29 Oct 2014 19:01:52 GMT https://communities.sas.com/t5/SAS-Programming/Suggestion-DATETIME-function/m-p/147961#M29311 rickpaulos 2014-10-29T19:01:52Z Re: Suggestion. DATETIME function https://communities.sas.com/t5/SAS-Programming/Suggestion-DATETIME-function/m-p/147962#M29312 <HTML><HEAD></HEAD><BODY><P>You should include this suggestion in the SASware Ballot Ideas.</P></BODY></HTML> Thu, 30 Oct 2014 17:25:18 GMT https://communities.sas.com/t5/SAS-Programming/Suggestion-DATETIME-function/m-p/147962#M29312 CTorres 2014-10-30T17:25:18Z Re: Suggestion. DATETIME function https://communities.sas.com/t5/SAS-Programming/Suggestion-DATETIME-function/m-p/147963#M29313 <HTML><HEAD></HEAD><BODY><P>Thanks. I thought of doing that but couldn't find the page to do that. Now I have.</P></BODY></HTML> Thu, 30 Oct 2014 17:40:27 GMT https://communities.sas.com/t5/SAS-Programming/Suggestion-DATETIME-function/m-p/147963#M29313 rickpaulos 2014-10-30T17:40:27Z