topic Re: writing to excel workbook pb. in SAS Programming https://communities.sas.com/t5/SAS-Programming/writing-to-excel-workbook-pb/m-p/90425#M257275 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #333333; font-family: Arial, Helvetica, Verdana, sans-serif;">Hi.</SPAN></P><P><SPAN style="color: #333333; font-family: Arial, Helvetica, Verdana, sans-serif;">please see this page from sas.com</SPAN></P><P><SPAN style="color: #333333; font-family: Arial, Helvetica, Verdana, sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #333333; font-family: Arial, Helvetica, Verdana, sans-serif;"><A class="active_link" href="http://support.sas.com/kb/40/932.html" title="http://support.sas.com/kb/40/932.html">40932 - "Error: Cannot set AUTOCOMMIT=NO due to driver limitations" when using PROC IMPORT or PROC EXPORT</A></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em; color: #333333; font-family: Arial, Helvetica, Verdana, sans-serif;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em; color: #333333; font-family: Arial, Helvetica, Verdana, sans-serif;">"...To circumvent the problem, issue a </SPAN><STRONG style="font-size: 10pt; line-height: 1.5em; color: #333333; font-family: Arial, Helvetica, Verdana, sans-serif;">LIBNAME <EM>libref</EM> CLEAR;..."</STRONG></P><P><STRONG style="font-size: 10pt; line-height: 1.5em; color: #333333; font-family: Arial, Helvetica, Verdana, sans-serif;"><BR /></STRONG></P><P>I hope it helps.</P><P><STRONG style="font-size: 10pt; line-height: 1.5em; color: #333333; font-family: Arial, Helvetica, Verdana, sans-serif;"><BR /></STRONG></P><P>Anca.<STRONG style="font-size: 10pt; line-height: 1.5em; color: #333333; font-family: Arial, Helvetica, Verdana, sans-serif;"><BR /></STRONG></P></BODY></HTML> Thu, 25 Jul 2013 16:00:59 GMT AncaTilea 2013-07-25T16:00:59Z writing to excel workbook pb. https://communities.sas.com/t5/SAS-Programming/writing-to-excel-workbook-pb/m-p/90424#M257274 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I am experiencing some difficulties to write to an excel workbook. The following message is currently displayed. Cannot set&nbsp; AUTOCOMIT=NO due to driver limitations. Errors in libname statement.</P><P>Can anyone help me.</P><P></P><P><BR /> </P></BODY></HTML> Thu, 25 Jul 2013 15:57:48 GMT https://communities.sas.com/t5/SAS-Programming/writing-to-excel-workbook-pb/m-p/90424#M257274 ajonkeua 2013-07-25T15:57:48Z Re: writing to excel workbook pb. https://communities.sas.com/t5/SAS-Programming/writing-to-excel-workbook-pb/m-p/90425#M257275 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #333333; font-family: Arial, Helvetica, Verdana, sans-serif;">Hi.</SPAN></P><P><SPAN style="color: #333333; font-family: Arial, Helvetica, Verdana, sans-serif;">please see this page from sas.com</SPAN></P><P><SPAN style="color: #333333; font-family: Arial, Helvetica, Verdana, sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #333333; font-family: Arial, Helvetica, Verdana, sans-serif;"><A class="active_link" href="http://support.sas.com/kb/40/932.html" title="http://support.sas.com/kb/40/932.html">40932 - "Error: Cannot set AUTOCOMMIT=NO due to driver limitations" when using PROC IMPORT or PROC EXPORT</A></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em; color: #333333; font-family: Arial, Helvetica, Verdana, sans-serif;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em; color: #333333; font-family: Arial, Helvetica, Verdana, sans-serif;">"...To circumvent the problem, issue a </SPAN><STRONG style="font-size: 10pt; line-height: 1.5em; color: #333333; font-family: Arial, Helvetica, Verdana, sans-serif;">LIBNAME <EM>libref</EM> CLEAR;..."</STRONG></P><P><STRONG style="font-size: 10pt; line-height: 1.5em; color: #333333; font-family: Arial, Helvetica, Verdana, sans-serif;"><BR /></STRONG></P><P>I hope it helps.</P><P><STRONG style="font-size: 10pt; line-height: 1.5em; color: #333333; font-family: Arial, Helvetica, Verdana, sans-serif;"><BR /></STRONG></P><P>Anca.<STRONG style="font-size: 10pt; line-height: 1.5em; color: #333333; font-family: Arial, Helvetica, Verdana, sans-serif;"><BR /></STRONG></P></BODY></HTML> Thu, 25 Jul 2013 16:00:59 GMT https://communities.sas.com/t5/SAS-Programming/writing-to-excel-workbook-pb/m-p/90425#M257275 AncaTilea 2013-07-25T16:00:59Z Re: writing to excel workbook pb. https://communities.sas.com/t5/SAS-Programming/writing-to-excel-workbook-pb/m-p/90426#M257276 <HTML><HEAD></HEAD><BODY><P>thank you.</P><P>when I write your libname, it answer, no libname test assigned</P><P><BR /> </P></BODY></HTML> Thu, 25 Jul 2013 16:19:08 GMT https://communities.sas.com/t5/SAS-Programming/writing-to-excel-workbook-pb/m-p/90426#M257276 ajonkeua 2013-07-25T16:19:08Z