Scan function if the string contains numerics also - SAS Support Communities

Obsidian | Level 7

Obsidian | Level 7

Scan function if the string contains numerics also

Posted 03-16-2021 05:51 AM (772 views)

Some of the words in my string contain numbers as well as letters, for example '24th Dobson street'.
If I am applying Scan function to this string then it gives the error
<Syntax error, expecting one of the following..> .
Is there any way to tackle this?

2 REPLIES 2

Tourmaline | Level 20

Tourmaline | Level 20

Re: Scan function if the string contains numerics also

Posted 03-16-2021 06:08 AM (762 views) | In reply to Shradha1

Show us your code please.

The DATA to DATA Step Macro
Blog: SASnrd

Super User

Super User

Re: Scan function if the string contains numerics also

Posted 03-16-2021 06:37 AM (749 views) | In reply to Shradha1

Please copy/paste the whole log of the failing step into a window opened with this button:

Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
The macro for direct download as ZIP
How to post code
Please vote for Provide Sequential Search Capability for Hash Objects
How to deal with locked files on UNIX

April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Call for Content EXTENDED

Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.

Submit your proposal!