Desktop productivity for business analysts and programmers

String Concatenate or Time addition?

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 17
Accepted Solution

String Concatenate or Time addition?

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.

 

 

 

 

 


Accepted Solutions
Solution
‎05-16-2017 03:40 PM
Esteemed Advisor
Posts: 7,301

Re: String Concatenate or Time addition?

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

 

View solution in original post


All Replies
Super Contributor
Posts: 284

Re: String Concatenate or Time addition?

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

Solution
‎05-16-2017 03:40 PM
Esteemed Advisor
Posts: 7,301

Re: String Concatenate or Time addition?

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

 

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 110 views
  • 0 likes
  • 3 in conversation