Solved: concatenate two time8. columns - SAS Support Communities

🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.

Fluorite | Level 6

Fluorite | Level 6

concatenate two time8. columns

Posted 01-13-2021 08:25 AM (1107 views)

Hello Everyone,

Greetings!!

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

Day	Start_time	End_time
Monday	8:00:00 AM	12:00:00 PM
Monday	1:00:00 AM	9:00:00 PM
Tuesday	8:00:00 AM	9:00:00 PM
Wednesday	8:00:00 AM	9:00:00 PM
Thursday	8:00:00 AM	9:00:00 PM
Friday	8:00:00 AM	9:00:00 PM
Saturday	8:00:00 AM	9:00:00 PM
Sunday	8:00:00 AM	9:00:00 PM

Expected Result:

Day	Start_time	End_time	Expected_Result
Monday	8:00:00 AM	12:00:00 PM	Monday 08:00 AM - 12:00 PM
Monday	1:00:00 AM	9:00:00 PM	Monday 01:00 PM - 09:00 PM
Tuesday	8:00:00 AM	9:00:00 PM	Tuesday 08:00 AM - 09:00 PM
Wednesday	8:00:00 AM	9:00:00 PM	Wednesday 08:00 AM - 09:00 PM
Thursday	8:00:00 AM	9:00:00 PM	Thursday 08:00 AM - 09:00 PM
Friday	8:00:00 AM	9:00:00 PM	Friday 08:00 AM - 09:00 PM
Saturday	8:00:00 AM	9:00:00 PM	Saturday 08:00 AM - 09:00 PM
Sunday	8:00:00 AM	9:00:00 PM	Sunday 08:00 AM - 09:00 PM

1 ACCEPTED SOLUTION

Accepted Solutions

Tourmaline | Level 20

Tourmaline | Level 20

Re: concatenate two time8. columns

Posted 01-13-2021 08:35 AM (1093 views) | In reply to sarav93

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

View solution in original post

2 REPLIES 2

Tourmaline | Level 20

Tourmaline | Level 20

Re: concatenate two time8. columns

Posted 01-13-2021 08:35 AM (1094 views) | In reply to sarav93

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

Fluorite | Level 6

Fluorite | Level 6

Re: concatenate two time8. columns

Posted 01-13-2021 08:47 AM (1068 views) | In reply to novinosrin

Thankyou :). its working fine now

April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Call for Content EXTENDED

Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.

Submit your proposal!