ps.sql2df: SQL to Data.Frame

Description Usage Arguments Details Value Examples

Description

Execute a sql query and return the results as a data.frame

Usage

1
ps.sql2df(conn, sql.query)

Arguments

conn

Database connection object created by ps.connect.to.netezza

sql.query

SQL query string, just as you might type into Aginity

Details

This function uses a database connection to execute a sql query string. The results returned by the query are returned as an R data frame.

Value

Calculated accuracy of propensity scores

Examples

1
2
3
4
## Not run: 
myData <- ps.sql2df(nzconn, "select * from database.table limit 100")

## End(Not run)

OHDSI/Centaur documentation built on May 7, 2019, 8:22 p.m.