search

BioStatMatt / sas7bdat

A reverse engineering of the sas7bdat database file format
83 stars 21 forks source link

Error when reading sas7bdat files in RStudio hosted in Linux Redhat server #4

Open raffiebr opened 10 years ago

raffiebr commented 10 years ago

Hi Matt,

I keep getting errors when trying to read a sas7bdat file in R studio. My R studio is running on a Linux Redhat Server. I've tried to install the different versions of the sas7bdat package.

====Installed the 0.1 version=====

install.packages("~/sas7bdat_0.1.tar.gz", repos = NULL, type ="source") installation successful library(sas7bdat) read.sas7bdat("{file}")

Error in read.sas7bdat("{file}") :unknown host 9.0301M2 please report bugs to sas7bdatRbugs@gmail.com

=====Installed the 0.2 version (http://biostatmatt.com/archives/1712)======

install.packages("~/sas7bdat_0.2.tar.gz", repos = NULL, type = "source") installation successful library(sas7bdat) read.sas7bdat("{file}")

Error in read.sas7bdat("{file}") : unknown host 01M2Linu please report bugs to sas7bdatRbugs@gmail.com

=====Installed the 0.3 version (from cran)=====

install.packages("~/sas7bdat_0.3.tar.gz", repos = NULL, type = "source") installation successful library(sas7bdat) read.sas7bdat("{file}")

found 0 row size subheaders where 1 expected please report bugs to sas7bdatRbugs@gmail.com

=====Installed latest version from Github=====

install_github("sas7bdat","BioStatMatt") installation successful library(sas7bdat) read.sas7bdat("{file}") Error in read.sas7bdat("{file}") : unknown host 01M2Linu please report bugs to sas7bdatRbugs@gmail.com

I tried reading the same file in windows and it works fine. Could it be because the sas7bdat package is not compatible with linux redhat?

Regards, Raffie

BioStatMatt commented 10 years ago

Looks like you were testing two different files. We still can't read all types of sas7bdat files... Compressed or encrypted files. The platform running the read.sas7bdat code shouldn't matter (because it's all R code). The platform used to write the file does matter.

On Dec 25, 2013, at 9:34 PM, raffie- notifications@github.com wrote:

Hi Matt,

I keep getting errors when trying to read a sas7bdat file in R studio. My R studio is running on a Linux Redhat Server. I've tried to install the different versions of the sas7bdat package.

====Installed the 0.1 version=====

install.packages("~/sas7bdat_0.1.tar.gz", repos = NULL, type ="source") installation successful library(sas7bdat) read.sas7bdat("{file}")

Error in read.sas7bdat("{file}") :unknown host 9.0301M2 please report bugs to sas7bdatRbugs@gmail.com

=====Installed the 0.2 version (http://biostatmatt.com/archives/1712)======

install.packages("~/sas7bdat_0.2.tar.gz", repos = NULL, type = "source") installation successful library(sas7bdat) read.sas7bdat("{file}")

Error in read.sas7bdat("{file}") : unknown host 01M2Linu please report bugs to sas7bdatRbugs@gmail.com

=====Installed the 0.3 version (from cran)=====

install.packages("~/sas7bdat_0.3.tar.gz", repos = NULL, type = "source") installation successful library(sas7bdat) read.sas7bdat("{file}")

found 0 row size subheaders where 1 expected please report bugs to sas7bdatRbugs@gmail.com

=====Installed latest version from Github=====

install_github("sas7bdat","BioStatMatt") installation successful library(sas7bdat) read.sas7bdat("{file}") Error in read.sas7bdat("{file}") : unknown host 01M2Linu please report bugs to sas7bdatRbugs@gmail.com

I tried reading the same file in windows and it works fine. Could it be because the sas7bdat package is not compatible with linux redhat?

Regards, Raffie

— Reply to this email directly or view it on GitHub.

raffiebr commented 10 years ago

Hi Matt,

Thanks for the reply. The reason why i thought the platform running the sas7bdat package effects it's workability is because the sas7bdat files I tested were readable using the package in windows platform. For example, the file http://www.nber.org/cbsa-msa-fips-ssa-county-crosswalk/cbsatocountycrosswalk.sas7bdat shared by Florian in issue#2 can be read using sas7bdat package in windows platform. However unknown host errors will be shown when I try to read it in a Linux Redhat platform.

Recent results indicates that sas7bdat files created in windows can be read in both windows and linux, but sas7bdat files created in linux can be read in windows but not in linux.

Thanks for your time.

Raffie

BioStatMatt commented 10 years ago

That's odd. Can you verify that both installations are running the same version of the sas7bdat package?

On Mon, Dec 30, 2013 at 3:33 AM, raffie- notifications@github.com wrote:

Hi Matt,

Thanks for the reply. The reason why i thought the platform running the sas7bdat package effects it's workability is because the sas7bdat files I tested were readable using the package in windows platform. For example, the file http://www.nber.org/cbsa-msa-fips-ssa-county-crosswalk/cbsatocountycrosswalk.sas7bdatshared by Florian in issue#2 can be read using sas7bdat package in windows platform. However unknown host errors will be shown when I try to read it in a Linux Redhat server.

Thanks for your time.

Raffie

— Reply to this email directly or view it on GitHubhttps://github.com/BioStatMatt/sas7bdat/issues/4#issuecomment-31338673 .

raffiebr commented 10 years ago

Hi Matt,

For both instances (windows and linux), i installed the package using install_github("sas7bdat","BioStatMatt") command.

The logs for the installation process show different things though.

For Windows:

Installing github repo sas7bdat/master from BioStatMatt Downloading sas7bdat.zip from https://github.com/BioStatMatt/sas7bdat/archive/master.zip Installing package from C:\Users\5098678\AppData\Local\Temp\RtmpKsNQlZ/sas7bdat.zip Installing sas7bdat pdflatex not found. Not building PDF vignettes. "C:/PROGRA~1/R/R-30~1.2/bin/x64/R" --vanilla CMD build \ "C:\Users\5098678\AppData\Local\Temp\RtmpKsNQlZ\devtools1a1c6d923a6\sas7bdat-master" \ --no-manual --no-resave-data --no-vignettes

Warning: '--no-vignettes' is deprecated: use '--no-build-vignettes' instead

"C:/PROGRA~1/R/R-30~1.2/bin/x64/R" --vanilla CMD \ INSTALL \ "C:\Users\5098678\AppData\Local\Temp\RtmpKsNQlZ/sas7bdat_0.4.tar.gz" \ --library="C:/Users/5098678/Documents/R/win-library/3.0" \ --install-tests

For Linux:

Installing github repo sas7bdat/master from BioStatMatt Downloading sas7bdat.zip from https://github.com/BioStatMatt/sas7bdat/archive/master.zip Installing package from /tmp/RtmpN6Yam3/sas7bdat.zip Installing sas7bdat '/usr/lib64/R/bin/R' --vanilla CMD build '/tmp/RtmpN6Yam3/devtools45aa4b2f88c4/sas7bdat-master' --no-manual \ --no-resave-data

'/usr/lib64/R/bin/R' --vanilla CMD INSTALL '/tmp/RtmpN6Yam3/sas7bdat_0.4.tar.gz' \ --library='/home/raffie/R/x86_64-redhat-linux-gnu-library/3.0' --install-tests

I'm trying to read the file: http://www.nber.org/cbsa-msa-fips-ssa-county-crosswalk/cbsatocountycrosswalk.sas7bdat in linux, but it is showing the unknown host 01M0Linu error. However, the read.sas7bdat command works when I try to read the file in windows.

raffiebr commented 10 years ago

Hi Matt,

I've experimented the package with some sample sas7bdat files I got from "sas7bdat.sources". I tested their readability on both Linux and windows platform, using the sas7bdat package. I thought of sharing with you the failure results.

1) File URL: http://datavis.ca/gallery/guerry/maps/xfrance.sas7bdat SAS release: 9.0101M3 SAShost : Linux OS version: 2.6.8-2-686 OS name: i686 endianness: little

Result: Windows - file can be read with the package Linux - error message: unknown host Linux

2) File URL: http://datavis.ca/gallery/guerry/maps/xoutline.sas7bdat SAS release: 9.0101M3 SAShost : Linux OS version: 2.6.8-2-686 OS name: i686 endianness: little

Result: Windows - file can be read with the package Linux - error message: unknown host Linux

3) File URL: http://datavis.ca/gallery/guerry/maps/coutline.sas7bdat SAS release: 9.0101M3 SAShost : Linux OS version: 2.6.8-2-686 OS name: i686 endianness: little

