Or maybe he/she is on Unix, which to my understand, does not support excel format.

On Fri, 1 Sep 2006 13:57:22 -0400, Dianne Rhodes <diannerhodes@COMCAST.NET> wrote:

>On Fri, 1 Sep 2006 10:16:15 -0700, svs <seema.var@GMAIL.COM> wrote: > >>Hi, >>The following syntax does not work, I have version 9.1.3: Any idea >>why? >> >>proc export data=svs.testfile >> outfile='C:\Test' >> dbms=Excel >> replace; >>run; >> >>ERROR: DBMS type Excel not valid for Export >> >>If I replace dbms=Excel to dmbs = CSV then it works... >> >>I am also looking for some program written to export datasets out into >>excel with custom formatting, the Help menu is not all that >>helpful...any suggestions for resources on the web? Thanks, Seema. > >Probably you don't have Access to PC file formats licensed. Run proc >setinit. If you see that you do have the license, bug your SAS >administrator to install it for you. Or just use the CSV files. > >Dianne Rhodes @ bls