--- Frank E Harrell Jr <f.harrell@(protected)>
wrote:
> John Kane wrote:
> > --- Cody_Hamilton@(protected):
> >> 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.
> >
> > Current state of play:
> > Files : SAS 9.x
> >
> > formea1.sas7bdat
> > formea2.sas7bdat
> > formats.sas7bcat
> >
> > I notice that the formats.sas7bcat is drastically
> > different from the sas.bdat
> > icons.
> >
> > We seem to be making some progress even if the
> data
> > file still has not loaded.
> >
> > In the ammended sas.get condition I get an error
> > object ".R." not found.
> > I hope this is not an Hmisc object.
>
> It is. You need library(Hmisc) in effect before
> using sas.get.
>
> The system output error will be fixed in an upcoming
> release of Hmisc.
>
> Frank
>
Just as I feared! Oh well I can still do the SAS >
SPSS > R routine or use Marc's suggetion to export a
csv file.
Thanks for the confirmation. I strongly suspected that
.R. was Hmisc.
> >
> > Thanks
> >
> >
> > Run with Hmisc
> >
> > mydata <- sas.get(library="F:/sas", mem="formea1",
> > format.library="F:/sas",
> > sasprog = '"C:Program Files/SAS/SAS
> 9.1/sas.exe"')
> >
> > Error in sas.get(library = "F:/sas", mem =
> "formea1",
> > format.library = "F:/sas", :
> > SAS job failed with status -1
> > In addition: Warning message:
> > "\"C:Program not found
> >
> >
> > Run with modified sas.get (Hmisc not loaded)
> >
> > Error in sas.get(library = "F:/sas", mem =
> "formea1",
> > format.library = "F:/sas", :
> > object ".R." 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
>
> >>
> >> <jrkrideau@(protected).
>
> >>
> >> ca>
>
> >> To
> >> Sent by:
> >> tchur@(protected)
> >> r-help-bounces@(protected)
>
> >> cc
> >> at.math.ethz.ch R R-help
> >> <r-help@(protected)>
> >>
>
> >> Subject
> >> Re: [R]
> >> sas.get problem
> >> 04/11/2007 07:41
>
> >>
> >> AM
>
> >>
> >>
>
> >>
> >>
>
> >>
> >>
>
> >>
> >>
>
> >>
> >>
> >>
> >>
> >>
> >>
> >> --- Tim Churches <tchur@(protected):
> >>
> >>> 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.
>
=== message truncated ===
______________________________________________
R-help@(protected)
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.
