topic Re: Error when writing data to Excel using the Excel libname engine in SAS Programming https://communities.sas.com/t5/SAS-Programming/Error-when-writing-data-to-Excel-using-the-Excel-libname-engine/m-p/207139#M38512 <HTML><HEAD></HEAD><BODY><P>SAS: a myriad ways to try doing things the wrong way.</P><P></P><P><img id="smileyhappy" class="emoticon emoticon-smileyhappy" src="https://communities.sas.com/i/smilies/16x16_smiley-happy.png" alt="Smiley Happy" title="Smiley Happy" /></P></BODY></HTML> Tue, 16 Jun 2015 13:52:16 GMT Kurt_Bremser 2015-06-16T13:52:16Z Error when writing data to Excel using the Excel libname engine https://communities.sas.com/t5/SAS-Programming/Error-when-writing-data-to-Excel-using-the-Excel-libname-engine/m-p/207134#M38507 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I need to update an Excel spreadsheet in situ and would like to avoid using DDE so I want to use the Excel libname engine and get errors like the following:</P><P></P><P>ERROR: Bind parameters: Invalid column name: Name</P><P></P><P>This is when I try writing to the file using a data step. Can anyone tell me how to avoid this error when using the Excel LIBNAME engine to write out the data or what it means so I can take things further myself?</P><P></P><P>Thanks in advance,</P><P></P><P>John</P></BODY></HTML> Tue, 16 Jun 2015 11:02:43 GMT https://communities.sas.com/t5/SAS-Programming/Error-when-writing-data-to-Excel-using-the-Excel-libname-engine/m-p/207134#M38507 jth128 2015-06-16T11:02:43Z Re: Error when writing data to Excel using the Excel libname engine https://communities.sas.com/t5/SAS-Programming/Error-when-writing-data-to-Excel-using-the-Excel-libname-engine/m-p/207135#M38508 <HTML><HEAD></HEAD><BODY><P>Look at this:</P><P><A href="http://support.sas.com/kb/16/842.html" title="http://support.sas.com/kb/16/842.html">16842 - Writing SAS Variable Labels that Contain Dots to Excel Field/ColumnNames</A></P></BODY></HTML> Tue, 16 Jun 2015 11:19:01 GMT https://communities.sas.com/t5/SAS-Programming/Error-when-writing-data-to-Excel-using-the-Excel-libname-engine/m-p/207135#M38508 Kurt_Bremser 2015-06-16T11:19:01Z Re: Error when writing data to Excel using the Excel libname engine https://communities.sas.com/t5/SAS-Programming/Error-when-writing-data-to-Excel-using-the-Excel-libname-engine/m-p/207136#M38509 <HTML><HEAD></HEAD><BODY><P>Hi Kurt,</P><P></P><P>I have seen this already but my variable names or labels do not contain any dots so I am sure that it helps.</P><P></P><P>Thanks anyway,</P><P></P><P>John</P></BODY></HTML> Tue, 16 Jun 2015 11:32:21 GMT https://communities.sas.com/t5/SAS-Programming/Error-when-writing-data-to-Excel-using-the-Excel-libname-engine/m-p/207136#M38509 jth128 2015-06-16T11:32:21Z Re: Error when writing data to Excel using the Excel libname engine https://communities.sas.com/t5/SAS-Programming/Error-when-writing-data-to-Excel-using-the-Excel-libname-engine/m-p/207137#M38510 <HTML><HEAD></HEAD><BODY><P>Hmm. All references to this error message point to variable names and labels.</P><P>So I'd try to get all names and labels to conform to validvarname=v7 (alphabetic characters, digits and underline) and start from there.</P></BODY></HTML> Tue, 16 Jun 2015 12:06:02 GMT https://communities.sas.com/t5/SAS-Programming/Error-when-writing-data-to-Excel-using-the-Excel-libname-engine/m-p/207137#M38510 Kurt_Bremser 2015-06-16T12:06:02Z Re: Error when writing data to Excel using the Excel libname engine https://communities.sas.com/t5/SAS-Programming/Error-when-writing-data-to-Excel-using-the-Excel-libname-engine/m-p/207138#M38511 <HTML><HEAD></HEAD><BODY><P>Hi Kurt,</P><P></P><P>After another look, I think that I have it sorted. Foolishly, I left a header=no option in the libname statement from an original that I had copied and amended. That appears to have triggered the message and removing it helped. In case anyone else has the same problem, I am sharing this here for reference.</P><P></P><P>Thanks for your time,</P><P></P><P>John</P></BODY></HTML> Tue, 16 Jun 2015 13:32:19 GMT https://communities.sas.com/t5/SAS-Programming/Error-when-writing-data-to-Excel-using-the-Excel-libname-engine/m-p/207138#M38511 jth128 2015-06-16T13:32:19Z Re: Error when writing data to Excel using the Excel libname engine https://communities.sas.com/t5/SAS-Programming/Error-when-writing-data-to-Excel-using-the-Excel-libname-engine/m-p/207139#M38512 <HTML><HEAD></HEAD><BODY><P>SAS: a myriad ways to try doing things the wrong way.</P><P></P><P><img id="smileyhappy" class="emoticon emoticon-smileyhappy" src="https://communities.sas.com/i/smilies/16x16_smiley-happy.png" alt="Smiley Happy" title="Smiley Happy" /></P></BODY></HTML> Tue, 16 Jun 2015 13:52:16 GMT https://communities.sas.com/t5/SAS-Programming/Error-when-writing-data-to-Excel-using-the-Excel-libname-engine/m-p/207139#M38512 Kurt_Bremser 2015-06-16T13:52:16Z