06-16-2015 07:02 AM
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:
ERROR: Bind parameters: Invalid column name: Name
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?
Thanks in advance,
06-16-2015 07:19 AM
Look at this:
06-16-2015 07:32 AM
I have seen this already but my variable names or labels do not contain any dots so I am sure that it helps.
06-16-2015 08:06 AM
Hmm. All references to this error message point to variable names and labels.
So I'd try to get all names and labels to conform to validvarname=v7 (alphabetic characters, digits and underline) and start from there.
06-16-2015 09:32 AM
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.
Thanks for your time,
06-16-2015 09:52 AM
SAS: a myriad ways to try doing things the wrong way.