Pulling QlikView data into SAS

[zagzebski]

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

[swuehl]

Maybe export to csv from QlikView?

[jaimeaguilar · Accepted solution]

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

[zagzebski]

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.

[jaimeaguilar]

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