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
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: