BookmarkSubscribeRSS Feed
deleted_user
Not applicable
I have a DATETIME variable that looks like 15NOV2007:09:08:00. I want to separate the Date and Time into separate variables. How do I do this while keeping the formatting. Thanks.
2 REPLIES 2
Doc_Duke
Rhodochrosite | Level 12
Use the DATEPART and TIMEPART functions to extract the pertinent pieces and then apply the appropriate formats to the resulting variables.
deleted_user
Not applicable
Thanks. I found the function about an hour after I posted.

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

New Learning Events in April

 

Join us for two new fee-based courses: Administrative Healthcare Data and SAS via Live Web Monday-Thursday, April 24-27 from 1:00 to 4:30 PM ET each day. And Administrative Healthcare Data and SAS: Hands-On Programming Workshop via Live Web on Friday, April 28 from 9:00 AM to 5:00 PM ET.

LEARN MORE

Discussion stats
  • 2 replies
  • 1147 views
  • 0 likes
  • 2 in conversation