Error creating updating the odbc dsn

It's an antiquated approach, but offers tremendous control that many long-time SAS users enjoy.

While I've focused on the SAS programming methods for creating Excel files, applications like SAS Enterprise Guide and the SAS Add-In for Microsoft Office make the operation a breeze.

I am interested in finding data to analyze, and if it arrives in the form of a spreadsheet, I'll take it.To make this work you don't have to set up any additional software, but your SAS programs must change to use DBMS=EXCELCS.The EXCELCS keyword tells SAS to use the PC Files Server instead of attempting to use in-process data providers.Good for UNIX and for Windows configurations where bitness of SAS and Microsoft Office don't match.PROC EXPORT DBMS=EXCELCS – uses PC Files Server to write an Excel file.

Leave a Reply