Dropping observations with suffix "_A"

[sandrube]

Hello friends,

I am trying to drop observations ending in "_A" of the variable, "category". I used the following code and didn't work. Could you please help?

If substr(category, - 1, 2)="_0" then delete;

Thank you and all have a wonderful weekend!

Rube

[Tom · Accepted solution]

You cannot use negative numbers with SUBSTR().

if substrn(category,length(category)-1) = '_A' then delete;

You can use negative numbers with SCAN().

if scan(category,-1,'_') = 'A' then delete;

Do you ever have values that are just 'A' without any underscore?

Do you ever have values with lowercase a as the suffix?

if index(category,'_') and upcase(scan(category,-1,'_')) = 'A' then delete;

[sandrube]

Thank you very much and have a great weekend!

Rube