topic String Concatenate or Time addition? in SAS Enterprise Guide

String Concatenate or Time addition?

Mixer — Thu, 13 Apr 2017 21:50:51 GMT

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.

Re: String Concatenate or Time addition?

collinelliot — Thu, 13 Apr 2017 22:06:06 GMT

My guess is you're making this way too complicated. Can you give an example of what add_datetime looks like?

Re: String Concatenate or Time addition?

art297 — Thu, 13 Apr 2017 22:16:55 GMT

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