I build shewhart xcharts with a condition to choose the background colour for the particular chart. Some have a white background and some have a coloured background. After producing several charts, I greplay them via a template at which time the goptions cback= has been reset to white. The replayed graphs now all have a white background. Is there an option that will allow greplay to do its work while retaining the original background colour for each graph being replayed?    Thanks, Bill ... View more

My basic code below.   Is there a way to force the tabulate output to be left justified on the ppt slide? I'd like to have some blank space on the right to add a text box.   ods powerpoint file="c:\temp\Table20.pptx" image_dpi=300;   proc tabulate data=table; etc; run;   ods _all_ close;     Thank you, Bill ... View more

Using this code in SAS 9.4 TS1M0 to produce a large xl file ...  (56 columns, 48,000 rows)   proc export data=GQBPlus_BU (where=(put(OwnerOpCd,$BUCd.)="&BUCode")) Outfile= "\GQBPlus\&BuCode.\GQBPlus_&BUCode" /*path abbreviated*/ DBMS=xlsx Replace; Sheet="Local&BUCode";   Upon opening the excel file, this message comes up:   We found a problem with some content in ... Full message attached as a jpg file. The file opens upon a Yes answer and Excel produces an uninformative log.   What needs to be changed to avoid the excel message?   Thank you, Bill         ... View more