Other packages > Find by keyword >

sqlcaser  

'SQL' Case Statement Generator
View on CRAN: Click here


Download and install sqlcaser package within the R console
Install from CRAN:
install.packages("sqlcaser")

Install from Github:
library("remotes")
install_github("cran/sqlcaser")

Install by package version:
library("remotes")
install_version("sqlcaser", "0.2.0")



Attach the package and use:
library("sqlcaser")
Maintained by
Leoson Hoay
[Scholar Profile | Author Map]
First Published: 2023-11-24
Latest Update: 2023-11-24
Description:
Includes built-in methods for generating long 'SQL' CASE statements, and other 'SQL' statements that may otherwise be arduous to construct by hand. The generated statement can easily be concatenated to string literals to form queries to 'SQL'-like databases, such as when using the 'RODBC' package. The current methods include casewhen() for building CASE statements, inlist() for building IN statements, and updatetable() for building UPDATE statements.
How to cite:
Leoson Hoay (2023). sqlcaser: 'SQL' Case Statement Generator. R package version 0.2.0, https://cran.r-project.org/web/packages/sqlcaser. Accessed 18 Apr. 2025.
Previous versions and publish date:
No previous versions
Other packages that cited sqlcaser R package
View sqlcaser citation profile
Other R packages that sqlcaser depends, imports, suggests or enhances
Complete documentation for sqlcaser
Functions, R codes and Examples using the sqlcaser R package
Some associated functions: casewhen . inlist . updatetable . 
Some associated R codes: casewhen.R . inlist.R . updatetable.R .  Full sqlcaser package functions and examples
Downloads during the last 30 days
03/1903/2003/2103/2203/2303/2403/2503/2603/2703/2803/2903/3003/3104/0104/0204/0304/0404/0504/0604/0704/0804/0904/1004/1104/1204/1304/1404/1504/1604/17Downloads for sqlcaser1234567891011121314TrendBars

Today's Hot Picks in Authors and Packages

nsga3  
An Implementation of Non-Dominated Sorting Genetic Algorithm III for Feature Selection
An adaptation of Non-dominated Sorting Genetic Algorithm III for multi objective feature selection ...
Download / Learn more Package Citations See dependency  
chngpt  
Estimation and Hypothesis Testing for Threshold Regression
Threshold regression models are also called two-phase regression, broken-stick regression, split-poi ...
Download / Learn more Package Citations See dependency  
SeqAlloc  
Sequential Allocation for Prospective Experiments
Potential randomization schemes are prospectively evaluated when units are assigned to treatment ar ...
Download / Learn more Package Citations See dependency  
r2resize  
In-Text Resize for Images, Tables and Fancy Resize Containers in 'shiny', 'rmarkdown' and 'quarto' Documents
Automatic resizing toolbar for containers, images and tables. Various resizable or expandable contai ...
Download / Learn more Package Citations See dependency  
CDNmoney  
Components of Canadian Monetary and Credit Aggregates
Components of Canadian Credit Aggregates and Monetary Aggregates with continuity adjustments. ...
Download / Learn more Package Citations See dependency  
pssmooth  
Flexible and Efficient Evaluation of Principal Surrogates/Treatment Effect Modifiers
Implements estimation and testing procedures for evaluating an intermediate biomarker response as a ...
Download / Learn more Package Citations See dependency  

24,012

R Packages

207,311

Dependencies

65,069

Author Associations

24,013

Publication Badges

© Copyright since 2022. All right reserved, rpkg.net.  Based in Cambridge, Massachusetts, USA