topic Re: R Markdown equivalent in SAS in ODS and Base Reporting

R Markdown equivalent in SAS

BERENZ — Tue, 24 Jul 2012 06:11:14 GMT

I wonder if there is a equivalent of R Markdown in SAS or how to do this in SAS? I want to have colored SAS code and its result below.

I want to prepare training materials for students and, as much I can, try to avoid copy and paste syntax into html (doc, pdf). There is option ods text and SASweave but it isn't what I want to do.

link to R Markdown: http://rstudio.org/docs/authoring/using_markdown

Looking forward for solutions to my problem!

Edit. I want to do such thing only using SAS, not using additional software if it is possible.

Re: R Markdown equivalent in SAS

chang_y_chung_hotmail_com — Tue, 24 Jul 2012 14:26:09 GMT

You can re-direct both log and list outputs into a single text file and parse its lines. A simple example is easy to make as I have done back in 2001 (see my sas-l posting). But bullet-proofing it is almost impossible because it is just impossible to reliably parse sas log files. You also lose the syntax coloring -- because log file is a simple text. If you are interested, then let me know. I can send you the sas2html macro source -- I have to warn you, though, that it is using sas regular expressions -- it was written before perl reg ex was widely available in sas. 🙂

Re: R Markdown equivalent in SAS

Cynthia_sas — Tue, 24 Jul 2012 15:03:04 GMT

Hi:

There have been a couple of previous forum postings on capturing and color coding the log using ODS. In addition to other suggestions, take a look at this 2012 paper

http://support.sas.com/resources/papers/proceedings12/324-2012.pdf

by Warren Kuhfeld and Tim Arnold that discusses how to use LaTeX with an open source package called StatRep, which is similar to SASWeave, but not the same. For example, the entire paper with code snippets and output was written in StatRep.

cynthia

Re: R Markdown equivalent in SAS

BERENZ — Tue, 24 Jul 2012 15:46:56 GMT

I'm interested in your sas macro i would be grateful if you send me your proposition to solve my problem.

Re: R Markdown equivalent in SAS

BERENZ — Tue, 24 Jul 2012 15:56:43 GMT

Many thanks for this article! Maybe it's not exactly what I wanted but it will be helpful. I searched forum before i post my question but I didn't find anwser for my problem. Is there an example of ODS HTML which contains both colored SAS codes and results? I want to make webpage for students where they can have practical examples of how to use SAS (code + results) and I love R Markdown, it's so simple. Hope there is similar way to do the same thing in SAS.

Re: R Markdown equivalent in SAS

chang_y_chung_hotmail_com — Tue, 24 Jul 2012 17:47:36 GMT

Send me an email. I will send the macro to you as an attachment. Thanks!!

Re: R Markdown equivalent in SAS

Cynthia_sas — Tue, 24 Jul 2012 18:11:55 GMT

Hi: There were some previous forum postings (I know because I made some of them).

https://communities.sas.com/message/40422#40422

https://communities.sas.com/message/42171#42171

https://communities.sas.com/message/16679#16679

For some of the older postings, the syntax in the programs got garbled a bit when the old posts got translated. So, for example,
_n_ could look like n or
_infile_ like infile

in the posting of the program code. And comments that should be

* this is a comment; end up looking like

this is a comment;

little bullet points without the asterisk.

But otherwise, the programs should be fairly readable but there will be a bit of fixup before you can submit the code.

I think that replicating the color coding from either the Enhanced Editor or the EG Editor will be hard to do. Essentially, you'd have to replicate the logic for the keywords for statements, the options, search the code for constants, quotes, etc, etc -- you'd be replicating the logic behind the SAS editor, but in your program.

I'd like to think that students, as students, will understand that the code they see above or below a program was what produced the results -- without the color coding. After all, when they look in the SAS documentation, the programs in the doc are "editor-neutral" -- folks on the mainframe don't always see color coding, folks on Unix using the VI editor won't see color coding, folks writing and submitting batch jobs won't see color coding -- so I think that showing them color coding is doing something above and beyond what they will see on the job when they have to look things up or read documentation or look at other people's programs on paper on in a text editor like Notepad or VI.

But, if you are organized about how you name your files, then it should be possible to "macrotize" the creation of output and the inclusion of code, especially into HTML files, since you can modify ODS HTML output files to allow output to be appended to an existing HTML file. (see this Tech Support note:

http://support.sas.com/kb/23/660.html) and notice that you have to use FIlENAME with the MOD option to append any subsequent output (like your program or your log to the created output.

cynthia

Re: R Markdown equivalent in SAS

kmcital — Mon, 11 Feb 2013 23:21:07 GMT

Closest thing that I'm aware of is the R package knitr which has experimental support for SAS as an engine. The source is a .Rmd file that runs with a batch R job, knitr package will execute the SAS code chunks with SAS, render the .md file as well as .html if you want. I haven't used it yet, but I have used R code chunks and it works great. Of course, this is what RStudio is doing when you click the button "Knit HTML".

Re: R Markdown equivalent in SAS

BarryDeCicco — Wed, 07 Jun 2017 18:50:17 GMT

Here is a list of links I've compiled today, by coincidence. I've read the first couple of links, and have gotten an example from the second link running on my computer. The third link lists a variety of software which knitr can run. Note that knitr is an R package, requiring R to run. However R and RStudio (a great IDE for R) are both free.

SAS in knitr

SAS Using R Markdown (Windows): http://www.ssc.wisc.edu/~hemken/SASworkshops/Markdown/SASmarkdown.html (raw document is at: http://www.ssc.wisc.edu/~hemken/SASworkshops/Markdown/SASmarkdown.rmd)
Language engines - Use other languages in knitr: https://yihui.name/knitr/demo/engines/
knitr-examples/060-engine-sas.Rmd: https://github.com/yihui/knitr-examples/blob/master/060-engine-sas.Rmd
SAS ODS to R markdown/Sweave/knitr - Using standard SAS ODS output to create beautiful reports in R: http://ikkyle.com/sas-ods-to-r-markdownsweaveknitr/
Using SAS® and LATEX to Create Documents with Reproducible Results (SUGI paper): http://support.sas.com/resources/papers/proceedings12/324-2012.pdf

Re: R Markdown equivalent in SAS

Doug_Hemken — Thu, 27 Jul 2017 15:30:36 GMT

The notes Barry links to

http://www.ssc.wisc.edu/~hemken/SASworkshops/sas.html#writing-sas-documentation

have been recently updated.

I've turned most of the code into an R package available from CRAN or github, called "SASmarkdown".

Re: R Markdown equivalent in SAS

Doug_Hemken — Thu, 30 Nov 2017 16:03:32 GMT

A new version of the SASmarkdown package (0.4.3) is available on CRAN.

The ability to link code blocks is now automatically enabled. You just need to use the `collectcode=TRUE` chunk option to indicate code that needs to be used for later chunks.

In addition, there is now a `spinsas` function that generates Markdown and HTML files from marked up SAS command files. If the first draft of your document is a SAS command file with comments, it can be easiest to simply add a few bits of markup and process that.