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]
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.0, https://cran.r-project.org/web/packages/sqlcaser. Accessed 18 Feb. 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
Get rewarded with contribution points by helping add
Reviews / comments / questions /suggestions ↴↴↴

Today's Hot Picks in Authors and Packages

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  
clustMixType  
k-Prototypes Clustering for Mixed Variable-Type Data
Functions to perform k-prototypes partitioning clustering for mixed variable-type data according to ...
Download / Learn more Package Citations See dependency  
MOSS  
Multi-Omic Integration via Sparse Singular Value Decomposition
High dimensionality, noise and heterogeneity among samples and features challenge the omic integrat ...
Download / Learn more Package Citations See dependency  
OptGS  
Near-Optimal Group-Sequential Designs for Continuous Outcomes
Optimal group-sequential designs minimise some function of the expected and maximum sample size whil ...
Download / Learn more Package Citations See dependency  
RobustBayesianCopas  
Robust Bayesian Copas Selection Model
Fits the robust Bayesian Copas (RBC) selection model of Bai et al. (2020) for cor ...
Download / Learn more Package Citations See dependency  
readxlsb  
Read 'Excel' Binary (.xlsb) Workbooks
Import data from 'Excel' binary (.xlsb) workbooks into R. ...
Download / Learn more Package Citations See dependency  

23,712

R Packages

205,795

Dependencies

64,332

Author Associations

23,631

Publication Badges

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