topic Re: concatenate two time8. columns in SAS Programming

topic Re: concatenate two time8. columns in SAS Programming https://communities.sas.com/t5/SAS-Programming/concatenate-two-time8-columns/m-p/711081#M218980 <P> </P> <P><STRONG>length Expected_Result $50;</STRONG></P> <P><STRONG>Expected_Result=catx(' ',day,catx('-',Start_time,End_time));</STRONG></P> <P> </P> <P> </P> <P><STRONG>Notes: </STRONG>If you are time variables are numeric, please make sure you convert to char and then concatenate</P> <P>--> To convert to char, you would use PUT function </P> Wed, 13 Jan 2021 13:40:44 GMT novinosrin 2021-01-13T13:40:44Z concatenate two time8. columns https://communities.sas.com/t5/SAS-Programming/concatenate-two-time8-columns/m-p/711074#M218977 <P>Hello Everyone,</P><P> </P><P>Greetings!!</P><P> </P><P>My requirement is quite simple but i am struggling to get the expected output using SAS.</P><P> </P><TABLE><TBODY><TR><TD>Day</TD><TD>Start_time</TD><TD>End_time</TD></TR><TR><TD>Monday </TD><TD>8:00:00 AM</TD><TD>12:00:00 PM</TD></TR><TR><TD>Monday </TD><TD>1:00:00 AM</TD><TD>9:00:00 PM</TD></TR><TR><TD>Tuesday </TD><TD>8:00:00 AM</TD><TD>9:00:00 PM</TD></TR><TR><TD>Wednesday</TD><TD>8:00:00 AM</TD><TD>9:00:00 PM</TD></TR><TR><TD>Thursday </TD><TD>8:00:00 AM</TD><TD>9:00:00 PM</TD></TR><TR><TD>Friday </TD><TD>8:00:00 AM</TD><TD>9:00:00 PM</TD></TR><TR><TD>Saturday </TD><TD>8:00:00 AM</TD><TD>9:00:00 PM</TD></TR><TR><TD>Sunday </TD><TD>8:00:00 AM</TD><TD>9:00:00 PM</TD></TR></TBODY></TABLE><P> </P><P>Expected Result:</P><P> </P><TABLE><TBODY><TR><TD>Day</TD><TD>Start_time</TD><TD>End_time</TD><TD>Expected_Result</TD></TR><TR><TD>Monday </TD><TD>8:00:00 AM</TD><TD>12:00:00 PM</TD><TD>Monday   08:00 AM - 12:00 PM</TD></TR><TR><TD>Monday </TD><TD>1:00:00 AM</TD><TD>9:00:00 PM</TD><TD>Monday   01:00 PM - 09:00 PM</TD></TR><TR><TD>Tuesday </TD><TD>8:00:00 AM</TD><TD>9:00:00 PM</TD><TD>Tuesday  08:00 AM - 09:00 PM</TD></TR><TR><TD>Wednesday</TD><TD>8:00:00 AM</TD><TD>9:00:00 PM</TD><TD>Wednesday 08:00 AM - 09:00 PM</TD></TR><TR><TD>Thursday </TD><TD>8:00:00 AM</TD><TD>9:00:00 PM</TD><TD>Thursday  08:00 AM - 09:00 PM</TD></TR><TR><TD>Friday </TD><TD>8:00:00 AM</TD><TD>9:00:00 PM</TD><TD>Friday   08:00 AM - 09:00 PM</TD></TR><TR><TD>Saturday </TD><TD>8:00:00 AM</TD><TD>9:00:00 PM</TD><TD>Saturday  08:00 AM - 09:00 PM</TD></TR><TR><TD>Sunday </TD><TD>8:00:00 AM</TD><TD>9:00:00 PM</TD><TD>Sunday   08:00 AM - 09:00 PM</TD></TR></TBODY></TABLE> Wed, 13 Jan 2021 13:25:28 GMT https://communities.sas.com/t5/SAS-Programming/concatenate-two-time8-columns/m-p/711074#M218977 sarav93 2021-01-13T13:25:28Z Re: concatenate two time8. columns https://communities.sas.com/t5/SAS-Programming/concatenate-two-time8-columns/m-p/711081#M218980 <P> </P> <P><STRONG>length Expected_Result $50;</STRONG></P> <P><STRONG>Expected_Result=catx(' ',day,catx('-',Start_time,End_time));</STRONG></P> <P> </P> <P> </P> <P><STRONG>Notes: </STRONG>If you are time variables are numeric, please make sure you convert to char and then concatenate</P> <P>--> To convert to char, you would use PUT function </P> Wed, 13 Jan 2021 13:40:44 GMT https://communities.sas.com/t5/SAS-Programming/concatenate-two-time8-columns/m-p/711081#M218980 novinosrin 2021-01-13T13:40:44Z Re: concatenate two time8. columns https://communities.sas.com/t5/SAS-Programming/concatenate-two-time8-columns/m-p/711087#M218984 Thankyou :). its working fine now Wed, 13 Jan 2021 13:47:11 GMT https://communities.sas.com/t5/SAS-Programming/concatenate-two-time8-columns/m-p/711087#M218984 sarav93 2021-01-13T13:47:11Z