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!!

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

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