SAS is powerful for delivering statistical information, and Microsoft Office is excellent for formatting. This paper details how to link the two systems together and how to automate this process using DDE and VBA so that non-programmers can easily generate the custom tables. With the help of DDE and VBA, professional-looking tables can be easily created. The process described in this paper shows how to link SAS and Excel together and how to automate the whole process.
Did you find this white paper useful?
24 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...
Massively Scalable NAS - Pre-Empting Tomorrow's Data Overload with Today's Technology
HP is launching the HP StorageWorks 9100 Extreme Data Storage System that solves challenges such as extreme scability, manageability and affordability and creates new business opportunities. HP is going to...
Fourth Generation Intranets
Fourth Generation Intranets will be dynamic new business tools, inspired by social networking, that employees will want to use daily.They are being heralded as intelligent intranets. This new league of...
Reduce the Risk of Costly Data Breaches: Three Pillars of Data Protection
There are numerous regulations that govern the protection of private, personal and confidential data regardless of whether the data resides on a secure mainframe computer, desktop PC or mobile device...
TechRepublic Resource Guide: Archiving and Storing E-mail
Download this TechRepublic Resource Guide for important information on starting, implementing, and maintaining an e-mail archive and storage policy in your organization. This guide includes these three articles that can...
Service-oriented architecture
If you're struggling to build a business case for service-oriented architecture (SOA), this IBM white paper can help. It proposes a simplified approach to analyzing the ROI of SOA --...
Help Maximize Customer Base and Revenue: Optimize the Efficiency and Cost of Account Opening Processes
Driven by customer expectations and competitive pressures from market leaders, banks are reassessing their delivery and customer management strategies. By eliminating inefficiencies, they are able to reduce costs and attract...
