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

[raffiebr]

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 [email protected]

=====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 [email protected]

=====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 [email protected]

=====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 [email protected]

---

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]

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- [email protected] 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 [email protected]

=====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 [email protected]

=====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 [email protected]

=====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 [email protected]

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]

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]

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- [email protected] 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]

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

• checking for file 'C:\Users\5098678\AppData\Local\Temp\RtmpKsNQlZ\devtools1a1c6d923a6\sas7bdat-master/DESCRIPTION' ... OK
• preparing 'sas7bdat':
• checking DESCRIPTION meta-information ... OK
• checking for LF line-endings in source and make files
• checking for empty or unneeded directories
• looking to see if a 'data/datalist' file should be added
• building 'sas7bdat_0.4.tar.gz'

"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

• installing source package 'sas7bdat' ... ** R ** data ** preparing package for lazy loading ** help *** installing help indices ** building package indices ** installing vignettes ** testing if installed package can be loaded *** arch - i386 *** arch - x64
• DONE (sas7bdat)

---

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

• checking for file '/tmp/RtmpN6Yam3/devtools45aa4b2f88c4/sas7bdat-master/DESCRIPTION' ... OK
• preparing 'sas7bdat':
• checking DESCRIPTION meta-information ... OK
• installing the package to build vignettes
• creating vignettes ... OK
• checking for LF line-endings in source and make files
• checking for empty or unneeded directories
• looking to see if a 'data/datalist' file should be added
• building 'sas7bdat_0.4.tar.gz'

'/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

• installing source package 'sas7bdat' ... ** R ** data ** inst ** preparing package for lazy loading ** help *** installing help indices converting help for package 'sas7bdat' finding HTML links ... done read.sas7bdat html
  sas7bdat.sources html
  ** building package indices ** installing vignettes ** testing if installed package can be loaded
• DONE (sas7bdat)

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]

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.

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

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

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

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

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]

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- [email protected] 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.

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

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

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

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

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 .