Hi VA experts,
Is there a way to insert a line break using concatenate operator in SAS VA? For example, I have a table that looks like this:
Issue Action1 Action2 Action3
I want to concatenate those last 3 columns into one column called 'Action'. The Action column should look like below:
Thanks for any help you can provide!
All calculations in the VA expression editor are evaluated at the row level (one row in, one row out) so it should not be possible to output multiple rows in the way you want.
Let us know if that helps,
If I understand correctly, the request is that the three values are in one table cell, but they will display with linebreaks when you add them to a List Table object? I think this is not possible, sorry.
Edit: Actually, it is not that simple. You can use the "\n" escape sequence to specify a newline character, but it appears that this is ignored most of the time. It does appear to be honored in data tips. This is not recommended, I am seeing some buggy behavior with this.
I am investigating this with the dev team.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.