Hi,
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,
John
Hi Kurt,
I have seen this already but my variable names or labels do not contain any dots so I am sure that it helps.
Thanks anyway,
John
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.
Hi Kurt,
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,
John
SAS: a myriad ways to try doing things the wrong way.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.