How to capture "&&" from libname statement

[devi001]

Hello everyone,

We want to capture symbol "&" from libname statement form user information along with username. As of now whole username is coming properly, but symbol & is not coming. We have used SAS character functions such as substr, find & scan to capture this. 

Please look into below snippet for more clarity. 

Please help to capture "&" from user= from libname statement.

Thanks!

[LinusH]

What is the context - where, when and how do you wish to capture this?

[devi001]

In SAS dataset, new column

[Kurt_Bremser]

Please post data as text, not in pictures. We can't copy pictures into the program editor window, but text works perfectly fine 😉

If you already have a dataset containing this information, please post it in a data step with datalines.

[devi001]

Apologies. Please find attached snippet of sample dataset. Requirement is in user column "&" should also come. 

[PaigeMiller]

No snippet attached.

[LinusH · Accepted solution]

Don't know if this is bullet proof, and there may be more elegant solutions:

scan(substr(a,findw(a, 'user', "'=")+4), 1, '=. ')

[devi001]

Thank you! It worked well.