topic Stored Process code to create spark Table in SAS Procedures

Stored Process code to create spark Table

SwapnaKumari — Thu, 18 Jun 2015 12:09:22 GMT

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

Re: Stored Process code to create spark Table

Cynthia_sas — Thu, 18 Jun 2015 17:14:23 GMT

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

Re: Stored Process code to create spark Table

GraphGuy — Tue, 23 Jun 2015 19:45:18 GMT

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: