Help using Base SAS procedures

What does =: do?

Reply
Regular Contributor
Posts: 173

What does =: do?

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!
Super Contributor
Posts: 281

Re: What does =: do?

It finds matches any text string that begins with the letters in quotes to the right of =:
Regular Contributor
Posts: 173

Re: What does =: do?

Thanks, Paige.

So in a way it works like INDEX? --- looking for certain text in a field?
Super Contributor
Super Contributor
Posts: 3,174

Re: What does =: do?

The INDEX function scans the entire variable. The use of =: is similar to using SUBSTR(,1,) = '
Scott Barry
SBBWorks, Inc.
Regular Contributor
Posts: 173

Re: What does =: do?

Thank you, Scott!!
Ask a Question
Discussion stats
  • 4 replies
  • 166 views
  • 0 likes
  • 3 in conversation