topic Re: Dropping observations with suffix "_A" in SAS Programming

Dropping observations with suffix "_A"

sandrube — Fri, 10 Jun 2022 16:03:58 GMT

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 — Fri, 10 Jun 2022 16:34:17 GMT

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 — Fri, 10 Jun 2022 16:35:18 GMT

Thank you very much and have a great weekend!

Rube