Stored Process code to create spark Table

[SwapnaKumari]

Hi All,

I am having requirement to create spark table using base SAS. I am aware of creating spark line graph using sgplot, but I don need that as I have the requiremnt to create speakline in a table, as I need to show some varibales in the table with sparkline. Please find the screenshot of the expected output below:-

Regards,

Swapna

[Cynthia_sas]

Hi:

  The general approach to this is to make the separate image files for each country or category. But then. you use a style override in PROC PRINT or PROC REPORT to insert the image into the table.

  See these papers by Paul Oldenkamp http://www2.sas.com/proceedings/forum2008/262-2008.pdf and

    Louise Hadden and her example http://support.sas.com/resources/papers/proceedings13/212-2013.pdf of a graph in a table on page 9.

  I recommend that you get the program working first before you turn this into a stored process.

.cynthia

[GraphGuy]

I describe one way to do this in my book "SAS/Graph: Beyond the Basics" (Example 14).

Here is the code used in that example:

http://robslink.com/SAS/book/example14.sas

And here is an example of what the output looks like: