Okay, maybe it's me. I have the code below and want the macro to determine date ranges based on the MissionNum variable. But it seems the if &MissionNum = 'MISSION1' then line is causing SAS to create a variable named MISSION1 in the resulting table. Is there some other way I should be referencing the MissionNum variable?     %Let DMISID = 0091; %Let MissionNum = MISSION1; %LET i = %sysfunc(substr(&MissionNum,8,1));   data test; set twenthrappntfin; length Period $6.; informat Period $6. ; format Period $6. ; if DMISID= &DMISID;   　 if &MissionNum = 'MISSION1' then DO; if fm in (7 8 9 10 11 12) and fy= 2012 then Period = 'Before' ; else if fm in (2 3 4 5 6 7) and fy= 2013 then Period='After'; end; END;     Thanks, Brian ... View more

Hello All,   When I use the CLM option in SGPLOT with grouped variable the confidence bands are not transparent. How can I set the transparency?   proc sgplot data=sashelp.class; reg x=height y=weight / group=Sex CLM CLI; run; ... View more

Hello Everybody,   Reeza showed me to a custom style template that follows Stephen Few's visualization practices. I'm trying to use that to create a custom style template for my organization (attached). For the most part it seems to be doing what I want except for this:   When I run this code, all my custom chart colors show up in the bars:   ods html style=Styles.My_Custom_Style; title 'Counts by Type'; proc sgplot data=sashelp.cars; vbar type/ group=type; run;   but when I run this:   ods html style=Styles.HACustom; title 'Counts by Type'; proc sgplot data=sashelp.cars; vbar type; run;   the bar fill seems to be a default light blue. How can I get it to use my custom colors?   Thanks,   Brian ... View more

Hello Everybody,   I'm using the code below but no matter what GOPTIONS I specify I get the same histogram. What I want to do is change the text font and fill colors in the histogram. What am I doing wrong?   ods html; goptions reset=goptions; ODS GRAPHICS on /RESET ; goptions cback=blue htext=6 pct ftext="Cumberland AMT" FTITLE="Cumberland AMT"; title "Overlay Histograms with PROC SGPLOT"; proc sgplot data=Sashelp.Iris; histogram PetalLength / binwidth=5 transparency=0.5 name="petal" legendlabel="Petal Width"; histogram SepalLength / binwidth=5 transparency=0.5 name="sepal" legendlabel="Sepal Width"; density PetalLength / type=kernel lineattrs=GraphData1; /* optional */ density SepalLength / type=kernel lineattrs=GraphData2; /* optional */ xaxis label="Length (mm)" min=0; keylegend "petal" "sepal" / across=1 position=TopRight location=Inside; run; ... View more