Introducing 'sars' - proof-of-concept for running 'SAS' DATA and PROC SQL statements in R

2021-07-14

sars

sars is an totally useless, very experimental, proof-of-concept, oh-my-god-why package for executing sas DATA and 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.

Installation

You can install from GitHub with:

# install.package('remotes')
remotes::install_github('coolbutuseless/sars')

Example

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