SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Combining single variable into a date and a time variable

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 8
Accepted Solution

Combining single variable into a date and a time variable

Hi,

 

I hava a dataset where i got three variaables for data, one for day, one for month and one for year. I want to combine these three into a single date variable. I have the same problem for time (one for seconds, one for minutes and one for hours) but assume that the solustion for the date issue is the same for creating a time variable.

 

Thanks for your help,

Per


Accepted Solutions
Solution
‎04-28-2017 07:40 AM
Super User
Super User
Posts: 7,039

Re: Combining single variable into a date and a time variable

Posted in reply to PerNielsen

If you already have numeric values you can use functions to convert.

date=mdy(month,day,year);
time=hms(hour,minute,second);
dt1=dhms(mdy(month,day,year),hour,minute,second);
dt2=dhms(date,0,0,time);
format date date9. time time8. dt1 dt2 datetime20.;

View solution in original post


All Replies
Solution
‎04-28-2017 07:40 AM
Super User
Super User
Posts: 7,039

Re: Combining single variable into a date and a time variable

Posted in reply to PerNielsen

If you already have numeric values you can use functions to convert.

date=mdy(month,day,year);
time=hms(hour,minute,second);
dt1=dhms(mdy(month,day,year),hour,minute,second);
dt2=dhms(date,0,0,time);
format date date9. time time8. dt1 dt2 datetime20.;
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 188 views
  • 2 likes
  • 2 in conversation