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

Abelp9 — Thu, 04 Aug 2022 12:02:06 GMT

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

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

Ksharp — Thu, 04 Aug 2022 12:15:23 GMT

Try this:

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

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

Abelp9 — Thu, 04 Aug 2022 12:21:15 GMT

It works, thank you very much

topic Re: Delete a line in a table containing a record with a line break. in SAS Programming

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

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

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