Data visualization with SAS programming

Graphs and Excel

Accepted Solution Solved
Reply
Contributor
Posts: 57
Accepted Solution

Graphs and Excel

Hi everybody,

Is it possible to generate graphical representations using SAS in an Excel document which can be customizable with Excel?

Thanking you in advance for your answers.

Best regards,


Accepted Solutions
Solution
‎02-20-2013 11:29 AM
Grand Advisor
Posts: 17,461

Re: Graphs and Excel

If you have specific graph types and this is worth automating then I'd look into the following option:

1. Designing Excel templates for each graph type, Kaplan Meier Curve and ROC curve for example, based on the SAS output you get from the relevant procedures.

2. Populate the templates and have those as the graphs used for providing to users.

The work is in setting up the templates initially because doing KM curves in Excel is a bit of a pain, but it depends on how often you need it.  But I hate spending hours customizing labels, thickness of lines and colours personally.

View solution in original post


All Replies
Grand Advisor
Posts: 17,461

Re: Graphs and Excel

Generally no. However there are a lot of workarounds, but you'd need to explain more of what you're trying to do.

SAS graphics are pretty good (IMO) and even better if you go down the GTL route.

Contributor
Posts: 57

Re: Graphs and Excel

Thanks for your answer Reeza.

The idea is to automatically create statistical graphs which can be edited using Excel. In this way, our users can customize themselves graphs for "details" (for instance change colors, ...) without the need of always come back to us to change SAS programs.

Solution
‎02-20-2013 11:29 AM
Grand Advisor
Posts: 17,461

Re: Graphs and Excel

If you have specific graph types and this is worth automating then I'd look into the following option:

1. Designing Excel templates for each graph type, Kaplan Meier Curve and ROC curve for example, based on the SAS output you get from the relevant procedures.

2. Populate the templates and have those as the graphs used for providing to users.

The work is in setting up the templates initially because doing KM curves in Excel is a bit of a pain, but it depends on how often you need it.  But I hate spending hours customizing labels, thickness of lines and colours personally.

Contributor
Posts: 57

Re: Graphs and Excel

Thanks a lot Reeza for you answer. I think it would be the better way to work with Excel templates working with SAS outputs.

Best,

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 256 views
  • 0 likes
  • 2 in conversation