Former Analytics U Community Manager Jennifer Scott gives you the 411 in this brief article. How’s that working for you? Let us know in the comments.
Since I generally do not have access to the PC Files to read Excel with Proc Import and seldom can trust my data suppliers to provide clean data, I save Excel to CSV where I have all the tools of the data step to read the data.
Want to write an article? Sign in with your profile.
Looking for the Ask the Expert series? Find it in its new home: communities.sas.com/askexpert.