I have created my graphs, however, I want to customize them. However, when I have attempted the save as HTML open in Excel I get the "red box of death" where the graphs should be. (That code is below.) I then attempted the ODS Excel but I get the error message:
Generally I adust colors and appearance with SAS code but you haven't shown any so it is hard to tell what may be appropriate.
The ODS Graphics statement options OUTPUTFMT controls the image type.
The specific option varies with the ods destination. For RTF use something like
ODS graphics/ outputfmt=EMF;
ods rtf file="path and file" <other destination options>;
<code to generate plots>
ods rtf close;
Html output by default should generate PNG files, likely in your work library location. Depending on where that is Excel may not find them as there are number of things going on singe images in HTML are displayed referenced files and depending on how you display the html in Excel it may not see the referenced location.
That error message looks like you aren't specifing where the output goes and is possibly attempting to write to a location on a server where you do not have access. But again without code it is hard to tell.
There is a post on her from a day or two ago that explains this. It needs a workaround which may or may not work in SAS UE.
Feel free to post your code and explain what youre trying to change and we can help you accomplish it via code.
The code is now in the original respose. I'm trying to edit/update both of the graphs. I want to take out the underscore in the labels (title and axis), I want to change the colors from the current baby blue to a dark blue with the curve being orange or yellow whichever looks better against the darker columns.
Apply labels to your variables to get the underscore removed.
label my_variable = 'My Variable Name';
Instructions are here on how to create editable graphs are linked above. My computer is misbehaving and I can't post a direct link.
Here's what I think the equivalent code would be for SGPLOT with examples of how you'd change the colors, labels and titles.
Note I used Hex codes to select the colours and in SAS you add CX in front. So get the hex colour you want and update the code as desired.
title 'My Histogram'; proc sgplot data=sashelp.class; histogram height / dataskin=none outline fill fillatrs=(color=CX00aad2); density height / lineattrs=(color=Cxedb700) ; label height='Height (inches)'; run;
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
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.