PROC EXPORT error "DBMS type EXCEL2000 not valid for export"
in [SAS]
|
From: Joyce on 23 Mar 2007 12:00 Check whether you have the proper license to export to Excel. Thanks, On 3/23/07, JS Huang <huang.js(a)principal.com> wrote: > > 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: Joyce on 23 Mar 2007 12:06 Goto File->Export Data from the next window select the dataset. Click Next. Check whether you have Excel listed under "Standard Data Source" if excel is not there, means you dont have license. Rgds!!! On 3/23/07, Joyce <joycegeorge(a)gmail.com> wrote: > > Check whether you have the proper license to export to Excel. > > Thanks, > > On 3/23/07, JS Huang <huang.js(a)principal.com > wrote: > > > > 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 12:05 Joyce: =20 How do I check? Probably this is the reason. While I tried to follow Carol's suggestion by using interactiver EXPORT and got to the step "What type of data do you wish to export?" There are only three choices - Comma Separated Values, Tab Delimited File and Delimited File. ________________________________ From: Joyce [mailto:joycegeorge(a)gmail.com]=20 Sent: Friday, March 23, 2007 11:01 AM To: Huang, JS Cc: SAS-L(a)listserv.uga.edu Subject: Re: PROC EXPORT error "DBMS type EXCEL2000 not valid for export" Check whether you have the proper license to export to Excel. Thanks, On 3/23/07, JS Huang <huang.js(a)principal.com > wrote:=20 Hi all: =09 I tried to export a SAS dataset to EXCEL and got some error message:=20 =09 1606 proc export 1607 data=3DBackDateInfo 1608 outfile=3D"D:\BackDateInfo.XLS" 1609 DBMS=3DEXCEL2000 1610 replace; ERROR: DBMS type EXCEL2000 not valid for export. =09 How do I fix it? I am using Excel Professional Edition 2003.=20 =09 Thanks! =09 -----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 12:03 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.
From: "Huang, JS" on 23 Mar 2007 12:35 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.
First
|
Prev
|
Next
|
Last
Pages: 1 2 3 4 Prev: Time-lag Repeated Measures Model Next: Heckman Selection Model |