Hi All,
I am very new to SAS and try to learn the syntax. Sorry for my very basic question. I have below syntax and I think it's time addition but not certain.
((input(compress(substr(add_datetime,1,10),'-'),yymmdd8.))*86400)
+
(input(substr(add_datetime,12,8),TIME8.)) as add_datetime,
If I understand it correctly, it takes 10 characters from first position on the left of add_datetime, remove the dashes with compress function, convert to yymmdd8 format, convert to numeric/number of days with input function, then convert to seconds.
Plus/Concatenate
Second syntax is similar to above but extract time from add_datetime, convert to time8 format.
This is time addition syntax, correct?
Thank you for your answer.
Your logic is indeed correct, but whether it will produce what you want will be dependent upon how the date variable was actually entered. Here's an example using your code and a slightly different date format based on today's datetime:
data test; format want datetime21.; add_datetime=catt(put(today(),mmddyyd10.),':',put(time(),time8.)); want=((input(compress(substr(add_datetime,1,10),'-'),mmddyy8.))*86400) + (input(substr(add_datetime,12,8),TIME8.)); run;
Art, CEO, AnalystFinder.com
My guess is you're making this way too complicated. Can you give an example of what add_datetime looks like?
Your logic is indeed correct, but whether it will produce what you want will be dependent upon how the date variable was actually entered. Here's an example using your code and a slightly different date format based on today's datetime:
data test; format want datetime21.; add_datetime=catt(put(today(),mmddyyd10.),':',put(time(),time8.)); want=((input(compress(substr(add_datetime,1,10),'-'),mmddyy8.))*86400) + (input(substr(add_datetime,12,8),TIME8.)); run;
Art, CEO, AnalystFinder.com
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!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.