Displaying 20 results from an estimated 500 matches similar to: "How to this SAS transport file in R?"
2018 Apr 13
5
Reading xpt files into R
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)
lookup.xport("test.xpt")
2018 Apr 14
1
Fwd: Re: Reading xpt files into R
> On Apr 14, 2018, at 12:18 PM, 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
2018 Apr 14
0
Fwd: Re: Reading xpt files into R
-------- 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
2008 Dec 03
2
reading version 9 SAS datasets in R
Hi,
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
2004 Nov 23
3
Problem with read.xport() from foreigh package (PR#7389)
Full_Name: Ruskin Chow
Version: R 2.0.1
OS: Windows 2000
Submission from: (NULL) (203.169.154.66)
Data imported from SAS using read.xport() in package foreign are converted to
<NA> when the SAS data field consists of character strings that are only one
character long.
This is apparently a previously reported bug and perhaps fixed in some platform
other than Windows (rw2001).Some
2008 Oct 09
1
Error when reading a SAS transport file
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$label) :
2018 Apr 13
0
Reading xpt files into R
> 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
2005 Jul 14
3
read.xport
I am trying to import data from a SAS XPORT file that contains 24 SAS files.
When I use the "read.xport" procedure only about 16 data frames (components)
are created. Any suggestions?
*************************************************************************
Gary A. Nelson, Ph.D
Massachusetts Division of Marine Fisheries
30 Emerson Avenue
Gloucester, MA 01930
Phone: (978)
2003 Jan 18
1
SAS transport files and the foreign package
Even though the FDA has no policies at all that limit our choices of statistical software, there is one defacto standard in place: reliance of the SAS transport file format for data submission (even though this format is deficient for this purpose, e.g., it does not even document value labels or units of measurement in a self-contained way). Because of the widespread use of SAS transport files in
2007 Aug 15
2
Loading JMP Files
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
2008 Feb 25
1
Read.xport function in package foreign
Hi All,
Sorry that I didn't provide enough information.
I've been trying to import SAS xport files that contain multiple files
using package foreign's read.xport. I first attempted this back in 2005
and had problems. Some of files that were present in the SAS xport file
weren't being created in R. I submitted my problem to the community:
2004 Mar 26
1
lookup.xport in foreign ignoring some datasets (PR#6701)
The Details.
In 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
2002 Dec 20
1
read.xport and lookup.xport in foreign (PR#2385)
Under
platform i686-pc-linux-gnu
arch i686
os linux-gnu
system i686, linux-gnu
status
major 1
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
2001 May 05
1
read.xport bug of foreign pkg (PR#933)
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
2008 Nov 10
3
read SAS file
Looked at a lot of documentation and listserv postings and still can’t solve this problem. I need to get a SAS dataset into R. I’ve converted it to an .xpt file and when I try to read it I get:
> read.xport("cft2008R")
Error: could not find function "read.xport"
>
Not sure what I’m doing wrong. I’m running SAS 9.1.3 on an UNIX box. I ftp’d the file over to my
2001 Aug 23
3
Reading SAS version 8 data into R
Hi,
SAS transport files created with the xport engine in SAS can be read using read.xport. However, the xport engine only works with SAS version 6, and consequently long variable names are not allowed...
Can anyone tell me how to get SAS data (ver 8) into R (easily)?
Thanks in advance
S?ren H?jsgaard
sorenh at agrsci.dk http://www.jbs.agrsci.dk/~sorenh
2001 Aug 13
1
export-problem
Hello!
I am trying to export a data-file from SAS to R. It says in the R program
that the SAS file should be in XPORT-format. I assume that the file should
have and .xpt extension. But when I try to open the file in R I get only
the message "compressed" written all over. So, probably I should
un-compress the file in the R-program, the question is how?
Very greatful for quick help!
2010 Jul 31
3
a problem
dear:
when I read a Excel file(exp-11),The R project give me a error ,Just like this:
??'datafile'
> write.foreign("exp-11.xls")
???list(df = df, datafile = datafile, codefile = codefile) :
??'datafile'
> write.foreign("exp-11.xls")
???list(df = df, datafile = datafile, codefile = codefile) :
??'datafile'
>
2010 Oct 07
1
Forecasting with R/Need Help. Steps shown below with the imaginary data
1. This is an imaginary data on monthly outcomes of 2 years and I want to forecast the outcome for next 12 months of next year.
data Data1;
input Yr Jan Feb Mar Apr May June July Aug Sept Oct Nov Dec;
datalines;
2008 12 13 12 14 13 12 11 15 10 12 12 12
2009 12 13 12 14 13 12 11 15 10 12 12 12
;
run;
I converted the above data into the below format to use it in R as it was giving error: asking
2005 Apr 07
1
Importing SAS transport data
I have encountered a problem reading SAS transport files on both a Mac
(OS X) and Linux (RedHat 9), both using R2.0.1.
After loading "foreign", the command:
read.xport("V1622101_050304.xpt")
yields:
Error in lookup.xport(file) : File not in SAS transfer format
In Linux, I can "cat" the file. The first few lines are:
**COMPRESSED** **COMPRESSED** **COMPRESSED**