topic Re: delete line when 1 variable contains some specific signs in New SAS User

delete line when 1 variable contains some specific signs

PierreYvesILY — Wed, 31 Jul 2019 10:07:15 GMT

hello,

I would like to delete the lines of a table, when the VAriable contains some specific chains of characters.

if NIEDERLASSUNGBEZ_BT contains ('GRM', 'CoC', 'NL MS') then delete;

how can I correct this?

thanks in advance

Kurt_Bremser — Wed, 31 Jul 2019 10:35:27 GMT

Use the index() function:

if
  index(NIEDERLASSUNGBEZ_BT,'GRM') or
  index(NIEDERLASSUNGBEZ_BT,'CoC') or
  index(NIEDERLASSUNGBEZ_BT,'NL MS')
then delete;

or simplifiy this to a subsetting if:

if not (
  index(NIEDERLASSUNGBEZ_BT,'GRM') or
  index(NIEDERLASSUNGBEZ_BT,'CoC') or
  index(NIEDERLASSUNGBEZ_BT,'NL MS')
);

PierreYvesILY — Wed, 31 Jul 2019 10:37:40 GMT

thank you very much and have a nice day.