Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Read data from Qlikview in to sas

Hi guys!

I have a QVX data file like that

Capture.PNG

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!

3 Replies
marcus_sommer

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

Not applicable
Author

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 !

marcus_sommer

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

- Marcus