Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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