BookmarkSubscribeRSS Feed
ZRick
Obsidian | Level 7

Most of time, I use "|" as concatenation symbol to do the operation, like: "sys"||_N_.

I also saw some cases that use "!" to do the concatenation.

Can someone tell me when I need to do the concatenation using "!"?

4 REPLIES 4
PGStats
Opal | Level 21

Both symbols can be used interchangeably.

PG

PG
Jay_TxOAG
Quartz | Level 8

|| won't work on z/OS (at least it didn't work in my TSO session)...but !! (double exclamation points) will. I believe both Windows and UNIX will accept ||

Of course the CAT series of functions (CAT CATS CATT CATX) will work anywhere (http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a002257060.htm)

ballardw
Super User

When to use !! instead of || : When your keyboard or OS doesn't support ||. This goes back to much older keyboards with many fewer keys, including when EVERYTHING WAS ALL CAPS.

Ksharp
Super User

It seems that it is difference between EDBIC and ASCII .

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 1566 views
  • 0 likes
  • 5 in conversation