PROC EXPORT error "DBMS type EXCEL2000 not valid for export"
in [SAS]
|
From: Carol Bristow on 23 Mar 2007 11:46 On the File menu in SAS, choose Export Data. A wizard will start, and walk you through choosing your SAS dataset to export, the format that you want to export it to, the usual file naming dialog, and a few other options that may be applicable to the particular output option you choose. Before the wizard finishes, and SAS actually executes the export, you will be asked if you want to save the proc export statements, and you specify the filename/location for the code. If the export works interactively, then the code that was saved in that file will work again within a program. Carol Bristow 1655 N Fort Myer Dr Ste 925 Arlington, VA 22209 ph: 703.682.2612 fax: 703.528.3100 -----Original Message----- From: Huang, JS [mailto:Huang.JS(a)principal.com] Sent: Friday, March 23, 2007 11:42 AM To: Carol Bristow; SAS-L(a)LISTSERV.UGA.EDU Subject: RE: Re: PROC EXPORT error "DBMS type EXCEL2000 not valid for export" 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.
From: Carol Bristow on 23 Mar 2007 11:38 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.
From: "Droogendyk, Harry" on 23 Mar 2007 11:52 I've never found the need to specify a DBMS parameter on PROC EXPORT when the OUTFILE specification ended in .xls. Drop it entirely. -----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! _______________________________________________________________________ This e-mail may be privileged and/or confidential, and the sender does not waive any related rights and obligations. Any distribution, use or copying of this e-mail or the information it contains by other than an intended recipient is unauthorized. If you received this e-mail in error, please advise me (by return e-mail or otherwise) immediately. Ce courrier �lectronique est confidentiel et prot�g�. L'exp�diteur ne renonce pas aux droits et obligations qui s'y rapportent. Toute diffusion, utilisation ou copie de ce message ou des renseignements qu'il contient par une personne autre que le (les) destinataire(s) d�sign�(s) est interdite. Si vous recevez ce courrier �lectronique par erreur, veuillez m'en aviser imm�diatement, par retour de courrier �lectronique ou par un autre moyen.
From: "Gao, Yubo" on 23 Mar 2007 11:49 Huang, My computer also has Excel2003. I use the following, and it works. Try This option. dbms=Excel97 Yubo proc export data=form1407 outfile="j:\Clinician Outcomes Data\SAS\form1407.xls" dbms=Excel97 replace; -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L(a)LISTSERV.UGA.EDU] On Behalf Of Huang, JS Sent: Friday, March 23, 2007 10: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.
From: "Huang, JS" on 23 Mar 2007 12:00 Harry: I tried and got the following in LOG window: 1991 proc export 1992 data=BackDateInfo 1993 outfile="D:\BackDateInfo.XLS" 1994 replace; ERROR: Unable to determine datasource type. Please use the DBMS= option. -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L(a)LISTSERV.UGA.EDU] On Behalf Of Droogendyk, Harry Sent: Friday, March 23, 2007 10:52 AM To: SAS-L(a)LISTSERV.UGA.EDU Subject: Re: PROC EXPORT error "DBMS type EXCEL2000 not valid for export" I've never found the need to specify a DBMS parameter on PROC EXPORT when the OUTFILE specification ended in .xls. Drop it entirely. -----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! _______________________________________________________________________ This e-mail may be privileged and/or confidential, and the sender does not waive any related rights and obligations. Any distribution, use or copying of this e-mail or the information it contains by other than an intended recipient is unauthorized. If you received this e-mail in error, please advise me (by return e-mail or otherwise) immediately. Ce courrier �lectronique est confidentiel et prot�g�. L'exp�diteur ne renonce pas aux droits et obligations qui s'y rapportent. Toute diffusion, utilisation ou copie de ce message ou des renseignements qu'il contient par une personne autre que le (les) destinataire(s) d�sign�(s) est interdite. Si vous recevez ce courrier �lectronique par erreur, veuillez m'en aviser imm�diatement, par retour de courrier �lectronique ou par un autre moyen. -----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.
First
|
Prev
|
Next
|
Last
Pages: 1 2 3 4 Prev: Time-lag Repeated Measures Model Next: Heckman Selection Model |