## Combining single variable into a date and a time variable

Solved
Occasional Contributor
Posts: 12

# 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.

Per

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

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

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.;``````

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

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

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.