Hi All,
Is it possible to extract the BLOB (Binary large objects) data from database (DB2/ORACLE/POSTGRES) and convert it into the actual file either it is pdf/excel/word or jpg using SAS Code?
I have tried to write the code and I am able to extract the BLOB into actual file where the BLOB length is less than 32767 however for some records the length is greater than 3L so in those cases i have created multiple variables of max length that SAS supports and concatenated these variables while writting to the output file stream. Still the file generated as corrupt.
If anyone of you had faced the similar kind of issue and got the solution already please provide your inputs it will be very helpful.
Thanks and Regards,
Darshan Saini
Can you transform BLOB into Character type column and import SAS ?
In that case also SAS can accept maximum 32767 length only for a variable. I have tried that approach earlier however when I am concatenating the variables and setting to file there it seems to have some problem and the actual file is not getting generated.
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.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.