BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
devi001
Obsidian | Level 7

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. 

devi001_1-1679905781584.png

 

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

 

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
LinusH
Tourmaline | Level 20

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

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

View solution in original post

7 REPLIES 7
LinusH
Tourmaline | Level 20

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

Data never sleeps
devi001
Obsidian | Level 7

In SAS dataset, new column

Kurt_Bremser
Super User

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
Obsidian | Level 7

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

PaigeMiller
Diamond | Level 26

No snippet attached.

--
Paige Miller
LinusH
Tourmaline | Level 20

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

scan(substr(a,findw(a, 'user', "'=")+4), 1, '=. ')
Data never sleeps
devi001
Obsidian | Level 7

Thank you! It worked well.

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

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
  • 7 replies
  • 1834 views
  • 0 likes
  • 4 in conversation