similar to: Import selected columns from sas7bdat file

hi, the sas universal viewer might be a free, non-R way to convert a sas7bdat file to non-proprietary formats, not sure if it's windows-only. those other formats should be easier to import only a subset of columns into R.. https://support.sas.com/downloads/browse.htm?fil=&cat=74 On Thu, Aug 10, 2017 at 7:42 AM, peter dalgaard <pdalgd at gmail.com> wrote: > I had a look at this

I had a look at this a while back and it didn't seem to be easy. The path of least resistance would seem to be to use SAS itself to create a data set with fewer columns, but of course that requires you to get access to SAS. Otherwise, I think you'd have to modify sas7bdat::read.sas7bdat to drop unselected columns. That function is pure R code, so it might not be quite as hard as it

Hi, I have a file in .sas7bdat format. I tried to open this file using read.sas7bdat() function. This gave me an error - "Error in read.sas7bdat("bnp_genetic.sas7bdat") : unknown host X64_7PRO". Could someone tell me what this error means? Thank you, Praveen. [[alternative HTML version deleted]]

Dear R-ers, I was trying to read in a large sas7bdat file (size 148094976 bytes) using 'read.sas7bdat()', but it did not read in the data correctly. E.g., the first 5 rows will come out like this (I'm omitting other columns to keep it readable): PERSON_ID age 1 5.399114e-315 5.329436e-315 2 5.399114e-315 5.328302e-315 3 5.399114e-315 5.332026e-315 4

Hi I'm trying to use the sas7bdat package. It's working - I tried using it for a very small file and it worked very quickly and imported the data correctly. I then try it for a bigger file (315MB) and it takes quite a long time, more than 10 minutes and still not done. So I stopped it because from what I read, it shouldn't be taking this long. Should it take this long for a file this

R 2.15.1 OS 10.7 Colleagues I have been an enthusiastic user of the sas7bdat package in R. However, several recent sas7bdat files sent to me from different sources cannot be read by the package. The error message is: Error in read.sas7bdat(FILENAME) : unknown host W32_7PRO please report bugs to sas7bdatRbugs at gmail.com I examined the file with a text editor and it contains

Hi, I was reading e-mail about one doubt that you were when you read files .sas7bdat in R. Now, I am with the same problem. But I don?t know how can i do that. I have download de Sas Viewer and i am using this sintax in r: > read.ssd("X:\\users\\Anresc07","que0411.sas7bdat") SAS failed. SAS program at C:\DOCUME~1\leandro\CONFIG~1\Temp\RtmpXR1Tid\file3d6c4ae1.sas The log

Hi, I have a need to process (in real-time) a large number of .sas7bdat files from within R. The problem is I don't want to convert these files to .xpt (transport) every time. So just checking if anyone has a (viable) way to read .sas7bdat files directly into R? Thank You. //---------------------------------- // Alex Bryant // Software Developer // Integrated Clinical systems //

Hi, With reference to the mail below, I have large datasets, coming from various different sources, which I can read into filebacked big.matrix using library bigmemory. I want to merge them all into one 'big.matrix' object. (Later, I want to run regression using library 'biglm'). I am unsuccessfully trying to do this from quite some time now. Can you please

Hi All, I am trying to import a .sas7bdat file into R. I tried using Hmisc package's sasxport.get() function. temp <- sasxport.get("path\abcd.sas7bdat") I get an error that says "Error in lookup.xport(file) : file not in SAS transfer format" I am not familiar with SAS transfer format. Could somebody please clarify what is it that I am missing, Thanks for your

Hi All, I ran the following lines in R: print(object.size(a <- rep(1,10^6)),units="Mb") print(object.size(a <- rep(3.542,10^6)),units="Mb") print(object.size(b <- rep("x",10^6)),units="Mb") print(object.size(b <- rep("xyzxyz xyz",10^6)),units="Mb") print(object.size(b <- 1:10^6),units="Mb") print(object.size(b

Hi All, I want to "merge" two datasets by column "ID" and I don't want the result to be sorted by "ID". I am doing the following: > z = merge(x, y, by = "ID", sort=F) The result is not sorted by "ID". But (as oppose to what I expected) it is not even in the original order of either "x" or "y". Can

Hi R, I have an excel file in which the third column is "date" and others are "character" and "numeric". Number of columns are 12 If I use this to read the file in R: x = read.xls("D:\\file.xls") The problem is that my date column is read in julian dates. So I am using: x = read.xls("D:\\file.xls",

Hi, I am using rpart package to fit classification trees. library(rpart) fit <- rpart(Kyphosis ~ Age + Number + Start, data=kyphosis) plot(fit,uniform=T) text(fit, use.n=TRUE) But I am unable to label the branches (not the nodes) of the tree. Can somebody help me out in this? Thank you, Regards Utkarsh Singhal | Amba Research Ph +91 80 3980 8017 | Mob +91 99 0295 8815

Hi all, I am performing a stepwise regression by running the "step" function on an "lm" object. Now I want to save the intermediate iterations. I know the argument trace=T will print it on the console, but I rather want to assign it to some R object or may be output it in a CSV or text file. Any help will be appreciated. Regards Utkarsh

Hi All, I have vector of length 52, say, x=sample(30,52,replace=T). I want to sort x and split into five *nearly equal groups*. Note that the observations are repeated in x so in case of a tie I want both the observations to fall in same group. This seems a very common task to do, but still I couldn't find an R function to do this. Any help would be highly appreciated. Regards Utkarsh

I am using the library(bigmemory) to handle large datasets, say 1 GB, and facing following problems. Any hints from anybody can be helpful. _Problem-1: _ I am using "read.big.matrix" function to create a filebacked big matrix of my data and get the following warning: > x = read.big.matrix("/home/utkarsh.s/data.csv",header=T,type="double",shared=T,backingfile

CARD.com is a well funded financial start-up based out of Santa Monica, CA. We are looking to grow our data science team with a Data Scientist who has superlative R programming skills and experience in scaling R-based analytics to large data stores. Details at: bit.ly/17TuBFm Thank you! -- *Ajay Gopal, PhD* *Director, Data Science & Analytics* [[alternative HTML version deleted]]

> On 10 Aug 2017, at 14:34 , Peter Dalgaard <pdalgd at gmail.com> wrote: > > Incidentally, do teach your mailer to not send plain text. It is not much of a problem this time, but HTML mails can become quite unreadable on the list. > Gah! A "not" remained after editing. DO send plain text, of course. -- Peter Dalgaard, Professor, Center for Statistics, Copenhagen

Un texte encapsul? et encod? dans un jeu de caract?res inconnu a ?t? nettoy?... Nom : non disponible Url : https://stat.ethz.ch/pipermail/r-help/attachments/20070318/73867327/attachment.pl