topic Re: Pulling QlikView data into SAS in QlikView

Pulling QlikView data into SAS

zagzebski — Tue, 28 Jan 2014 21:44:26 GMT

Most of what I found in regards to SAS on this forum is pulling SAS data into QlikView.

However, is it possible for SAS to connect to QlikView in some manner. We have data in QlikView that we want to be able to run in SAS. Any suggestions?

Steve

Re: Pulling QlikView data into SAS

swuehl — Tue, 28 Jan 2014 22:02:05 GMT

Maybe export to csv from QlikView?

Re: Pulling QlikView data into SAS

jaimeaguilar — Tue, 28 Jan 2014 22:04:02 GMT

Hi,

I think the easiest way to get data generated by QlikView into SAS would be:

To export tables via script (eg: STORE TABLE INTO table.txt) or
Generating a straight table then double click and then saving the straight table into any of the available formats.

Otherwise, I don't think there's a way to connect directly to qvw without having to develop an interface,

regards

Re: Pulling QlikView data into SAS

zagzebski — Wed, 29 Jan 2014 14:21:51 GMT

Thanks - struggling because the download we need is huge - pretty difficult for txt file and a straight table would be impossible as we are talking millions of lines.

Re: Pulling QlikView data into SAS

jaimeaguilar — Thu, 30 Jan 2014 16:07:12 GMT

You can also split txt files per year, month or with any other field, so your txt won't be that huge