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.1")



Attach the package and use:
library("sqlcaser")
Maintained by
Leoson Hoay
[Scholar Profile | Author Map]
All associated links for this package
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.1, https://cran.r-project.org/web/packages/sqlcaser. Accessed 13 Mar. 2026.
Previous versions and publish date:
0.2.0 (2023-11-24 14:20)
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

Today's Hot Picks in Authors and Packages

beezdemand  
Behavioral Economic Easy Demand
Facilitates many of the analyses performed in studies of behavioral economic demand. The package su ...
Download / Learn more Package Citations See dependency  
Rlabkey  
Data Exchange Between R and 'LabKey' Server
The 'LabKey' client library for R makes it easy for R users to load live data from a 'LabKey' Serve ...
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  
gtop  
Game-Theoretically OPtimal (GTOP) Reconciliation Method
In hierarchical time series (HTS) forecasting, the hierarchical relation between multiple time serie ...
Download / Learn more Package Citations See dependency  
vacuum  
Tukey's Vacuum Cleaner
An implementation of three procedures developed by John Tukey: FUNOP (FUll NOrmal Plot), FUNOR-FUNO ...
Download / Learn more Package Citations See dependency  
coalitions  
Bayesian "Now-Cast" Estimation of Event Probabilities in Multi-Party Democracies
An implementation of a Bayesian framework for the opinion poll based estimation of event probabilit ...
Download / Learn more Package Citations See dependency  

26,293

R Packages

225,784

Dependencies

70,376

Author Associations

26,294

Publication Badges

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