08-30-2017 06:44 PM - edited 08-31-2017 06:57 AM
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:
08-30-2017 06:57 PM
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.
08-30-2017 07:00 PM
I updated it with the code. Sorry about that. I also tried doing the ODS graphics vice the ODS Excel to see if that would make a difference (it didn't).
08-30-2017 07:52 PM
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.
08-30-2017 08:07 PM
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.
08-30-2017 08:14 PM
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.
08-31-2017 10:55 AM
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;