BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
AnalytX
Fluorite | Level 6

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,

1 ACCEPTED SOLUTION

Accepted Solutions
Reeza
Super User

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

4 REPLIES 4
Reeza
Super User

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.

AnalytX
Fluorite | Level 6

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.

Reeza
Super User

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.

AnalytX
Fluorite | Level 6

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,

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

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