podr (version 0.0.5)

read_podr: Read a dataset from PODR

Description

This function will properly query PODR for datasets. There are three "libraries" available to read from: - CDISC Pilot ADaM data (PHUSE TDF Project 2019 cut) - CDISC Pilot SDTM data (PHUSE TDF Project 2019 cut) - Janssen Synthetic SDTM data

Usage

read_podr(
  dataset = NULL,
  libname = NULL,
  tabname = NULL,
  con = getOption("podr_connection"),
  query_string = NULL,
  limit = 100
)

Arguments

dataset

Dataset name, specified as a character string

libname

Library name, one of cdisc_pilot_adam, cdisc_pilot_sdtm, or janssen_synthetic

tabname

Full table name, i.e., the combination of libname and dataset

con

The connection to PODR. Use connect_podr to establish a connection, or specify a variable containing the proper PostgreSQL connection into PODR yourself

query_string

provides full SQL statement

limit

to select specified number of records; defaults to 100

Value

The desired dataset as a data.frame

Details

Read data by specifying your desired dataset as a character string, then specify the library you'd like to read from. The libnames are specified as - cdisc_pilot_adam - cdisc_pilot_sdtm - janssen_synthetic

Examples

# NOT RUN {
conn_podr()
read_podr('adae', libname='cdisc_pilot_adam')
read_podr('ae', libname='cdisc_pilot_sdtm')
read_podr('ae', libname='janssen_synthetic')
# }
# NOT RUN {
# }