PROC EXPORT error "DBMS type EXCEL2000 not valid for export"
in [SAS]
|
From: "Droogendyk, Harry" on 23 Mar 2007 12:47 Doesn't look like you have PC File Formats licensed, but I don't know enough ( anything? ) about the bundles and stuff like Int Tech to know if that functionality might be available there. Talk to your SAS admin or SAS account rep. You still have access to the v9 excel libname though. -----Original Message----- From: Huang, JS [mailto:Huang.JS(a)principal.com] Sent: 2007, March, 23 12:36 PM To: Droogendyk, Harry; SAS-L(a)LISTSERV.UGA.EDU Subject: RE: Re: PROC EXPORT error "DBMS type EXCEL2000 not valid for export" Harry: This is the result of running the proc you suggested. Does this indicate if PROC EXPORT to excel file is licensed? 1998 proc setinit noalias; 1999 run; NOTE: PROCEDURE SETINIT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds Original site validation data Site name: 'PRINCIPAL LIFE INSURANCE CO'. Site number: 6028002. Expiration: 31AUG2007. Grace Period: 45 days (ending 15OCT2007). Warning Period: 45 days (ending 29NOV2007). System birthday: 20SEP2006. Operating System: WIN . Product expiration dates: ---Base Product 31AUG2007 ---SAS/STAT 31AUG2007 ---SAS/GRAPH 31AUG2007 ---SAS/CONNECT 31AUG2007 ---SAS Enterprise Miner 31AUG2007 ---SAS Integration Technologies 31AUG2007 ---Enterprise Miner Server 31AUG2007 ---Enterprise Miner Thin Client 31AUG2007 ---SAS/ACCESS Interface to ODBC 31AUG2007 -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L(a)LISTSERV.UGA.EDU] On Behalf Of Droogendyk, Harry Sent: Friday, March 23, 2007 11:04 AM To: SAS-L(a)LISTSERV.UGA.EDU Subject: Re: PROC EXPORT error "DBMS type EXCEL2000 not valid for export" Strange... the uppercase .XLS doesn't matter. Execute the proc below to see if you have "SAS ACCESS Interface to PC Files" licensed. proc setinit noalias; run; Alternative is to use the v9 Excel libname engine. -----Original Message----- From: Huang, JS [mailto:Huang.JS(a)principal.com] Sent: 2007, March, 23 12:00 PM To: Droogendyk, Harry; SAS-L(a)LISTSERV.UGA.EDU Subject: RE: Re: PROC EXPORT error "DBMS type EXCEL2000 not valid for export" 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. _______________________________________________________________________ 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. _______________________________________________________________________ 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: "Huang, JS" on 23 Mar 2007 12:58 Harry: Thanks for the help! -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L(a)LISTSERV.UGA.EDU] On Behalf Of Droogendyk, Harry Sent: Friday, March 23, 2007 11:47 AM To: SAS-L(a)LISTSERV.UGA.EDU Subject: Re: PROC EXPORT error "DBMS type EXCEL2000 not valid for export" Doesn't look like you have PC File Formats licensed, but I don't know enough ( anything? ) about the bundles and stuff like Int Tech to know if that functionality might be available there. Talk to your SAS admin or SAS account rep. You still have access to the v9 excel libname though. -----Original Message----- From: Huang, JS [mailto:Huang.JS(a)principal.com] Sent: 2007, March, 23 12:36 PM To: Droogendyk, Harry; SAS-L(a)LISTSERV.UGA.EDU Subject: RE: Re: PROC EXPORT error "DBMS type EXCEL2000 not valid for export" Harry: This is the result of running the proc you suggested. Does this indicate if PROC EXPORT to excel file is licensed? 1998 proc setinit noalias; 1999 run; NOTE: PROCEDURE SETINIT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds Original site validation data Site name: 'PRINCIPAL LIFE INSURANCE CO'. Site number: 6028002. Expiration: 31AUG2007. Grace Period: 45 days (ending 15OCT2007). Warning Period: 45 days (ending 29NOV2007). System birthday: 20SEP2006. Operating System: WIN . Product expiration dates: ---Base Product 31AUG2007 ---SAS/STAT 31AUG2007 ---SAS/GRAPH 31AUG2007 ---SAS/CONNECT 31AUG2007 ---SAS Enterprise Miner 31AUG2007 ---SAS Integration Technologies 31AUG2007 ---Enterprise Miner Server 31AUG2007 ---Enterprise Miner Thin Client 31AUG2007 ---SAS/ACCESS Interface to ODBC 31AUG2007 -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L(a)LISTSERV.UGA.EDU] On Behalf Of Droogendyk, Harry Sent: Friday, March 23, 2007 11:04 AM To: SAS-L(a)LISTSERV.UGA.EDU Subject: Re: PROC EXPORT error "DBMS type EXCEL2000 not valid for export" Strange... the uppercase .XLS doesn't matter. Execute the proc below to see if you have "SAS ACCESS Interface to PC Files" licensed. proc setinit noalias; run; Alternative is to use the v9 Excel libname engine. -----Original Message----- From: Huang, JS [mailto:Huang.JS(a)principal.com] Sent: 2007, March, 23 12:00 PM To: Droogendyk, Harry; SAS-L(a)LISTSERV.UGA.EDU Subject: RE: Re: PROC EXPORT error "DBMS type EXCEL2000 not valid for export" 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. _______________________________________________________________________ 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. _______________________________________________________________________ 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.
From: David L Cassell on 26 Mar 2007 01:39
Huang.JS(a)PRINCIPAL.COM replied: > >Harry: > > This is the result of running the proc you suggested. Does this >indicate if PROC EXPORT to excel file is licensed? > >1998 proc setinit noalias; >1999 run; > >NOTE: PROCEDURE SETINIT used (Total process time): > real time 0.00 seconds > cpu time 0.00 seconds > >Original site validation data >Site name: 'PRINCIPAL LIFE INSURANCE CO'. >Site number: 6028002. >Expiration: 31AUG2007. >Grace Period: 45 days (ending 15OCT2007). >Warning Period: 45 days (ending 29NOV2007). >System birthday: 20SEP2006. >Operating System: WIN . >Product expiration dates: >---Base Product >31AUG2007 >---SAS/STAT >31AUG2007 >---SAS/GRAPH >31AUG2007 >---SAS/CONNECT >31AUG2007 >---SAS Enterprise Miner >31AUG2007 >---SAS Integration Technologies >31AUG2007 >---Enterprise Miner Server >31AUG2007 >---Enterprise Miner Thin Client >31AUG2007 >---SAS/ACCESS Interface to ODBC >31AUG2007 Note that you are seeing SAS/ACCESS to ODBC, but no other SAS/ACCESS modules. So you definitely do *NOT* have SAS/ACCESS to PC File Formats. That means no accessing Excel using PROC EXPORT. You can do it with ODBC, though. HTH, David -- David L. Cassell mathematical statistician Design Pathways 3115 NW Norwood Pl. Corvallis OR 97330 _________________________________________________________________ Interest Rates near 39yr lows! $430,000 Mortgage for $1,399/mo - Calculate new payment http://www.lowermybills.com/lre/index.jsp?sourceid=lmb-9632-18466&moid=7581 |