Help using Base SAS procedures

Stored Process code to create spark Table

Reply
Contributor
Posts: 44

Stored Process code to create spark Table

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:-

Spark Table Screenshot.jpg

Regards,

Swapna

SAS Super FREQ
Posts: 8,866

Re: Stored Process code to create spark Table

Posted in reply to SwapnaKumari

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

SAS Employee
Posts: 982

Re: Stored Process code to create spark Table

Posted in reply to SwapnaKumari

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:

example14.png

Ask a Question
Discussion stats
  • 2 replies
  • 268 views
  • 0 likes
  • 3 in conversation