# Stata or R

[This article was first published on

Want to share your content on R-bloggers? click here if you have a blog, or here if you don't.

**Enterprise Software Doesn't Have to Suck**, and kindly contributed to R-bloggers]. (You can report issue about the content on this page here)Want to share your content on R-bloggers? click here if you have a blog, or here if you don't.

Recently I came across a complex model written in Access with complex SQL queries all over the place. The engineer who was maintaining it and I did some analysis and agreed that the model was using SQL in an unnatural way (things SQL isn’t good at) – complex logic, formatting etc.

We agreed to use SQL and a more powerful programming language to re-build the model. The engineer is familiar with Stata, so he quickly wrote Stata code. When I looked at the Stata code, it looked fairly easy to reproduce it in R. I’ve posted some R commands for the Stata commands I found in that code.

What are the advantages of using Stata? Why shouldn’t I use R for this?

To

**leave a comment**for the author, please follow the link and comment on their blog:**Enterprise Software Doesn't Have to Suck**.R-bloggers.com offers

**daily e-mail updates**about R news and tutorials about learning R and many other topics. Click here if you're looking to post or find an R/data-science job.

Want to share your content on R-bloggers? click here if you have a blog, or here if you don't.