DATA Step, Macro, Functions and more

Import image from Excel and load into SAS dataset

Reply
Contributor
Posts: 35

Import image from Excel and load into SAS dataset

I have excel file as source, in this .xls file have many line graph with heading , I am able to read heading which available in cell (using proc import ) but I am not able to read graph . I want to know below that two task possible in SAS or not .

  1. Can we read graph from excel file ( see example in attachment )

2> If we can read image from excel file than is it possible to load this image in SAS dataset.

 

Your earliest response is very much appreciated

 


load image from excel file.png
Super User
Super User
Posts: 7,988

Re: Import image from Excel and load into SAS dataset

Posted in reply to anandsasbi

Well, it is possible to save the graph to a separate file and then read in the pixels, given time it may even be possible to work out the data from that.  However this would take a large amount of effort and time for very little benefit.  Go back to the source data, that is the only reliable and practical method.

Ask a Question
Discussion stats
  • 1 reply
  • 115 views
  • 0 likes
  • 2 in conversation