topic Re: How to add sparklines to a dataset in SAS in SAS Enterprise Guide

How to add sparklines to a dataset in SAS

Programmer26 — Thu, 27 May 2021 18:00:58 GMT

Hi All,

I am working on a project where i have to generate sparklines in the final before attaching the file in a sas e-mail.
My final output is something like

Id name num1 num2 num3 %_num
1 abc. $200. $300. $400. 70%
I have to add sparklines to this output on the basis of num1 num2 num3.
I am using ods excel and proc report to export the file to desired destination and i am not sure how will i incorporate sparklines to my existing code.
I searched for references and found a few sgplot examples but i am unable to take any advantage from those examples.

I would appreciate if any of you could help me out here.

Thank you in advance

Re: How to add sparklines to a dataset in SAS

Reeza — Thu, 27 May 2021 18:17:03 GMT

https://support.sas.com/resources/papers/proceedings12/084-2012.pdf

Re: How to add sparklines to a dataset in SAS

Programmer26 — Thu, 27 May 2021 19:33:33 GMT

Thanks for the reference.
It involves using sas and vba to create sparklines, however the excel that i am creating using ods excel and proc report and then has to be sent as a attachment via sas automated email.
So, i am not sure if that paper will be helpful to me or not.

Re: How to add sparklines to a dataset in SAS

Reeza — Thu, 27 May 2021 19:45:37 GMT

Guess you won't know unless you try.

Do you need your sparklines to be images or embedded in Excel as Excel graphics?

If you need Excel you'll need something like the solution above.
If you can have just a graphic, then something like this may work: https://blogs.sas.com/content/graphicallyspeaking/2017/11/14/spark-table/