Blogs

Save Money: Use XML instead of Access to PC File Fmts

By Angela Hall on SAS Learning Post December 4, 2005

Wanna save your organization a quick buck? Drop SAS Access to PC File Formats if your only using to export in batch mode!

Attended a local SAS Users Group Meeting at the SAS Campus a few weeks ago and heard Vince DelGobbo speak on using the MSOffice2K tagset to move data from SAS to Microsoft Excel without using Proc Export with CSV or the Access to PC File Format for an XLS outcome.

The SUGI 30 PAPER covers the basics (simply replace the SAS Proc Export code with ods statements).

About Author

Angela Hall
Senior Technical Architect

Angela offers tips on using the SAS Business Intelligence solutions. She manages a team of SAS Fraud Framework implementers within the SAS Solutions On-Demand organization. Angela also has co-written two books, 'Building BI using SAS, Content Development Examples' & 'The 50 Keys to Learning SAS Stored Processes'.

Comments are closed.