We’re smarter together. Learn from this collection of community knowledge and add your expertise.

How do I create a SAS table from a Microsoft Excel file?

by Community Manager on ‎10-09-2015 05:02 PM (205 Views)

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.

Comments
by Super User
on ‎10-09-2015 06:19 PM

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.

Contributors
Your turn
Sign In!

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.