Re: [R] SAS to R - if you don't have a SAS license

From: Frank E Harrell Jr <>
Date: Fri, 28 Dec 2007 12:06:04 -0600

Marc Schwartz wrote:
> On Fri, 2007-12-28 at 11:21 -0600, Frank E Harrell Jr wrote:

>> Wensui Liu wrote:
>>> while I move data between SAS and R all the time, personally I don't
>>> think your recommendation is very practical. Instead, I feel SAS
>>> transport file is much better than csv.
>>> Plus, the sas dataset created on unix can't be opened by sas viewer on
>>> windows. It is even undoable if the dataset is large.
>> That's surprising.  I hoped that a "SAS Viewer" would read all formats 
>> of SAS binary files.

> <snip>
> We have had that problem here, having received both 32 and 64 bit SAS
> files from Linux and Solaris based SAS installations. The SAS System
> Viewer was largely useless for the non-Windows SAS files that we have
> had accessible to us, even though it will run quite nicely under Wine.
> We have a 32 bit RHEL based SAS install here now, as I have noted in
> prior posts. That has helped with certain aspects of SAS dataset
> generation and transfer to and from clients.
> DBMS/Copy, which also runs nicely under Wine, seems to be the only tool
> that we have so far, that can provide for something of a universal SAS
> "can opener". It will at least successfully _open_ SAS datasets
> generated on a variety of platforms, when other approaches have failed.
> However, as I have also noted in prior posts, the SAS datasets that
> DBMS/Copy generates, are not guaranteed to be able to be opened by SAS
> itself. Hence our need to install SAS here.
> Theoretically, the .sas7bdat files are supposed to be cross-platform
> compatible and I think Peter had commented on that in a prior thread on
> this subject. However, hands on experience has suggested that this
> expectation is not absolute.
> HTH,
> Marc Schwartz

I have had good success with Stat/Transfer (and its Windows version runs perfectly under Linux using wine) but haven't tested it as extensively as you've tested DBMS/Copy.


Frank E Harrell Jr   Professor and Chair           School of Medicine
                      Department of Biostatistics   Vanderbilt University

______________________________________________ mailing list
PLEASE do read the posting guide
and provide commented, minimal, self-contained, reproducible code.
Received on Fri 28 Dec 2007 - 18:09:13 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Fri 28 Dec 2007 - 18:30:20 GMT.

Mailing list information is available at Please read the posting guide before posting to the list.