search for: xpt

Hello R folk I have an xpt file which I have been trying to open into R in R studio On the net I found guidance which says that I need packages Hmisc and SASxport which I have successfully loaded. I had also found some code which says that this would allow me to read the xpt file into R: library(SASxport) data(Alfalfa) lo...

-------- Original Message ---------- From: WRAY NICHOLAS <nicholas.wray at ntlworld.com> To: peter dalgaard <pdalgd at gmail.com> Date: 14 April 2018 at 20:18 Subject: Re: [R] Reading xpt files into R Well yesterday I'd downloaded the "foreign" package and tried to open the xpt file using that: library(foreign) read.xport("test.xpt") I got the following error and warning messages: > read.xport("test.xpt") Error in read.xport("test.xpt&q...

> On Apr 13, 2018, at 10:01 AM, WRAY NICHOLAS via R-help <r-help at r-project.org> wrote: > > Hello R folk > > I have an xpt file which I have been trying to open into R in R studio > > On the net I found guidance which says that I need packages Hmisc and SASxport which I have successfully loaded. > > I had also found some code which says that this would allow me to read the xpt file into R: > > libr...

...M, WRAY NICHOLAS via R-help <r-help at r-project.org> wrote: > > > -------- Original Message ---------- > From: WRAY NICHOLAS <nicholas.wray at ntlworld.com> > To: peter dalgaard <pdalgd at gmail.com> > Date: 14 April 2018 at 20:18 > Subject: Re: [R] Reading xpt files into R > > > Well yesterday I'd downloaded the "foreign" package and tried to open the xpt file using that: > > library(foreign) > read.xport("test.xpt") > > I got the following error and warning messages: > >> read.xport("tes...

The above came with V1.2.3, but don't seem to be included with V1.3.0. When I upgraded R, I assumed they would also come with the new version, so didn't save them elsewhere. Could someone please email them to me, or tell me where I could get hold of them? Many thanks in advance. ****************************************************************************************** * Dr.

Dear All, I try to read the SAS transport file in R, but it shows error. Please help! I am using R 2.11.1 library(foreign) download.file("http://isites.harvard.edu/fs/docs/icb.topic35387.files/demo_c.xpt","C:/Desktop/demo_c.xpt") sasxport <- read.xport("C:/Desktop/demo_c.xpt") Error in lookup.xport(file) : file not in SAS transfer format -- View this message in context: http://r.789695.n4.nabble.com/How-to-this-SAS-transport-file-in-R-tp3073969p3073969.html Sent...

