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

[Pooja2]

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.

[SASKiwi]

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.

[ChrisNZ]

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.