Hello,
I want to create a new value datetime derived from existing values. Existing values are formatted as follows: Date, date9. (24MAY2016) and Time, time8. (9:10:07)
Result I am looking get may be as follows: 24MAY2016:09:10:07. What is important is that I am able to compare this column datetime against itself, using < > functions.
I found the following code online, but it is giving me errors:
Data want;
attrib newdate format=datetime25.;
set have ;
newdate=input(put(date,date9.)||put(time,time8.),datetime.);run;
Here is the sas error message I receive: “Invalid argument to function INPUT at line 190 column 9.
Any help would be appreciated, thanks
You have a typo in the string, the | should read ||.
data want; attrib newdate format=datetime25.; date="01jan2016"d; time=input("9:10:07",time8.); newdate=input(catx("T",put(date,date9.),put(time,time8.)),datetime.); if datepart(newdate)=date then chk1=1; if timepart(newdate)=time then chk2=1; run;
The above code shows what you want.
You have a typo in the string, the | should read ||.
data want; attrib newdate format=datetime25.; date="01jan2016"d; time=input("9:10:07",time8.); newdate=input(catx("T",put(date,date9.),put(time,time8.)),datetime.); if datepart(newdate)=date then chk1=1; if timepart(newdate)=time then chk2=1; run;
The above code shows what you want.
The easiest way to get a datetime from a date and a time valued variable I believe to be:
datetime = dhms(date, 0,0,time);
hey Ballardw... thanks for this suggestion... very simple and works great!
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.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.