- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
I’m trying to create a simple PowePoint file from SAS. The result is rather messy.
Specifically, one aspect: The correlation results are spread to three - four slides, depends what else I include. Here is the code:
ods powerpoint file="/my-pathway/output/obesity_exercise.pptx";
title "Correlation between exercise habits and the prevalence of obesity";
/* correlation: */
proc corr data=gal.all_exercise;
var aerobic_high muscles no_exercise obesity;
run;
ods powerpoint close;
See the result:
I want it on one slide, or, second best, two: one with the statistics and one with the table. Any hint?
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
1. Use ODS SELECT/EXCLUDE to ensure you only keep what you want to see
2. Change the style to a simpler style that will fit on the page
3. If you have too much data, you have too much data.
4. Instead of a table, show a correlation heatmap which is graphical and easier to interpret and you can get away with smaller numbers.
@GAL wrote:
I’m trying to create a simple PowePoint file from SAS. The result is rather messy.
Specifically, one aspect: The correlation results are spread to three - four slides, depends what else I include. Here is the code:
ods powerpoint file="/my-pathway/output/obesity_exercise.pptx";
title "Correlation between exercise habits and the prevalence of obesity";
/* correlation: */
proc corr data=gal.all_exercise;
var aerobic_high muscles no_exercise obesity;
run;
ods powerpoint close;
See the result:
I want it on one slide, or, second best, two: one with the statistics and one with the table. Any hint?
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
I suggest you use the alternative template if you want to create and compile the presentation in 2 files, or you may need to look for a good alternative.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Your ability to squeeze information into a Powerpoint document using ODS POWERPOINT is limited, there are a number of sizing factors that really cannot be controlled via SAS, such as the amount of space PowerPoint allocates for text. If you need a large amount of text, like a 4x4 correlation matrix in PowerPoint, I would create it using the HTML output or PDF output or Excel output, and then copy and paste it into the PowerPoint. Certainly not ideal, but given the limitations of ODS POWERPOINT, I think it is the best solution I have found.
Paige Miller