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
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.;
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.;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.