Delete a line in a table containing a record with a line break.

[Abelp9]

Hi, I'm new to programming in SAS and it turns out that in a table I have two equal lines (as shown in the image), the problem is that one of those lines (the first), has a column (AN3) that contains a value with a line break, that is, the first record in AN3 has the value 20181 with the line break, and the second simply has 20181, without spaces or line breaks.

How can I delete only one of these lines? the one from 20181 with line break.

If I do a "delete * from table where AN3 = '20181'" I'm afraid it will delete the line, which is fine, but I don't know how to define the line break between the quotes.

Does anyone know how I could do this? thank you very much in advance, greetings

In excel the line break is not seen well but in SAP it is:

This is the line I want to delete:

And this is what the other line looks like:

Thank you very much in advance, greetings

[Ksharp · Accepted solution]

Try this:

delete from table where findc(AN3, '0D0A'x) ;

[Abelp9]

It works, thank you very much