I am trying to load a table from sybase that contains a large blob of data in hex format. The problem I'm running into is that the blob is 2147483647 characters long and SAS can only handle some 32K characters at a time.
I'm in the middle of trying to understand the structure of the data inside the blob which is not just numbers but first I need to be able to load the data
PS the table contains 44K rows that I have to read
any suggestions?
If you divide your blob size by 32K, then you will find that if you were able to deconstruct your BLOB into 32K chunks then this would take 67K SAS variables to store!
I suggest you ask your Sybase DBA to find out if Sybase has any functionality to deconstruct BLOBs into something of more reasonable size before reading it with SAS.
Alternatively get Sybase to write this data out to a flat file, then use SAS DATA step processing to read the data in 32K chunks and decipher it on the fly into SAS variables.
I would also ask some veriation on "what is that thing?" If it is an image, audio file, executable or similar object then it may not be at all useable split in any way SAS would like it.
Aggree with @ballardw.
What is your requirement? Chances are that you can't find any useful information there, especially if you don't know at this point what is is...
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.