The SAS Output Delivery System and reporting techniques

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

Reply
N/A
Posts: 0

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

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...
SAS Super FREQ
Posts: 8,863

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

Posted in reply to deleted_user
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
Ask a Question
Discussion stats
  • 1 reply
  • 135 views
  • 0 likes
  • 2 in conversation