While exporting to excel the following error message is appearing...

[deleted_user]

hi...
proc export data=sashelp.class (where=(sex='F'))
outfile='c:\Femalelist.xls'
dbms=excel
replace;
run;

while running the above code i got this ERROR message

ERROR: DBMS type EXCEL not valid for export.

thanks...

[Cynthia_sas]

Hi:
According to this Tech Support note:
http://support.sas.com/kb/6/976.html

"The error will likely occur if SAS/ACCESS to PC File Formats is not licensed on the SAS Server."

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.

cynthia