Okay, so your title says you want 1 Excel file, but your text says you want one Excel column. Can you clarify?
Also B3 has a no value for last cell, so how to account for that?
That's very much up to you, how do you want to account for that?
Sorry, but I'm still not clear on what you mean.
I want to import it to SAS and then make the three columns merge into one, but also delete the blank value
You want to import it into SAS? Where is the data now? Text file? Excel file? SAS data set? Database? Other?
Why not import it into Excel and then re-arrange there? Why is SAS even necessary in this problem?
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!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.