topic Re: sas import an image from a website and export that to an excel sheet in SAS Programming

sas import an image from a website and export that to an excel sheet

Pooja2 — Thu, 16 Apr 2020 19:54:34 GMT

Hi,

I am working on a project where I need to import graphs from a website (one webpage has one graph) and then export that to an excel sheet with some specifications. I have never done that kind of stuff. I need someone to help me with this.

Thanks in advance.

Re: sas import an image from a website and export that to an excel sheet

SASKiwi — Thu, 16 Apr 2020 20:49:53 GMT

Graphs on a website would have to be processed as images and SAS 9.* doesn't do image processing. SAS Viya does image analytics but I suspect that is not what you want.

A quick and dirty solution would be to do manual screenshots and paste them into Excel. No SAS required.

Re: sas import an image from a website and export that to an excel sheet

ChrisNZ — Fri, 17 Apr 2020 11:25:31 GMT

I have never needed this but I believe that you can:

- download the html page

- analyse the page to find the image's URL

- download the image file

Then you *may* be able to insert it in excel, for example by using the ODS PREIMAGE= option.

You can probably find vbs scripts on the web that do what you want, and which would be better suited.