convertSASQuery: Retrieve a sas file and extract all SQL queries from it.

Description Usage Arguments

Description

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.

Usage

1
2
convertSASQuery(sasFile, user, pass, submit = TRUE, env = .GlobalEnv,
  pathToOJ = "C:/app/OITDSKADM/product/11.2.0/client_1/jdbc/lib/ojdbc6.jar")

Arguments

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.


sachsmc/rreporttools documentation built on May 29, 2019, 12:55 p.m.