John,
I believe the format file must have a .sc or .sas7bcat file extension (not
.sas7bdat which is a sas dataset extension). I think that's why you're
getting the error F:/sas/formats.sc? or formats.sas7bcat not found.
Also, is the carriage return after '"C:/Program in the code below caused
by copying and pasting into the email or is the code that way in your
program?
Regards,
-Cody
John Kane
<[EMAIL PROTECTED]
ca> To
Sent by: [EMAIL PROTECTED]
[EMAIL PROTECTED] cc
at.math.ethz.ch R R-help <r-help@stat.math.ethz.ch>
Subject
Re: [R] sas.get problem
04/11/2007 07:41
AM
--- Tim Churches <[EMAIL PROTECTED]> wrote:
> John Kane wrote:
> > I have 3 SAS files all in the directory F:/sas,
> two
> > data files
> > and a format file :
> > form.ea1.sas7bdat
> > form.ea2.sas7bdat
> > sas.fmts.sas7bdat
> >
> > F is a USB.
> > I am using R2.4.1 under Windows XP
> > SAS files were created with SAS 9.x
> > They convert easily into SPSS 14
> > Example.
> >
> > library(Hmisc)
> > mydata <- sas.get(library="F:/sas",
> mem="form.ea1",
> > format.library="sas.fmts.sas7bdat",
> > sasprog = '"C:Program Files/SAS/SAS
> > 9.1/sas.exe"')
> >
> > Error message (one of several that I have gotten
> > while trying various things.)
> > The filename, directory name, or volume label
> syntax
> > is incorrect.
> > Error in sas.get(library = "F:/sas", mem =
> "form.ea1",
> > format.library = "sas.fmts.sas7bdat", :
> > SAS job failed with status 1
> > In addition: Warning messages:
> > 1: sas.fmts.sas7bdat/formats.sc? or
> formats.sas7bcat
> > not found. Formatting ignored.
> > in: sas.get(library = "F:/sas", mem = "form.ea1",
> > format.library = "sas.fmts.sas7bdat",
> > 2: 'cmd' execution failed with error code 1 in:
> > shell(cmd, wait = TRUE, intern = output)
>
> The sas.get function in the Hmisc library is broken
> under Windows.
>
> Change line 127 from:
>
> status <- sys(paste(shQuote(sasprog),
> shQuote(sasin), "-log",
> shQuote(log.file)), output = FALSE)
>
> to:
>
> status <- system(paste(shQuote(sasprog),
> shQuote(sasin), "-log",
> shQuote(log.file)))
>
> Tim C
Thanks Tim,
How do I make this change? I naively have tried by
a) list sas.get and copy to editor
b) reload R without loading Hmisc
c) made recommended changes to sas.get
d) stuck a "sas.get <- " in front of the function and
ran it.
R returns the same error messages. I have also
corrected the typo in sasprog and done some renaming
following Cody's suggestions.
Currently I have:
formea1.sas7bdat
formea2.sas7bdat
formats.sas7bdat
detach("package:Hmisc")
mydata <- sas.get(library="F:/sas", mem="formea1",
format.library="F:/sas",
sasprog = '"C:/Program
Files/SAS/SAS9.1/sas.exe"')
RESULTS
Error in sas.get(library = "F:/sas", mem = "formea1",
format.library = "F:/sas", :
SAS job failed with status -1
In addition: Warning messages:
1: F:/sas/formats.sc? or formats.sas7bcat not found.
Formatting ignored.
in: sas.get(library = "F:/sas", mem = "formea1",
format.library = "F:/sas",
2: "\"C:/Program not found
---------------------------------
I really don't see why the sagprog does not work
unless an early error is falling through.
Thanks for all the help
______________________________________________
R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide
http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
______________________________________________
R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
