DATA Step, Macro, Functions and more

Suggestion. DATETIME function

Reply
Contributor
Posts: 25

Suggestion. DATETIME function

I have to match 2 data sets by id and date/time.  One data set has a single datetime var, the second data set has 6 vars: year, month, day, hour, minute, second.

My suggestion is for a single function to make a datetime var from the 6 components.

Call it either MDYHMS  or YMDHMS (or do both).  Similar to the MDY function where you provide the appropriate data.

I know I can use  x=DHMS(MDY(month, day, year), hour, minute, second); but my suggestion would be cleaner.

thanks.

Regular Contributor
Posts: 180

Re: Suggestion. DATETIME function

You should include this suggestion in the SASware Ballot Ideas.

Contributor
Posts: 25

Re: Suggestion. DATETIME function

Thanks. I thought of doing that but couldn't find the page to do that. Now I have.

Ask a Question
Discussion stats
  • 2 replies
  • 194 views
  • 0 likes
  • 2 in conversation