topic Re: how to load data from SAS EG to DataFlux in SAS Data Management

how to load data from SAS EG to DataFlux

margautz — Thu, 07 Apr 2016 15:59:50 GMT

Hello,

is it possible to import an EG project to DataFlux?

I created a subset of data using EG and I would like to use it in DataFlux. I exported the results as cvs file (as step in the project) and then I load it in DataFLux, but...I am wondering if there is a better solution, also to refresh the query made in EG directly form DataFlux.

Thank you for your time.

Re: how to load data from SAS EG to DataFlux

SASKiwi — Thu, 07 Apr 2016 19:42:15 GMT

Dataflux can read a SAS dataset directly. I don't have access to it at the moment so I can't check for you but I suspect you can import it using ODBC.

Re: how to load data from SAS EG to DataFlux

RonAgresta — Fri, 08 Apr 2016 11:53:29 GMT

Hi,

You do have options to read SAS datasets from within DataFlux Data Management Studio. You can set up a data connection to the SAS data or you can use a process job to execute SAS code. There is no way to have Data Management Studio interact directly with your EG project.

Ron

Re: how to load data from SAS EG to DataFlux

margautz — Mon, 11 Apr 2016 13:28:23 GMT

Thank you

Re: how to load data from SAS EG to DataFlux

margautz — Mon, 11 Apr 2016 13:29:30 GMT

Thank you, I have just to wait the admin right to set up the odbc connection and then I will test it!