PROC EXPORT error "DBMS type EXCEL2000 not valid for export"
in [SAS]
|
From: Carol Bristow on 23 Mar 2007 11:17 Change your DBMS option - DBMS=EXCEL is what I've been using successfully since moving to Office 2003. HTH, Carol Bristow 1655 N Fort Myer Dr Ste 925 Arlington, VA 22209 ph: 703.682.2612 fax: 703.528.3100 -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L(a)LISTSERV.UGA.EDU] On Behalf Of JS Huang Sent: Friday, March 23, 2007 11:00 AM To: SAS-L(a)LISTSERV.UGA.EDU Subject: PROC EXPORT error "DBMS type EXCEL2000 not valid for export" Hi all: I tried to export a SAS dataset to EXCEL and got some error message: 1606 proc export 1607 data=BackDateInfo 1608 outfile="D:\BackDateInfo.XLS" 1609 DBMS=EXCEL2000 1610 replace; ERROR: DBMS type EXCEL2000 not valid for export. How do I fix it? I am using Excel Professional Edition 2003. Thanks!
From: "Gao, Yubo" on 23 Mar 2007 11:14 Try to change DBMS=EXCEL2000 To DBMS=EXCEL97 -----Original Message----- From: SAS(r) Discussion [mailto:] On Behalf Of JS Huang Sent: Friday, March 23, 2007 10:00 AM To: SAS-L(a)LISTSERV.UGA.EDU Subject: PROC EXPORT error "DBMS type EXCEL2000 not valid for export" Hi all: I tried to export a SAS dataset to EXCEL and got some error message: 1606 proc export 1607 data=BackDateInfo 1608 outfile="D:\BackDateInfo.XLS" 1609 DBMS=EXCEL2000 1610 replace; ERROR: DBMS type EXCEL2000 not valid for export. How do I fix it? I am using Excel Professional Edition 2003. Thanks!
From: "Huang, JS" on 23 Mar 2007 11:22 Carol: Thank you for your suggestion. I tried with the same error as a result. 1786 proc export 1787 data=BackDateInfo 1788 outfile="D:\BackDateInfo.XLS" 1789 DBMS=EXCEL 1790 replace; ERROR: DBMS type EXCEL not valid for export. -----Original Message----- From: Carol Bristow [mailto:Carol.Bristow(a)dpra.com] Sent: Friday, March 23, 2007 10:17 AM To: Huang, JS; SAS-L(a)LISTSERV.UGA.EDU Subject: RE: PROC EXPORT error "DBMS type EXCEL2000 not valid for export" Change your DBMS option - DBMS=EXCEL is what I've been using successfully since moving to Office 2003. HTH, Carol Bristow 1655 N Fort Myer Dr Ste 925 Arlington, VA 22209 ph: 703.682.2612 fax: 703.528.3100 -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L(a)LISTSERV.UGA.EDU] On Behalf Of JS Huang Sent: Friday, March 23, 2007 11:00 AM To: SAS-L(a)LISTSERV.UGA.EDU Subject: PROC EXPORT error "DBMS type EXCEL2000 not valid for export" Hi all: I tried to export a SAS dataset to EXCEL and got some error message: 1606 proc export 1607 data=BackDateInfo 1608 outfile="D:\BackDateInfo.XLS" 1609 DBMS=EXCEL2000 1610 replace; ERROR: DBMS type EXCEL2000 not valid for export. How do I fix it? I am using Excel Professional Edition 2003. Thanks! -----Message Disclaimer----- This e-mail message is intended only for the use of the individual or entity to which it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the intended recipient, any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by reply email to Connect(a)principal.com and delete or destroy all copies of the original message and attachments thereto. Email sent to or from the Principal Financial Group or any of its member companies may be retained as required by law or regulation. Nothing in this message is intended to constitute an Electronic signature for purposes of the Uniform Electronic Transactions Act (UETA) or the Electronic Signatures in Global and National Commerce Act ("E-Sign") unless a specific statement to the contrary is included in this message. While this communication may be used to promote or market a transaction or an idea that is discussed in the publication, it is intended to provide general information about the subject matter covered and is provided with the understanding that The Principal is not rendering legal, accounting, or tax advice. It is not a marketed opinion and may not be used to avoid penalties under the Internal Revenue Code. You should consult with appropriate counsel or other advisors on all matters pertaining to legal, tax, or accounting obligations and requirements.
From: "Huang, JS" on 23 Mar 2007 11:33 Tried with the same error as shown below: 1894 proc export 1895 data=BackDateInfo 1896 outfile="D:\BackDateInfo.XLS" 1897 DBMS=EXCEL97 1898 replace; ERROR: DBMS type EXCEL97 not valid for export. -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L(a)LISTSERV.UGA.EDU] On Behalf Of Gao, Yubo Sent: Friday, March 23, 2007 10:14 AM To: SAS-L(a)LISTSERV.UGA.EDU Subject: Re: PROC EXPORT error "DBMS type EXCEL2000 not valid for export" Try to change DBMS=EXCEL2000 To DBMS=EXCEL97 -----Original Message----- From: SAS(r) Discussion [mailto:] On Behalf Of JS Huang Sent: Friday, March 23, 2007 10:00 AM To: SAS-L(a)LISTSERV.UGA.EDU Subject: PROC EXPORT error "DBMS type EXCEL2000 not valid for export" Hi all: I tried to export a SAS dataset to EXCEL and got some error message: 1606 proc export 1607 data=BackDateInfo 1608 outfile="D:\BackDateInfo.XLS" 1609 DBMS=EXCEL2000 1610 replace; ERROR: DBMS type EXCEL2000 not valid for export. How do I fix it? I am using Excel Professional Edition 2003. Thanks! -----Message Disclaimer----- This e-mail message is intended only for the use of the individual or entity to which it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the intended recipient, any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by reply email to Connect(a)principal.com and delete or destroy all copies of the original message and attachments thereto. Email sent to or from the Principal Financial Group or any of its member companies may be retained as required by law or regulation. Nothing in this message is intended to constitute an Electronic signature for purposes of the Uniform Electronic Transactions Act (UETA) or the Electronic Signatures in Global and National Commerce Act ("E-Sign") unless a specific statement to the contrary is included in this message. While this communication may be used to promote or market a transaction or an idea that is discussed in the publication, it is intended to provide general information about the subject matter covered and is provided with the understanding that The Principal is not rendering legal, accounting, or tax advice. It is not a marketed opinion and may not be used to avoid penalties under the Internal Revenue Code. You should consult with appropriate counsel or other advisors on all matters pertaining to legal, tax, or accounting obligations and requirements.
From: "Huang, JS" on 23 Mar 2007 11:41
Carol: How do I proc export interactively to generate code? It's new to me. -----Original Message----- From: Carol Bristow [mailto:Carol.Bristow(a)dpra.com] Sent: Friday, March 23, 2007 10:38 AM To: Huang, JS; SAS-L(a)LISTSERV.UGA.EDU Subject: RE: Re: PROC EXPORT error "DBMS type EXCEL2000 not valid for export" Have you tried doing an export interactively from SAS, and saving the generated code? That will either give you code that works for you, or point out some other issue that may exist. Carol Bristow 1655 N Fort Myer Dr Ste 925 Arlington, VA 22209 ph: 703.682.2612 fax: 703.528.3100 -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L(a)LISTSERV.UGA.EDU] On Behalf Of Huang, JS Sent: Friday, March 23, 2007 11:33 AM To: SAS-L(a)LISTSERV.UGA.EDU Subject: Re: PROC EXPORT error "DBMS type EXCEL2000 not valid for export" Tried with the same error as shown below: 1894 proc export 1895 data=BackDateInfo 1896 outfile="D:\BackDateInfo.XLS" 1897 DBMS=EXCEL97 1898 replace; ERROR: DBMS type EXCEL97 not valid for export. -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L(a)LISTSERV.UGA.EDU] On Behalf Of Gao, Yubo Sent: Friday, March 23, 2007 10:14 AM To: SAS-L(a)LISTSERV.UGA.EDU Subject: Re: PROC EXPORT error "DBMS type EXCEL2000 not valid for export" Try to change DBMS=EXCEL2000 To DBMS=EXCEL97 -----Original Message----- From: SAS(r) Discussion [mailto:] On Behalf Of JS Huang Sent: Friday, March 23, 2007 10:00 AM To: SAS-L(a)LISTSERV.UGA.EDU Subject: PROC EXPORT error "DBMS type EXCEL2000 not valid for export" Hi all: I tried to export a SAS dataset to EXCEL and got some error message: 1606 proc export 1607 data=BackDateInfo 1608 outfile="D:\BackDateInfo.XLS" 1609 DBMS=EXCEL2000 1610 replace; ERROR: DBMS type EXCEL2000 not valid for export. How do I fix it? I am using Excel Professional Edition 2003. Thanks! -----Message Disclaimer----- This e-mail message is intended only for the use of the individual or entity to which it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the intended recipient, any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by reply email to Connect(a)principal.com and delete or destroy all copies of the original message and attachments thereto. Email sent to or from the Principal Financial Group or any of its member companies may be retained as required by law or regulation. Nothing in this message is intended to constitute an Electronic signature for purposes of the Uniform Electronic Transactions Act (UETA) or the Electronic Signatures in Global and National Commerce Act ("E-Sign") unless a specific statement to the contrary is included in this message. While this communication may be used to promote or market a transaction or an idea that is discussed in the publication, it is intended to provide general information about the subject matter covered and is provided with the understanding that The Principal is not rendering legal, accounting, or tax advice. It is not a marketed opinion and may not be used to avoid penalties under the Internal Revenue Code. You should consult with appropriate counsel or other advisors on all matters pertaining to legal, tax, or accounting obligations and requirements. -----Message Disclaimer----- This e-mail message is intended only for the use of the individual or entity to which it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the intended recipient, any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by reply email to Connect(a)principal.com and delete or destroy all copies of the original message and attachments thereto. Email sent to or from the Principal Financial Group or any of its member companies may be retained as required by law or regulation. Nothing in this message is intended to constitute an Electronic signature for purposes of the Uniform Electronic Transactions Act (UETA) or the Electronic Signatures in Global and National Commerce Act ("E-Sign") unless a specific statement to the contrary is included in this message. While this communication may be used to promote or market a transaction or an idea that is discussed in the publication, it is intended to provide general information about the subject matter covered and is provided with the understanding that The Principal is not rendering legal, accounting, or tax advice. It is not a marketed opinion and may not be used to avoid penalties under the Internal Revenue Code. You should consult with appropriate counsel or other advisors on all matters pertaining to legal, tax, or accounting obligations and requirements. |