Combining single variable into a date and a time variable

PerNielsen — Fri, 28 Apr 2017 11:05:21 GMT

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

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

Tom — Fri, 28 Apr 2017 11:10:43 GMT

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

topic Combining single variable into a date and a time variable in SAS Data Management

Combining single variable into a date and a time variable

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