...the following version. > version _ platform i386-pc-linux-gnu arch i386 os linux-gnu system i386, linux-gnu status major 1 minor 8.1 year 2003 month 11 day 21 language R > lookup.xport ignores some datasets in sas export file. File "emptySasData3.xpt" (available at http://biostat.mc.vanderbilt.edu/tmp/emptySasData3.xpt) is a recreation of sensitive data. It was generated in SAS as an export file containing 51 empty datasets, but it has a structure of the non-empty data that revealed the problem (and can not be shared). It means that lookup...

...m with lookup.xport when there are multiple files. The documentation states that a list with a major element for each dataset will be created. read.xport is supposed to create a list of data frames for this case. Here is SAS code I used to create test files, followed by R output. libname x SASV5XPT "test.xpt"; libname y SASV5XPT "test2.xpt"; PROC FORMAT; VALUE race 1=green 2=blue 3=purple; RUN; PROC FORMAT CNTLOUT=format;RUN; data test; LENGTH race 3 age 4; age=30; label age="Age at Beginning of Study"; race=2; d1='3mar2002'd ; dt1='3mar2002 9:31:02&...

...minor 6.1 year 2002 month 11 day 01 language R and using foreign 0.5-8 I am encountering errors when using read.xport. Here's code for producing SAS transport files for testing: libname x SASV5XPT "test.xpt"; libname y SASV5XPT "test2.xpt"; PROC FORMAT; VALUE race 1=green 2=blue 3=purple; RUN; PROC FORMAT CNTLOUT=format;RUN; data test; LENGTH race 3 age 4; age=30; label age="Age at Beginning of Study"; race=2; d1='3mar2002'd ; dt1='3mar2002 9:31:02...

...I am trying to read a SAS version 9.1.3 SAS dataset into R (to preserve the SAS labels), but am unable to do so (I have read in a CSV version). I first created a transport file using the SAS code: libname ces2 'D:\CES Analysis\Data'; filename transp 'D:\CES Analysis\Data\fadata.xpt'; /* create a transport file - R cannot read file created by proc cport */ proc cport data=ces2.fadata file=transp; run; I then tried to read it in R using: > library(foreign) > library(Hmisc) > fadata2 <- sasxport.get("D:\\CES Analysis\\Data\\fadata.xpt")...

Dear All, I get the following error when using either SASxport or Hmisc to read an .xpt file: > w <- read.xport("D:/consult/Trophos/dnp/base/TRO_ds_20081006.xpt") Erreur dans factor(x, f$value, f$label) : invalid labels; length 15 should be 1 or 14 > z<- sasxport.get("D:/consult/Trophos/dnp/base/TRO_ds_20081006.xpt") Erreur dans factor(x, f$value, f...

Hi, I know how to use SPSS and JMP, and have quite a few JMP files I would like to use in R. I converted them to .xpt files, downloaded the 'foreign' library then tried this command: >read.xport("D:\\Databases\nameoffile.xpt") to which I get: >Error in lookup.xport(file) : unable to open file I have read FAQ lists and Google searched and cannot figure out what I'm doing wrong that m...

Dear Rxperts! My colleagues used SAS PROC COPY to generate the xpt files that could be read by the available "xpt" file reading packages in R. However, I am unable to use the R packages for reading SAS transport files generated through SAS PROC CPORT. I have tried SASxport, Hmisc, and foreign. Any ideas/suggestions are more than welcome! Thanks so much...

Hello all, I have a large database (~100MB in 13 relational files) that made its way to me in two formats. The files were sent in both SAS xport and STATA, thanks, I am told, to stat-transfer. The two files, ostensibly, contain the same data, just in different formats. My goal: Move these files to MySQl without the help of SAS or STATA (which I do not have). The tools I am using are: 1.

I am a physician examining an NHANES dataset available at the NCHS website: http://www.cdc.gov/nchs/about/major/nhanes/nhanes2005-2006/demo_d.xpt http://www.cdc.gov/nchs/about/major/nhanes/nhanes2005-2006/hdl_d.xpt http://www.cdc.gov/nchs/about/major/nhanes/nhanes2005-2006/tchol_d.xpt Thank you to the R authors and the foreign package authors in particular. Importing from the SAS export fomat file was a snap. It consists of demographic...

I downloaded data from http://www.hcp.med.harvard.edu/ncs/ Which provides data in DTA (STATA), XPT (SAS), and POR (SPSS) formats all of which I have tried to read with the foreign package but I am not able to load any of them. I have 2 gb of RAM, but R crashes when the memory gets just over 1 GB. I am using Windows version 2.1.1. The size of the DTA file is 48 MB; the xpt file is 188 MB. I w...

...eated a symbolic link from /usr/bin/java to ~/.mozilla/plugins/java but still Java does not work. Please see data below. Thank you so much. Benjamin [sher at localhost .mozilla]$ ls firefox mozver.dat plugins [sher at localhost .mozilla]$ cd plugins [sher at localhost plugins]$ ls flashplayer.xpt java libflashplayer.so [sher at localhost plugins]$ ls -l total 6892 -rw-r--r-- 1 sher sher 856 Dec 15 13:51 flashplayer.xpt lrwxrwxrwx 1 root root 4 Apr 16 16:22 java -> java -rwxr-xr-x 1 sher sher 7040080 Dec 15 13:51 libflashplayer.so [sher at localhost plugins]$ --------...

...rings that are only one character long. Here is an example. ---- SAS commands to create the data ---- options nocenter; data foo; a='a'; b='bb'; length c d $2; c='c'; d=' d'; x=3.1; output; run; proc print data=foo; run; libname xpt xport 'xpt.foo'; proc copy in=work out=xpt memtype=data; select foo; run; proc contents data=foo; run; ---------- output from proc print ------- OBS A B C D X 1 a bb c d 3.1 --------- in R ------------- > foo <- read.xport('xpt.foo'...

Full_Name: Jorge A. Tomasevic Version: 1.2.2 OS: Win98 Submission from: (NULL) (146.83.23.177) As i'm not an "R-expert-user", i will describe what i do: i) open Rgui.exe ii) ivoke foreign library : >library(foreign) iii) i try to read an .xpt file (from Systat 9): >datos <- read.xport('ipoisson.xpt') iv) then the program crashes. Norton CrashGuard alerts the multiple failures: Windows 98 Version 4.10.1998 RGUI failure in no-valid page module KERNEL32.DLL of 0177:bff7b983. Regiters: EAX=00000020 CS=0177 EIP=bff7b983 EFLGS=...

...command line by itself, it runs fine. The command line is this: /usr/bin/R CMD BATCH --no-restore --no-save '--args $taxFile $taxFile.taxonomy' batchMakeTax.R batchMakeTax.log Here's the output of the script: Processing /usr/bin/R CMD BATCH --no-restore --no-save '--args Call0103.xpt Call0103.xpt.taxonomy' batchMakeTax.R batchMakeTax.log /usr/lib/R/bin/BATCH: line 55: Call0103.xpt: Permission denied I do not know why it's trying to write to the input file... any ideas? Here's the shellscript: [josh at localhost cr]$ cat batchMakeTax.sh #!/bin/sh FILES="*.xp...