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

Can anyone suggest or know a function which could search a word or a string from a data.

for eg: Kirito is interested in SAS And SAS is Amazing. SAS uses proc sql. I am a new user of SAS. SAS made analysis of data easier. 

Now I want to know how many times SAS occurred in the paragraph above.

What function should I use?

Thank in advance for all the contributors.

1 ACCEPTED SOLUTION

Accepted Solutions
Kurt_Bremser
Super User

I have a nice exercise for you:

Go here Dictionary of Functions and CALL Routines 

Then look for functions the name of which indicates that they are for COUNTing. You will find what you're looking for.

 

This exercise will enhance your documentation-fu.

View solution in original post

1 REPLY 1
Kurt_Bremser
Super User

I have a nice exercise for you:

Go here Dictionary of Functions and CALL Routines 

Then look for functions the name of which indicates that they are for COUNTing. You will find what you're looking for.

 

This exercise will enhance your documentation-fu.

sas-innovate-2026-white.png



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!

Register now

Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 631 views
  • 0 likes
  • 2 in conversation