I have a dataset with multiple columns in it. One column contains the name of the metrics and the rest of them are having summary level information for those metrics on a monthly level. I want to split these month level information and then append the data again so thay i can have that monthly data appened vertically to the prior month rather than havin a horizontal view of the data. Unfortunately i cannot share the data here. But if any has any suggestions to give that would be highly appreciated. ... View more

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 ... View more

Hi all, I am working on a project where i have to generate an email through sas containing a excel as attachment and a table embedded in the email body. I am able to add the attachment but unable to embed the output in the email body. Here is how i am doing it for attachment Data _null_; From= To= Subject= Attach= Content_type ="excel" ; Email body; Run; This is what i am doing right now, need to incorporate the code to add output directly in the email body. Thank you in advance. ... View more