Solved: Re: concatenate two time8. columns

sarav93 · Posted 01-13-2021 08:25 AM

Hello Everyone,

Greetings!!

My requirement is quite simple but i am struggling to get the expected output using SAS.

Expected Result:

novinosrin · Posted 01-13-2021 08:35 AM

length Expected_Result $50;

Expected_Result=catx(' ',day,catx('-',Start_time,End_time));

Notes: If you are time variables are numeric, please make sure you convert to char and then concatenate

--> To convert to char, you would use PUT function

novinosrin · Posted 01-13-2021 08:35 AM

length Expected_Result $50;

Expected_Result=catx(' ',day,catx('-',Start_time,End_time));

Notes: If you are time variables are numeric, please make sure you convert to char and then concatenate

--> To convert to char, you would use PUT function

sarav93 · Posted 01-13-2021 08:47 AM

Thankyou :). its working fine now

concatenate two time8. columns