[R] sas.get problem

[John Kane]

--- Cody_Hamilton at Edwards.com wrote:

> 
> John,
> 
> Do you not have sas on your machine? (That would
> definitely keep sas.get
> from executing.)
> 
> Regards,
>    -Cody

No I don't have SAS on my machine. Nobody in my group
uses it and we seldom use SPSS. I think one person has
STATA. Most of the work is more policy than data work
and the occasional spreadsheet (shudder) does for
basic work. 

I am too cheap to have us spend a huge amount (well,
large amount anyway) for something that  I am likely
to use for 5-10 minutes a year. The last time I wanted
a SPSS file exported to "delimited" I just asked
someone in another department whom I knew has it on
his labtop to do it. 

I just hike across campus to the nearest lab with SAS,
SPSS etc installed. Done occasionally and in decent
weather it is not a problem. Today it is turning into
a marathon but I need to lose some weight.
                                            
>                       
>              John Kane                              
>                       
>              <jrkrideau at yahoo.                      
>                       
>              ca>                                    
>                    To 
>                                       
> Cody_Hamilton at Edwards.com           
>              04/11/2007 10:56                       
>                    cc 
>              AM                        R R-help
> <r-help at stat.math.ethz.ch> 
>                                                     
>               Subject 
>                                        Re: [R]
> sas.get problem             
>                                                     
>                       
>                                                     
>                       
>                                                     
>                       
>                                                     
>                       
>                                                     
>                       
>                                                     
>                       
> 
> 
> 
> 
> 
> --- Cody_Hamilton at Edwards.com wrote:
> 
> >
> > 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.
> 
> I looked at that about 4 times and did not see it.
> Thanks. That  is probably the major problem I am
> having getting the files to load in SAS. I knew it
> was
> a format problem but since the format worked with
> SPSS
> I didn't think of that.
> 
> 
> >
> > 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?
> 
> That's a Cut & Paste problem but thanks for catching
> it.
> 
> Well time to finish lunch and hike back to the
> computer lab.  I'm beginning to regret being to
> cheap
> to ask for an SAS licence :(
> 
> I may get this running today after all.  I really
> don't want to do a SAS > SPSS > R route.  It is a
> bit
> too much like a Rube Goldbeg cartoon.
> 
> Thanks
> 
> >
> > Regards,
> >     -Cody
> >
> >
> >
> >
> >
> >              John Kane
> >
> >              <jrkrideau at yahoo.
> >
> >              ca>
> >                    To
> >              Sent by:
> > tchur at optusnet.com.au
> >              r-help-bounces at st
> >                    cc
> >              at.math.ethz.ch           R R-help
> > <r-help at stat.math.ethz.ch>
> >
> >               Subject
> >                                        Re: [R]
> > sas.get problem
> >              04/11/2007 07:41
> >
> >              AM
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > --- Tim Churches <tchur at optushome.com.au> 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,
> 
=== message truncated ===