When multiple worksheets need to be imported, it adds more complexity to the already painful job. One of the tedious things SAS programmers have to do is to specify the different sheet names by hard coding, so that the sheet names are visible to the SAS system. Unfortunately, in most of the multi-sheet situations, the number of worksheets and sheet names happen to be different. And, sometimes the sheet names are too messy to be usable (e.g. sheet names containing quotation marks). This paper provides a real-world, multi-book, multi-sheet importation situation, in which the new Excel libname engine in SAS Version 9 helped retrieve Excel work sheet names and made the complex work become a smooth ride.
Did you find this white paper useful?
23 out of 50 users found this white paper useful
Related white papers
Ovum Report: IBM Simplfies Service Management to facilitate business and IT
All too often, companies find their IT infrastructure is fragmented and confused. Different parts of the business have different silos of data and applications, with no integrated vision joining them...
Discover IT Case Study: Bywater Ltd
Bywater is an international consulting company founded in the UK about 20 years ago. Bywater provides consulting services on developing e-commerce strategy. As such, they needed to have a new...
SharePoint Migration Whiteboard Video
It's costly to manage and maintain multiple data platforms. By consolidating your data on one system, you'll save time and money - as well as reduce your headaches! In this informative...
TechNet Webcast: How Microsoft IT Handles Master Data Management (Level 300)
The attendee of this webcast learn how Microsoft IT is developing a system-of-record for key customer information, but also as a metadirectory, holding references to customer data in other business...
Driving Efficiency Through a Robust Content Management Solution
The Federal Trade Commission (FTC) works to ensure that the nation's markets are vigorous, efficient, and free of restrictions that harm consumers. The FTC needed to completely replace the agency's...
Streamlining the Creation, Management, and Delivery of Content
State Super Financial Services (SSFS) is one of Australia's leading financial planning organisations with more than $3.4 billion in funds under advice. SSFS needed to find a knowledge management solution...
eRoom Solution Brings Together Global Workforce at BIC
The BIC Group is a leading manufacturer of stationery products, lighters, and shavers, with more than 9,000 employees worldwide. The BIC team recognized the Web's potential as a unifying environment...
