read_podr: Read a dataset from PODR

In TuCai/podr: Common Functions for 'PHUSE' Open Data Repository

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

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

Value

The desired dataset as a data.frame

Author(s)

Hanming Tu

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')

## End(Not run)

TuCai/podr documentation built on June 8, 2021, 5:37 a.m.