Questions tagged [microsoft-r]

Microsoft R is an distribution of R from Microsoft Corporation. It is an open source platform for statistical analysis and data science.

Microsoft R Open is the enhanced distribution of R from Microsoft Corporation. It is a complete open source platform for statistical analysis and data science.

176 questions
21
votes
3 answers

R: [unixODBC][Driver Manager]Can't open lib 'SQL Server' : file not found

setwd("/mnt/mountpoint/abc/") sqlServerConnString <- "SERVER=server;DATABASE=sqldwdb;UID=xyz;PWD=abc;" sqlServerDataDS <- RxSqlServerData(sqlQuery = "SELECT * FROM xyz", connectionString =…
Sonal
  • 561
  • 2
  • 6
  • 15
19
votes
4 answers

Large fixed effects binomial regression in R

I need to run a logistic regression on a relatively large data frame with 480.000 entries with 3 fixed effect variables. Fixed effect var A has 3233 levels, var B has 2326 levels, var C has 811 levels. So all in all I have 6370 fixed effects. The…
Phil
  • 954
  • 1
  • 8
  • 22
15
votes
1 answer

How to plot interaction effects from extremely large data sets (esp. from rxGlm output)

I am currenlty computing glm models off a huge data data set. Both glm and even speedglm take days to compute. I currently have around 3M observations and altogether 400 variables, only some of which are used for the regression. In my regression I…
deca
  • 730
  • 1
  • 8
  • 24
11
votes
3 answers

Warning message when opening RStudio or the R console

recently I installed Microsoft R Open 3.3.1 on my MacBook Pro (El Capitan 10.11.6). When I open RStudio or I use the R console I get this warning message: Warning message: In doTryCatch(return(expr), name, parentenv, handler) : unable to load…
amarchin
  • 2,044
  • 1
  • 16
  • 32
6
votes
1 answer

Conda install r-essentials with MKL

On my RHEL-server I do not have admin rights, but I can create Conda environments. I would like to create a Conda environment running R with Intel MKL (Intel® Math Kernel Library). I create the environment with R_defaults.yml, running $> conda env…
Geir Inge
  • 179
  • 3
  • 10
6
votes
1 answer

mclapply sendmaster error only with Rscript

I intermittently get the following error when using Rscript to call mclapply from the command-line: Error in sendMaster(try(lapply(X = S, FUN = FUN, ...), silent = TRUE)) : write error, closing pipe to the master If I run the exact same code in…
louiszya
  • 61
  • 3
6
votes
1 answer

lme() different results each run under Revolution R (MKL to blame?)

Update (Aug 2014): I never got to the bottom of this, and never got any feedback on Revolution's forum. This issue, however, seems to have been fixed in Revolution R 7.2 (with R 3.0.3, again the academic version). I ran the lme() test below a few…
Peter
  • 1,016
  • 9
  • 20
5
votes
0 answers

Rounding bug in variable info from RxSpssData

I have discovered what I think is a bug in the way MicrosoftR handles metadata from .sav files from SPSS. Here is a summary of the Variable View: ColumnA: 1 - Yes, 2 - No ColumnB: 0.33 - Yes, 0.5 - Maybe, 0.66 - No, 0.99 - Why not, 1.00 - Yes, for…
Oliver Frost
  • 827
  • 5
  • 18
4
votes
0 answers

Persisting session variables in Machine learning server

I am new to R server and I am starting to publish my functions as web services which is working fine. The problem is that they all work with a big data.table and I want to avoid having to send it (or read it from the DB) in each request. How can I…
Leonardo Lanchas
  • 1,616
  • 1
  • 15
  • 37
4
votes
0 answers

R parallel processing and (optimised) BLAS/LAPACK best practices

I have a couple of R projects in mind, both of which I'd like to utilise parallel processing and optimised BLAS libraries, but I'm a complete novice in this sort of thing so I was hoping to get some advice on the best approach(es) for the scenarios…
Mooks
  • 593
  • 4
  • 12
4
votes
3 answers

Stored procedure parameters to R

I am trying to run a simple R sum in R-Services using the parameters handed to a stored procedure but I do not know how to do it, nor find a good example. This is what I have so far: IF OBJECT_ID ( 'TEST', 'P' ) IS NOT NULL DROP PROCEDURE…
Leonardo Lanchas
  • 1,616
  • 1
  • 15
  • 37
4
votes
1 answer

How do I get rmarkdown 1.2 with Microsoft R Open 3.3.2

I am using RStudio 1.0.136 with Microsoft R Open 3.3.2 When I do File --> New File --> R Markdown... it says rmarkdown 1.2 is required but 1.1 is available And Check that getOption("repos") refers to a CRAN repository that contains the needed…
whirlaway
  • 199
  • 1
  • 10
4
votes
2 answers

Using all cores with Microsoft R Open and Google Compute Engine

I'm using Microsoft R Open on a GCE instance that has two vCPUs. Here are its specs. $ lscpu Architecture: x86_64 CPU op-mode(s): 32-bit, 64-bit Byte Order: Little Endian CPU(s): 2 On-line CPU(s) list: …
Luiz Rodrigo
  • 936
  • 1
  • 7
  • 19
3
votes
1 answer

Multithreaded function for Pivoting Data in R in SQL Server 2016

Currently I'm using the reshape library to pivot data in R, but it seems to struggle when i many columns(4000+). Is there any Multithreaded alternative to this function (similar to RevoScaleR package by MS) or any better way to do this? Here is an…
Mincho Minchev
  • 222
  • 3
  • 13
3
votes
1 answer

Installing packages on Microsoft R Open fails

I've never had any issues installing packages on R, but I always have issues installing packages on Microsoft R Open. For example, I attempted to install tidyverse. I received many errors, listed below: > Warning in system(cmd) : error in running…
orangeman51
  • 531
  • 5
  • 19
1
2 3
11 12