BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
kelchenk
Calcite | Level 5

I am trying to use the loc function to subset a matrix but it is not working how I would like it to. I have a column of data that can contain up to 10 characters and I want to subset based on whether or not a set of 2 characters is within that string. Example: Entire variable contents could be "YAPTGR" and I want to keep that observation if that variable contains "PT." I have tried just doing loc(Variable = 'PT') but that only keeps the observation if 'PT' is the only contents of the variable. Is this possible using the loc function or do I need to use something else within IML? Thanks for the help!

1 ACCEPTED SOLUTION

Accepted Solutions
IanWakeling
Barite | Level 11

Try combining the INDEX and LOC functions like this:

  a = {'AAA','BPT','PTC','PDT'};

  b = a[ loc(index(a, 'PT')) ];

View solution in original post

1 REPLY 1
IanWakeling
Barite | Level 11

Try combining the INDEX and LOC functions like this:

  a = {'AAA','BPT','PTC','PDT'};

  b = a[ loc(index(a, 'PT')) ];

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

Multiple Linear Regression in SAS

Learn how to run multiple linear regression models with and without interactions, presented by SAS user Alex Chaplin.

Find more tutorials on the SAS Users YouTube channel.

From The DO Loop
Want more? Visit our blog for more articles like these.
Discussion stats
  • 1 reply
  • 763 views
  • 0 likes
  • 2 in conversation