Result: Windows - file can be read with the package Linux - error message: unknown host Linux

4) File URL: http://castatistics.wikispaces.com/file/view/sorted_work_panel_data_aquifer_1.sas7bdat/269439182/sorted_work_panel_data_aquifer_1.sas7bdat SAS release: 9.0301M0 SAShost : W32_7PRO OS version: not specified OS name: not specified endianness: little

Result: Windows - file can be read with the package Linux - error message: unknown host W32_7PRO

5) File URL: http://www.nber.org/cbsa-msa-fips-ssa-county-crosswalk/cbsatocountycrosswalk.sas7bdat SAS release: 9.0301M0 SAShost : LINUX OS version: 2.6.32-279.5.1.e OS name: x86_64 endianness: little

Result: Windows - file can be read with the package Linux - error message: unknown host unknown host 01M0Linu

Other than the files mentioned above, I was able to use both Linux and Windows platforms to read all sas7bdat files that were created from a Windows platform.

BioStatMatt commented 10 years ago

Raffie,

It looks like two different versions (commits) of the package were installed. Using the newest commit, I was able to read the files linked above using Debian Linux. Because the read.sas7bdat function is written entirely in R (as opposed to C, fortran, or some other 'foreign' language), the platform shouldn't matter.

Can you try again with the most recent version?

