BookmarkSubscribeRSS Feed
KevinC_
Fluorite | Level 6
Hello all,

Does anyone know what "=:" do in the following code?


data test_grid (keep = test_cell phone copy letter_type pcode);
set test_grid;
where mailing_cell_code =:'MO';

Thanks for any input!
4 REPLIES 4
Paige
Quartz | Level 8
It finds matches any text string that begins with the letters in quotes to the right of =:
KevinC_
Fluorite | Level 6
Thanks, Paige.

So in a way it works like INDEX? --- looking for certain text in a field?
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
The INDEX function scans the entire variable. The use of =: is similar to using SUBSTR(,1,) = '
Scott Barry
SBBWorks, Inc.
KevinC_
Fluorite | Level 6
Thank you, Scott!!

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

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
  • 4 replies
  • 30023 views
  • 4 likes
  • 3 in conversation