| This post was kindly contributed by Heuristic Andrew » sas - go there to comment and to read the full post. |
I have an ETL job that updates 10,000 rows in a large, remote Microsoft SQL table with 700,000 rows (1.4%). (The specific brand of remote SQL database doesn’t matter: this should work equally well for any ODBC RDMS.) This tutorial shows two ways of updating the remote table with SAS’s PROC SQL, and the second […]
| This post was kindly contributed by Heuristic Andrew » sas - go there to comment and to read the full post. |