BookmarkSubscribeRSS Feed
AK100
Pyrite | Level 9

This is what I have:

AK100_0-1612961250835.png

I want to concatenate them all to 1 DATETIME format. How can that be done in a fast way?

 

 

 

7 REPLIES 7
PaigeMiller
Diamond | Level 26

You can use the MDY function to get a SAS date.


Then you can use the DHMS function to turn that date, plus hour minute second into a SAS datetime value.

--
Paige Miller
AK100
Pyrite | Level 9
Done that but got empty values back?
PaigeMiller
Diamond | Level 26

@AK100 wrote:
Done that but got empty values back?

Did what? Show us your code

--
Paige Miller
PeterClemmensen
Tourmaline | Level 20

See if you can use this as a template

 

data have;
input Year Month Day Hour Minute Second;
datalines;
2020 9 7 0 0 0
;

data want;
   set have;
   date = mdy(Month, Day, Year);
   datetime = dhms(date, Hour, Minute, Second);
   format date ddmmyy10. datetime datetime20.;
run; 

 

AK100
Pyrite | Level 9

Got This back, No DATALINES or INFILE statement.. Probably because I have this:

 

data work.merged_table;
input Year Month Day Hour Minute Second; 
;

data want;
   set work.merged_table;
   date = mdy(Month, Day, Year );
   datetime = dhms(date, Hour, Minute, Second);
   format date ddmmyy10. datetime datetime20.;
run; 

 

Kurt_Bremser
Super User

ALWAYS

supply example data in a data step with datalines, if you expect quick responses with a working suggestion.

A picture cannot be tested against, and we have NO IDEA AT ALL how your data really looks like.

Since the suggested code does work, the issue has to be your data.

PaigeMiller
Diamond | Level 26

@AK100 wrote:

Got This back, No DATALINES or INFILE statement.. Probably because I have this:


If you program work.merged_table as you did, it will be an empty data set. So, this is most likely the first problem you have.

--
Paige Miller

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 7 replies
  • 1368 views
  • 0 likes
  • 4 in conversation