As the first step in the decommissioning of sasCommunity.org the site has been converted to read-only mode.


Here are some tips for How to share your SAS knowledge with your professional network.


So, Your Data are in Excel!

From sasCommunity
Jump to: navigation, search
So, Your Data are in Excel!

Ed Heaton

Data and Analytic Solutions

ABSTRACT

You say your customer sent you the data in an Excel workbook. Well then, I guess you'll have to work with it. This paper will discuss some of the quirks you will find when your data are stored in an Excel workbook. It will cover such things as

• naming conventions,

• character length issues,

• numeric precision,

• date, time, and datetime values,

• mixed data types, and

• caching.

This paper will demonstrate - through the Display Manager - SAS code and techniques to make your life with Excel more predictable and your work less prone to error. We will use the excel engine that is available in SAS 9.1.3 when you license SAS/ACCESS for PC Files.

Click here to see the entire article.