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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.