sars is an totally useless, very experimental, proof-of-concept, oh-my-god-why package for
PROC SQL statements in R.
What’s in the box
sars::run(code)to run some code
- as long as it is only DATA and PROC SQL statements
- and even then, not much of either of those statements is really supported either.
You can install from GitHub with:
# install.package('remotes') remotes::install_github('coolbutuseless/sars')
library(sars) sars::run(" data mytable; set 'mtcars'; run; proc sql; SELECT cyl, sum(mpg) as total FROM mytable WHERE am = 1 GROUP BY cyl ORDER BY cyl; quit;" )
## cyl total ## 1 4 224.6 ## 2 6 61.7 ## 3 8 30.8