Re: [R] Reading sas7bdat files directly

2010-11-26 Thread Ted
Just wondering if the proposed loop for the metadata on this conversion was implemented by any chance...before I go trying the Long routine... -- View this message in context: http://r.789695.n4.nabble.com/Reading-sas7bdat-files-directly-tp1469515p3060319.html Sent from the R help mailing list

Re: [R] Reading sas7bdat files directly

2010-03-02 Thread Chris Long
The dsread output is little-endian, as that's the native format for floats on the Wintel platform. The byte order should stay the same if converting directly to a float, using a data structure like (C/C++): union { char bytes[8]; double value; } If reading the values with a SAS HEX

Re: [R] Reading sas7bdat files directly

2010-03-01 Thread Chris Long
dsread (http://www.oview.co.uk/dsread) was updated yesterday, to include various new features as suggested here and elsewhere. Of particular interest might be: - you can now use the /c and /v options together to get dataset contents in CSV format for easier importing; - there is now a /l

Re: [R] Reading sas7bdat files directly

2010-03-01 Thread Roger DeAngelis(xlr82sas)
Hi All, The hack below might help R users get going with Chris's DSREAD. I have not had a chance to look at Monday's version of DSREAD, can't wait. Note Duncan Murdoch was most gracious to supply me with a R function to translate floats in 16 char hex to R floats. Your utility solves the 200

Re: [R] Reading sas7bdat files directly

2010-03-01 Thread Nordlund, Dan (DSHS/RDA)
-Original Message- From: r-help-boun...@r-project.org [mailto:r-help-boun...@r-project.org] On Behalf Of Roger DeAngelis(xlr82sas) Sent: Monday, March 01, 2010 4:38 PM To: r-help@r-project.org Subject: Re: [R] Reading sas7bdat files directly Hi All, The hack below might help

Re: [R] Reading sas7bdat files directly

2010-03-01 Thread Roger DeAngelis(xlr82sas)
Hi, It looks like we may need to swap bytes(little endian to big endian). I will look into it tonight. As a side note, SAS reserves 28 floats for missing values. It should be easy to convert these to NaN on input to R. You can test this in SAS by converting the 16 char floats to ieee8. in

Re: [R] Reading sas7bdat files directly

2010-02-24 Thread Chris Long
I suppose a link would have added usefulness: http://www.oview.co.uk/dsread Chris. -- View this message in context: http://n4.nabble.com/Reading-sas7bdat-files-directly-tp1469515p1567256.html Sent from the R help mailing list archive at Nabble.com.

Re: [R] Reading sas7bdat files directly

2010-02-24 Thread Frank E Harrell Jr
Chris Long wrote: I suppose a link would have added usefulness: http://www.oview.co.uk/dsread Chris. As dsread seems to work perfectly under wine on Ubuntu linux (and quite quickly), it could be quite valuable to many of us. Thanks for posting this and for developing dsread! If time

Re: [R] Reading sas7bdat files directly

2010-02-24 Thread Chris Long
No problem, Frank, I'm glad that you think it will be useful. I will be making changes to dsread in the coming weeks so you may want to hold off with your helper function in case my changes break it (the formatting of the variable metadata listing may well change). Re: the metadata, feel free

Re: [R] Reading sas7bdat files directly

2010-02-24 Thread Frank E Harrell Jr
Chris Long wrote: No problem, Frank, I'm glad that you think it will be useful. I will be making changes to dsread in the coming weeks so you may want to hold off with your helper function in case my changes break it (the formatting of the variable metadata listing may well change). Re: the

Re: [R] Reading sas7bdat files directly

2010-02-16 Thread Annoyia Mouse
If you don't have SAS and still need to read or write sas7bdat files: there is the World Programming System (WPS) (commercial software). http://www.teamwpc.co.uk/home/ -- View this message in context: http://n4.nabble.com/Reading-sas7bdat-files-directly-tp1469515p1557807.html Sent from the R

[R] Reading sas7bdat files directly

2010-02-04 Thread Alex Bryant
Hi, I have a need to process (in real-time) a large number of .sas7bdat files from within R. The problem is I don't want to convert these files to .xpt (transport) every time. So just checking if anyone has a (viable) way to read .sas7bdat files directly into R? Thank You.

Re: [R] Reading sas7bdat files directly

2010-02-04 Thread Jorge Ivan Velez
Hi Alex, Perhaps the read.ssd function in the foreign package might do what you want. See [1] for details. HTH, Jorge [1] http://cran.r-project.org/web/packages/foreign/index.html http://cran.r-project.org/web/packages/foreign/index.html On Thu, Feb 4, 2010 at 5:31 PM, Alex Bryant wrote:

Re: [R] Reading sas7bdat files directly

2010-02-04 Thread Duncan Murdoch
Alex Bryant wrote: Hi, I have a need to process (in real-time) a large number of .sas7bdat files from within R. The problem is I don't want to convert these files to .xpt (transport) every time. So just checking if anyone has a (viable) way to read .sas7bdat files directly into R? SAS

Re: [R] Reading sas7bdat files directly

2010-02-04 Thread David Winsemius
On Feb 4, 2010, at 5:31 PM, Alex Bryant wrote: Hi, I have a need to process (in real-time) a large number of .sas7bdat files from within R. The problem is I don't want to convert these files to .xpt (transport) every time. So just checking if anyone has a (viable) way to read

Re: [R] Reading sas7bdat files directly

2010-02-04 Thread Frank E Harrell Jr
David Winsemius wrote: On Feb 4, 2010, at 5:31 PM, Alex Bryant wrote: Hi, I have a need to process (in real-time) a large number of .sas7bdat files from within R. The problem is I don't want to convert these files to .xpt (transport) every time. So just checking if anyone has a (viable)