similar to: read sas data into R

Displaying 20 results from an estimated 100 matches similar to: "read sas data into R"

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
2008 Mar 14
2
SAS data
Hello, I am trying to read the SAS file MyData.sa7bdat in R! This file is saved under D:\data! I therefore wrote > path <-"D:/SasData" > sashome <- "C/Progra, Files/SAS Institute/9_1/SAS" > sascmd <- file.path(sashome, "sas.exe") > MyData <- read.ssd(path, "MyData", sascmd=sascmd) The results what I get:
2009 Oct 20
2
Problems importing Unix SAS .ssd04 file to R (Win)
Hello, I'm trying to import a SAS file made using SAS on Unix. Currently I'm using SAS on Windows and I'm trying to import that .ssd04 file to R. The file name of the file is testfile.ssd04 and it is located in 'M:\sasuser'. I'm using Windows XP and R 2.91. Basically what I'm doing is ############ r code ############## > library(foreign) > sashome <-
2005 Sep 26
1
reading SAS data files
I am attempting to read in a SAS 9.1 data file. After starting R I change to the directory containing the sas data file and use the "dir" command to confirm that it is there. Then I run the following R-code: library(foreign) sashome <- "/Program Files/SAS/SAS 9.1" test<-read.ssd(file.path(sashome), "pcb", sascmd = file.path(sashome,
2005 Oct 25
1
file size limit for importing SAS file
Does anyone know if there is a file size limit for inputting a SAS data set? The file size I am trying to import is 184 MB. The code is: >library("foreign") > > sashome<-"C:/Program Files/SAS Institute/SAS/V8" > input.data<-read.ssd( file.path("G:/DATA/Cam/ECPATH/FIM"),"tbm_c", + sascmd=file.path(sashome,"sas.exe")
2010 Oct 19
1
How to read only ten rows from a SAS dataset (read.ssd)?
I'm trying to read SAS datasets on Windows: sashome <- "C:/Program Files/SAS/SAS 9.1" fold <- "C:/temp" g <- read.ssd(fold, "sasfile", sascmd = file.path(sashome, "sas.exe")) How to get only e.g first ten rows into R? -J
2011 Jan 05
1
Reading large SAS dataset in R
Hi all, I have a large (approx. 1 GB) SAS dataset (test.sas7bdat) located in the server (“R:/” directory). I have SAS 9.1 installed in my PC and I can read the SAS dataset in SAS, under a windows environment, after assigning libname in "R:\" directory. Now I am trying to read the SAS dataset in R (R 2.12.0) using the read.ssd function of the “foreign” package, but I get an error
2008 Jun 26
2
Read sas7bdat
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
2009 Nov 09
4
lectura de archivos en formato SAS
Hola. yo soy usuario SAS y ahora estoy intentando comenzar a trabajar en R. Estoy necesitando leer archivos de datos que tengo en formato SAS. Se que esta el package foreing que permite leer directamente datos que se encuentran en ese formato. Alguien podria indicarme como lo debo hacer. Solo quiero leer algunas variables dado que el archivo es extenso. Muchas gracias. Silvia.
2013 Jan 02
3
suggestions about import SAS results to R.
Hello all, I have got some data in SAS, and I export it to one excel workbook with multiple sheets, for example, each sheet has the sales information for each state. Then I need to use R to do plotting, analysis on those sales data, where I need to load the data from excel to R. When I read the article at this link: http://yihui.name/en/2009/09/how-to-import-ms-excel-data-into-r/ I am
2007 Apr 23
0
Correction to PR #9631 (PR#9632)
Full_Name: Jeff Hallman Version: 2.4.1 OS: Linux Submission from: (NULL) (132.200.32.34) When I filed this a few minutes ago, I left off the rewritten read.ssd(). I've included it at the end this time. read.ssd() invokes PROC COPY to create an xport file, but PROC COPY has some annoying limitations that read.ssd() should deal with. The first is that PROC COPY doesn't work with member
2011 Mar 06
1
read.ssd() from foreign package
Hi, I am encountering a confusing problem when I tried to use read.ssd to read SAS datasets. For one SAS dataset "a.sas7bdat", it did not work; while for another SAS dataset "b.sas7bdat" it worked: > tmp<-read.ssd("C:\\SASdata", "a",sascmd="C:/Program >Files/SAS/SASFoundation/9.2/sas.exe") SAS failed. SAS program at
2008 May 15
1
Reading SAS data into R
Hi R, Suppose that SAS dataset 'tsubset1' is stored in the path, "Z:/data". Then I give the below read.ssd() command to read SAS dataset, 'tsubset1.sas7bat' into R. > library(foreign) > s=read.ssd("Z:/data","tsubset1",sascmd = "C:/Program Files/SAS/SAS 9.1/sas.exe") > s A B C 1 3 4 5 2 6 7 8 3 3 4 5 It reads
2010 Aug 02
1
read SAS dataset using read.ssd()
Hi, I am using read.ssd() from foreign package to read some SAS datasets. I have 2 types of SAS datasets, one with "sas7bdat" extension, the other with "ssd01" extension. I have no problem with the first dataset type, but got the following error message with the 2nd dataset type (with "ssd01" extension): test<-read.ssd("C:/Documents and
2008 Oct 13
2
SAS Data
Hello everybody, I would like to read a SAS Data data1.sas7bdat in R! Is this possible? Thank you a lot in advance ;), Stefo
2013 Feb 27
0
question about read.ssd function
Hi there, I am trying to read SAS dataset into R and have observed some weird behaviors. Here is my setting. I copied retail.sas7bdat from sashelp and placed it in my test directory C:\Temp. In R, I submitted the following command >read.ssd("C:/Temp", "retail", sascmd="C:/Program Files/SAS/SASFoundation/9.2/sas.exe") The data has been read correctly. But when
2007 Oct 09
2
extract year or month from date
Hi, I am having trouble extracting just the year or the month or the day from a date such as 5/7/2007 which is May 7th 2007. Is there any particular function to extract just the year from this format? When I am reading this data from a text file it is reading it correctly in the same format but does not acknowlede it as date but as a factor. If I try as.date(5/7/2007) then it is converting it to
2010 Mar 25
1
Read SAS data
Hi! I need to import in R some SAS dataset (sas7bdat). I found two functions to do it: "read.ssd" from the package "foreign" and "sas.get" from "Hmisc". df = read.ssd(libname = path2data, sectionnames = "sasSmallDataset", tmpXport = path2data, tmpProgLoc = path2data, sascmd = path2sas) sas.get(libraryName = path2data, member =
2007 Jun 11
2
Textpad help
I have installed textpad and tried running R code. But it gives me the following error message. The filename, directory name, or volume label syntax is incorrect. Tool completed with exit code 1 Can you provide any help? I am not a technical person. So the help in detail will be appreciated. Thx [[alternative HTML version deleted]]
2007 Mar 18
3
Read a .sas7bdat file
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