topic Re: How to capture "&" from libname statement in SAS Programming

How to capture "&" from libname statement

devi001 — Mon, 27 Mar 2023 08:35:29 GMT

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!

Re: How to capture "&" from libname statement

LinusH — Mon, 27 Mar 2023 08:40:11 GMT

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

Re: How to capture "&" from libname statement

devi001 — Mon, 27 Mar 2023 08:43:36 GMT

In SAS dataset, new column

Re: How to capture "&" from libname statement

Kurt_Bremser — Mon, 27 Mar 2023 08:54:25 GMT

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.

Re: How to capture "&" from libname statement

devi001 — Mon, 27 Mar 2023 09:36:00 GMT

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

Re: How to capture "&" from libname statement

PaigeMiller — Mon, 27 Mar 2023 09:46:51 GMT

No snippet attached.

Re: How to capture "&" from libname statement

LinusH — Mon, 27 Mar 2023 10:00:41 GMT

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

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

Re: How to capture "&" from libname statement

devi001 — Mon, 27 Mar 2023 10:46:13 GMT

Thank you! It worked well.