DATA Step, Macro, Functions and more

What is "!", how is it different from "|" concatenation sign?

Reply
Frequent Contributor
Posts: 133

What is "!", how is it different from "|" concatenation sign?

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 "!"?

Respected Advisor
Posts: 4,919

Re: What is "!", how is it different from "|" concatenation sign?

Both symbols can be used interchangeably.

PG

PG
Contributor
Posts: 45

Re: What is "!", how is it different from "|" concatenation sign?

|| 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)

Super User
Posts: 11,343

Re: What is "!", how is it different from "|" concatenation sign?

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.

Super User
Posts: 10,018

Re: What is "!", how is it different from "|" concatenation sign?

It seems that it is difference between EDBIC and ASCII .

Ask a Question
Discussion stats
  • 4 replies
  • 229 views
  • 0 likes
  • 5 in conversation