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,


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. 






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.




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.

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