Proc SQL passthrough update

[erockanderson]

I need to update a variable in a sql database but the variable name is too long for sas to handle through a regular update statement. I pull the data using a passthrough statement but can not figure out how to update using the passthrough statement. Basically I've got a table of two variables one to match on and the other with the value that needs to be updated. Anyone out there know how to get SAS to do this?

 

[klaz2002]

why not write a Stored procedure and use SAS just to pass through.

In other words, SAS would only call the procedure name along with params.