Read SAS7BDAT (DSREAD)

Hi,

 

I'm very new to KNIME and have been trying to read my SAS files using the Read SAS7BDAT (DSREAD) node. I've added a path and tried to run but get the following error:

Execute failed: Failed with exit code 1

 

I'd really appreciate any help :-)

 

Thanks in advance,

Jacqui

Hi Jacqui, 

I'm not sure what the problem could be but if you upload an example file that won't load, I can take a look at it for you. 

As another angle of attack, I often use the R Source nodes to read SAS files using the Foreign library from R.  I would have a look at that as well. 

Regards,

Aaron

 

 

 

I experienced the same problem with the well known sashelp.class (class.sas7bdat).

I'm using 2.9.1 on Windows 7 Home Premium 64-bit SP1. I replaced dsread.exe with the newest version but nothing changed.

Thanks for any help.

Alfredo

 

 

Hi Alfredo, 

I believe that SAS reader only works with 32-bit operating systems.  Interestingly, GGASoftware just released a GPL SAS7DBAT library for Java, so I guess that someone will write a node for KNIME using this before too long.  It looks like low hanging fruit to me. 

http://www.ggasoftware.com/opensource/parso

Until that happens, the foreign package in R is probably your best bet. 

Aaron