topic Re: Read data from Qlikview in to sas in QlikView

Read data from Qlikview in to sas

Wed, 25 Nov 2020 16:16:04 GMT

Hi guys!

I have a QVX data file like that

The file includes:

-An XML formatted table header, after loading XML table header in SAS SYSTEM, i received some SAS datasets that describe about structure of QVX data file, i made empty SAS dataset that correspond with structure of QVX data file.

-The actual data like that: " à@ à@ à@ @ ÁZ¦EÀ ÁZ¦EÀÁZ¦EÀ ", but i don't know what is format data is stored in?

Now i need load actual data into this empty sasdataset, but i don't know how can i do. I tried using ''READING BYNARY DATA" with using statement INFILE and INPUT, but my implements aren't successful because very hard determine Binary Informat.

Can somebody give me suggestion ? thank so much!

Re: Read data from Qlikview in to sas

marcus_sommer — Fri, 23 Jun 2017 17:44:53 GMT

Why not just storing the data as csv-file and loading this into your SAS? And I could imagine that a csv-load would be faster as the QVX.

- Marcus

Re: Read data from Qlikview in to sas

Fri, 23 Jun 2017 19:02:03 GMT

Thank sir !

i know storing as a csv file and loading this in to sas is easier way but my leader don't accept me doing by this way because i am student and now i am studying SAS.

Main question is what is format data is stored in?

if you know answer me please !

Re: Read data from Qlikview in to sas

marcus_sommer — Sat, 24 Jun 2017 05:23:53 GMT

Maybe this is helpful for you: https://community.qlik.com/search.jspa?q=qvx&type=document

- Marcus