https://communities.sas.com/t5/ODS-and-Base-Reporting/While-exporting-to-excel-the-following-error-message-is/m-p/5143#M2079 hi...<BR /> proc export data=sashelp.class (where=(sex='F'))<BR /> outfile='c:\Femalelist.xls'<BR /> dbms=excel <BR /> replace;<BR /> run;<BR /> <BR /> while running the above code i got this ERROR message<BR /> <BR /> ERROR: DBMS type EXCEL not valid for export.<BR /> <BR /> thanks... Mon, 22 Oct 2007 11:10:41 GMT deleted_user 2007-10-22T11:10:41Z https://communities.sas.com/t5/ODS-and-Base-Reporting/While-exporting-to-excel-the-following-error-message-is/m-p/5143#M2079 hi...<BR /> proc export data=sashelp.class (where=(sex='F'))<BR /> outfile='c:\Femalelist.xls'<BR /> dbms=excel <BR /> replace;<BR /> run;<BR /> <BR /> while running the above code i got this ERROR message<BR /> <BR /> ERROR: DBMS type EXCEL not valid for export.<BR /> <BR /> thanks... Mon, 22 Oct 2007 11:10:41 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/While-exporting-to-excel-the-following-error-message-is/m-p/5143#M2079 deleted_user 2007-10-22T11:10:41Z https://communities.sas.com/t5/ODS-and-Base-Reporting/While-exporting-to-excel-the-following-error-message-is/m-p/5144#M2080 Hi:<BR /> According to this Tech Support note:<BR /> <A href="http://support.sas.com/kb/6/976.html" target="_blank">http://support.sas.com/kb/6/976.html</A><BR /> <BR /> "The error will likely occur if SAS/ACCESS to PC File Formats is not licensed on the SAS Server."<BR /> <BR /> There is an example of creating a CSV file on the above site. It is also possible that your site has licensed SAS/Access to PC File Formats, but that it was not installed on your server or on the right server. You can check with your SAS administrative folks or with Tech Support for help debugging this.<BR /> <BR /> cynthia Mon, 22 Oct 2007 15:51:48 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/While-exporting-to-excel-the-following-error-message-is/m-p/5144#M2080 Cynthia_sas 2007-10-22T15:51:48Z