Hi All,
I have a column which has a Image URL. I would like to write a SAS Stored Process which will give me the actual image from the corresponding Image URL in a new column "Image". Is this feasible in SAS Stored Process?
Thanks in advance!!!
Does your database support storing images in a column? AFAIK SAS does not natively but many DBs support this option.
Hi Reeza,
I have the image URLs stored in Netezza DB. It allows storing of URLs in columns
@ankitshah_15 wrote:
Hi Reeza,
I have the image URLs stored in Netezza DB. It allows storing of URLs in columns
Unless I'm mistaken, your question seems like you're asking to store the image, not the image URL? Does Netezza support image type columns?
If that's incorrect, what are you trying to do?
Using PROC HTTP to retrieve the image seems to be the correct answer.
Use DATA step code to get the desired URL from the Netezza database, store it in a global macro variable, and then use that macro variable in the URL option of PROC HTTP.
Vince DelGobbo
SAS R&D
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.
Ready to level-up your skills? Choose your own adventure.