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?
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.