Best, Matt

On Sun, Jan 19, 2014 at 8:16 PM, raffie- notifications@github.com wrote:

Hi Matt,

I've experimented the package with some sample sas7bdat files I got from "sas7bdat.sources". I tested their readability on both Linux and windows platform, using the sas7bdat package. I thought of sharing with you the failure results.

1) File URL: http://datavis.ca/gallery/guerry/maps/xfrance.sas7bdat SAS release: 9.0101M3 SAShost : Linux OS version: 2.6.8-2-686 OS name: i686 endianness: little

Result: Windows - file can be read with the package Linux - error message: unknown host Linux

2) File URL: http://datavis.ca/gallery/guerry/maps/xoutline.sas7bdat SAS release: 9.0101M3 SAShost : Linux OS version: 2.6.8-2-686 OS name: i686 endianness: little

Result: Windows - file can be read with the package Linux - error message: unknown host Linux

3) File URL: http://datavis.ca/gallery/guerry/maps/coutline.sas7bdat SAS release: 9.0101M3 SAShost : Linux OS version: 2.6.8-2-686 OS name: i686 endianness: little

Result: Windows - file can be read with the package Linux - error message: unknown host Linux

4) File URL: http://castatistics.wikispaces.com/file/view/sorted_work_panel_data_aquifer_1.sas7bdat/269439182/sorted_work_panel_data_aquifer_1.sas7bdat SAS release: 9.0301M0 SAShost : W32_7PRO OS version: not specified OS name: not specified endianness: little

Result: Windows - file can be read with the package Linux - error message: unknown host W32_7PRO

5) File URL: http://www.nber.org/cbsa-msa-fips-ssa-county-crosswalk/cbsatocountycrosswalk.sas7bdat SAS release: 9.0301M0 SAShost : LINUX OS version: 2.6.32-279.5.1.e OS name: x86_64 endianness: little

Result: Windows - file can be read with the package Linux - error message: unknown host unknown host 01M0Linu

Other than the files mentioned above, I was able to use both Linux and Windows platforms to read all sas7bdat files that were created from a Windows platform.

— Reply to this email directly or view it on GitHubhttps://github.com/BioStatMatt/sas7bdat/issues/4#issuecomment-32730034 .