An embedded and charset-unspecified text was scrubbed... Name: not available Url: https://stat.ethz.ch/pipermail/r-help/attachments/20050926/f80e1741/attachment.pl
reading SAS data files
2 messages · Dean Sonneborn, Brian Ripley
On Mon, 26 Sep 2005, Dean Sonneborn wrote:
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, "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", sascmd = file.path(sashome,
the SAS log file contain this:
NOTE: Copyright (c) 2002-2003 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) 9.1 (TS1M3)
Licensed to UNIV OF CA/DAVIS, Site 0029107010.
NOTE: This session is executing on the XP_PRO platform.
NOTE: SAS initialization used:
real time 0.13 seconds
cpu time 0.18 seconds
1 libname src2rd '/Program Files/SAS/SAS 9.1';
NOTE: Libref SRC2RD was successfully assigned as follows:
Engine: V9
Physical Name: C:\Program Files\SAS\SAS 9.1
2 libname rd xport 'C:\DOCUME~1\DSONNE~1\LOCALS~1\Temp\Rtmp3540\file26090';
NOTE: Libref RD was successfully assigned as follows:
Engine: XPORT
Physical Name: C:\DOCUME~1\DSONNE~1\LOCALS~1\Temp\Rtmp3540\file26090
3 proc copy in=src2rd out=rd;
4 select pcb ;
ERROR: The file SRC2RD.PCB (memtype=ALL) was not found, but appears on a SELECT statement.
ERROR: The file SRC2RD.PCB (memtype=ALL) was not found, but appears on a SELECT statement.
ERROR: The file SRC2RD.PCB (memtype=ALL) was not found, but appears on a SELECT statement.
WARNING: Input library SRC2RD is empty.
NOTE: Statements not processed because of errors noted above.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE COPY used (Total process time):
real time 0.00 seconds
cpu time 0.01 seconds
ERROR: Errors printed on page 1.
ERROR: Errors printed on page 1.
ERROR: Errors printed on page 1.
NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
NOTE: The SAS System used:
real time 0.16 seconds
cpu time 0.20 seconds
Does anyone see what I am doing incorrectly and can they offer any
suggestions about getting this to run correctly? I'm not sure where SAS
is expecting to find the data file. I have it in the default R
directory. Is this where SAS is looking for it or does it need to be
somewhere else?
I suggest you read the help file for read.ssd. You are not telling it
where the SAS files are correctly. See the extracts below and the
examples.
Usage:
read.ssd(libname, sectionnames,
tmpXport=tempfile(), tmpProgLoc=tempfile(), sascmd="sas")
Arguments:
libname: character string defining the SAS library (usually a
directory reference)
sectionnames: character vector giving member names. These are files in
the 'libname' directory. They will usually have a '.ssd0x' or
'.sas7bdat' extension, which should be omitted.
The files are not in the SAS homne directory, but the `default R
directory' (perhaps you mean the working directory?).
PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
PLEASE do!
Brian D. Ripley, ripley at stats.ox.ac.uk Professor of Applied Statistics, http://www.stats.ox.ac.uk/~ripley/ University of Oxford, Tel: +44 1865 272861 (self) 1 South Parks Road, +44 1865 272866 (PA) Oxford OX1 3TG, UK Fax: +44 1865 272595