search for: sascmd

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: SAS failed. SAS program at C:\DOCUME~1\Temp\RtmpcTlKtb\file4eb43288.sas The log file will be file4eb43288.log in the current directory NULL Warni...

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 C:\DOCUME~1\yiz01\LOCALS~1\Temp\RtmpVjJa6m\file12384509.sas The log file will be file12384509.log in the current directory Warning message: In read.ssd("C:\\SASdata", "a", sascmd = &q...

Hi I am having trouble using read.ssd. Can someone help? The code that I have written is *sashome<-"C:/Mary/Datasets"* *read.ssd(read.ssd(file.path(sashome, "core", "sashelp"), "surv_1v",* *sascmd = file.path(sashome, "sas.exe"))* Here the path that I have given is correct, where the dataset surv_1v.sas7bdat is kept. The message that R gives me is this: *SAS failed. SAS program at C:\DOCUME~1\Royerm02\LOCALS~1\Temp\Rtmpdi2Osb\file4ff053f7.sas The log file will be file4ff053f7.lo...

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 perfect! It reads well for "tsubset1","tsubset2",....., "tsubset9" datasets. But then onwards it gives an error as below: * s=read.ssd("Z:/data&q...

I'm trying to read in a sas system file (.sas7bdat) created under SAS 8.2 using read.ssd as follows: > library(foreign) > libname <- "c:/sasuser/consult/" > sascmd <- "c:/Program\ Files/SAS\ Institute/SAS/V8/sas.exe" > subset <- read.ssd(libname, "subset", sascmd=sascmd) SAS failed. SAS program at c:\windows\TEMP\Rtmp6673\file24544.sas a log and other error products should be in the vicinity Warning messages: 1: c:/Program not...

...sing Windows XP and R 2.91. Basically what I'm doing is ############ r code ############## > library(foreign) > sashome <- "C:/Program Files/SAS Institute/SAS/V8" > folder_for_datafiles <- "M:/sasuser" > read.ssd(folder_for_datafiles, "testfile", sascmd=file.path(sashome, "sas.exe")) SAS failed. SAS program at C:\DOCUME~1\jrara\LOCALS~1\Temp\RtmpAAxO3X\file41bb5af1.sas The log file will be file41bb5af1.log in the current directory NULL Warning message: In read.ssd(folder_for_datafiles, "testfile", sascmd = file.path(sashome,...

...utting 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") ) The return message is: SAS failed. SAS program at C:\DOCUME~1\CAMERO~1.GUE\LOCALS~1\Temp\Rtmp17498\file11436.sas The log file will be file11436.log in the current directory Warning message: SAS return code was 2 in: read.ssd(file.path("G:/DATA/Cam/...

...and then assign them as the column names of the returned data.frames, but that seems to be more effort than its worth. read.ssd <- function(libname, sectionnames, tmpXport = tempfile(), tmpProgLoc = tempfile(), sascmd = "sas"){ tmpFiles <- tmpXport on.exit(unlink(tmpFiles)) logGuess <- function(x){ expl <- strsplit(x, "")[[1]] rex <- rev(expl) br <- match("/", rex)[1] if(is.na(br)) return(x) return(paste(rev(rex[1:(br - 1)]), sep = &qu...

...ting 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, "sas.exe")) but R responds with: SAS failed. SAS program at C:\DOCUME~1\DSONNE~1\LOCALS~1\Temp\Rtmp3540\file16169.sas The log file will be file16169.log in the current directory Warning message: SAS return code was 2 in: read.ssd(file.path(sashome), "pcb&qu...

...;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 Settings/Desktop","test",sascmd="C:/Program Files/SAS/SASFoundation/9.2/sas.exe") SAS failed. SAS program at C:\DOCUME~1\LOCALS~1\Temp\Rtmp08209e\file65b5504.sas The log file will be file65b5504.log in the current directory Warning message: In read.ssd("C:/Documents and Settings/Desktop", "test"...

...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 file will be file3d6c4ae1.log in the current directory NULL Warning messages: 1: In system(paste(sascmd, tmpProg)) : "sas" n?o encontrado 2: In read.ssd("X:\\users\\Anresc07", "que0411.sas7bdat") : SAS return code was -1 > Do you know what i can do to solve that? Thanks a lot! Best regards, Atenciosamente, Leandro Lins Marino Centro de Avalia??o Funda??o CES...

...mat > ?read.ssd > fadata2 <- read.ssd("D:\\CES Analysis\\Data", "fadata") SAS failed. SAS program at D:\DOCUME~1\re06572\LOCALS~1\Temp\RtmpLqCVUx\file72ae2cd6.sas The log file will be file72ae2cd6.log in the current directory Warning messages: 1: In system(paste(sascmd, tmpProg)) : "sas" not found 2: In read.ssd("D:\\CES Analysis\\Data", "fadata") : SAS return code was -1 > sashome <- "C:\\Program Files\\SAS\\SAS 9.1" > fadata2 <- read.ssd(file.path(sashome, "core", "sashelp"), "fa...

Hello everybody, I would like to read a SAS Data data1.sas7bdat in R! Is this possible? Thank you a lot in advance ;), Stefo

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

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 I changed "retail" to a different sas dataset in the same directory, I received the following message: SAS failed. SAS program at C:\Users\wuj12\AppData\Local\Temp\RtmpoSwBE7\file542...

...I get an error message “SAS failed”. I believe I have specified the paths correctly (after reading some previous posts I made sure that I do it right). Below is the small code: sashome<- "C:/Program Files/SAS/SAS 9.1" read.ssd(libname="R:/", sectionnames="test", sascmd=file.path(sashome, "sas.exe")) Please let me know where I am making the mistake. Is it because of the size of the file or the location of the file (in server instead of local hard drive)? Thanks in advance, Santanu -- -------------------------------------------------------------...

...t 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 = "sasSmallDataset", formats = FALSE, sasprog = path2sas, keep.log = TRUE) where path2data is the directory on which is contained the file sas, sasSmallDataset.sas7bdat are the data and path2sas is the path to SAS (C:/Programmi/SAS/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.

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

Sorry to write twice in one day--I am a relative newbie to some of these parts of R, and I am pulling my hair out! B/c I am preparing a file to use WINBUGS I am cross-posting to the BUGS group as well, in case anyone there has some ideas on this. I've got a large SAS dataset that I want to put in R form to more easily use the file with the hierarchical modeling software WINBUGS. It has