cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
ledaiduongvnth
‎06-23-2017
  • 3 Posts
  • 4 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Read data from Qlikview into sas

by Fluorite | Level 6 in SAS Programming
‎06-23-2017 09:20 AM
‎06-23-2017 09:20 AM
Tom, thank so much, look at the result, i get it after using your guide, this result don't like thinks that i want to get but better then i got ! data a; infile 'C:\Users\d\Downloads\text.bin'; input len pib2. @; input charvar $varying32767. len @ ; run; i want ask you this question, can i read 1 byte instead reading 2 byte ? I tried this code but it didn't work  data a; infile 'C:\Users\d\Downloads\text.bin'; input len pib1. @; input charvar $varying127. len @ ; run; Can you explain me how determine number after 'varying'? And if you have some documents about that give me please? ... View more

Re: Read data from Qlikview into sas

by Fluorite | Level 6 in SAS Programming
‎06-23-2017 06:32 AM
‎06-23-2017 06:32 AM
Thank Sir so much for answer ! Data is in the same file, look at data i can know the rows of table are distributed sequentially and i knew that first byte in head of ech cell reference length of this cell.  i know that can save to CSV and read by sas simpler, but my main purpose is learning sas besause i want to try read binary data. If you have any idea tell me please. In attachments is raw QVX file, please look at this . ... View more

Read data from Qlikview into sas

by Fluorite | Level 6 in SAS Programming
‎06-23-2017 02:12 AM
‎06-23-2017 02:12 AM
Hi guys!   I have a qlikview data file.The file includes: -An XML formatted table header, after loading XML table header in sas system, i received some sasdatasets that describe about structure of qlikview data file, i made empty sasdataset that correcpond with structure of qlickview 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. My leader suggested using ''READING BYNARY DATA". I tried read by using statement INFILE and INPUT with ENCODING, but my implements aren't successful because very hard determine Binary Informat.   Can somebody give me suggestion ? thank so much! ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎06-23-2017 01:13 PM
Likes given to
View All
Quick links