This function takes sas code, extracts all the SQL queries and then optionally pulls them from IMPAC II. If the query is not sent to the database, it will return the extracted statements as a list of strings for editing or inspection.
1 2 | convertSASQuery(sasFile, user, pass, submit = TRUE, env = .GlobalEnv,
pathToOJ = "C:/app/OITDSKADM/product/11.2.0/client_1/jdbc/lib/ojdbc6.jar")
|
sasFile |
Path to the sas code file. |
user |
Character string containing IMPAC II username |
pass |
Character string containing IMPAC II password |
submit |
Logical, pull the data |
env |
If submit is TRUE, environment in which to load the data. Don't modify this unless you know what you are doing |
pathToOJ |
Path to the oracle database driver. Depends on your machine, search for ojdbc6.jar from the Windows start menu. |
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.