writeSQL: Create SQL commands

In songxh0424/MPrOVE-package: Helper functions for appropriateness metrics

Description

This function creates a series of "REGEXP_LIKE" and "IN" SQL commands to query records with certain ICD codes.

Usage

writeSQL(codeList, colName, file = NULL, write.file = TRUE,
  add.periods = FALSE)

Arguments

colName	The corresponding column name to put in "REGEXP_LIKE" commands.
file	The path to output txt file.
write.file	A logical value controlling whether or not to write the output into file. Default is TRUE. When write.file is FALSE, the function will return the output as a character string instead.
add.periods	If TRUE, processes each 'IN' statement with

songxh0424/MPrOVE-package documentation built on May 19, 2019, 4:18 p.m.