Hi, I am not quite sure I understand the output desired, by my friend and I have worked out this little code that might be helpful:   data have; input id date $ 3-13 event ; mydate = mdy(substr(date, 1,2),substr(date,4,2), substr(date,7,4)); format myDate date9.; datalines; 1 11/23/2014 0 2 10/23/2014 0 2 11/23/2014 1 1 10/23/2016 1 ; run; proc print;run; proc report data = have; column id event, (mydate); define id/group; define event/across; define myDate/group; run; ... View more

How about something like this: data have; informat date_col_1 mmddyy10. date_col_2 yymmn6.; format  date_col_1 mmddyy10. date_col_2 yymmn6.; input ID     date_col_1     date_col_2     total; diff_mths = (date_col_1 - date_col_2)/30.25; datalines; 1         1/3/2012          201203        5 1         1/3/2012          201204        7 1         1/3/2012          201205        3 2         10/5/2013         201201        1 2         10/5/2013         201202       12 3         3/4/2012          201301       11 3         3/4/2012          201305        4 3         3/4/2012          201401        5 3         3/4/2012          201403       10 ; run; proc print;run; Anca. ... View more

Hi. AS soon as I posted my answer, I realized ...ehh, that's not a solution. Well, here is something soooo tedious, but does what you want: (this is going back to good ol' style: annotate!) *--create an annotate dataset, that will force to color bins based on VERY specific values; data boxColor;    length function style color $ 8 ;    xsys="3"; ysys="3";when = "a";  set sashelp.class;         %bar(32.7,7.89,42.5,88.2,red,1,solid);         %move(32.7,7.9);         %draw(32.7,88.2,black,1,.5);         %move(32.7,88.2);         %draw(42.5,88.2,black,1,.5);         %move(42.5,7.9);         %draw(42.5,88.2,blue,1,.5);         %bar(42.5,7.9,61.5,48,red,1,solid);         %move(42.5,7.9);         %draw(42.5,48,black,1,.5);          %move(42.5,48);         %draw(61.5,48,black,1,.5);      %bar(61.5,7.9,80.5,48,red,1,solid);         %move(61.5,7.9);         %draw(61.5,48,black,1,.5);         %move(61.5,48);         %draw(80.5,48,black,1,.5);     %bar(80.5,7.9,98.5,18,red,1,solid);         %move(80.5,7.9);         %draw(80.5,18,black,1,.5);         %move(80.5,18);         %draw(98.5,18,black,1,.5); run; %annomac; ods graphics off; proc univariate data = sashelp.class anno = boxColor;     var age;histogram age; run; Now let me know if you have questions. Hopefully will find a more elegant solution Anca. ... View more

Hi. I don't know how to do this using PRC SGPANEL, but below is a code using PROC TEMPLATE + PROC SGRENDER: *say you want to differentiate children older than 12; *I created two variables out of AGE: age_below and age_above; DATA HAVE;     SET SASHELP.CLASS;         IF AGE <= 12 THEN AGE_BELOW = AGE;             ELSE AGE_ABOVE = AGE; RUN; *tell SAS to save my graph in this location; ODS LISTING GPATH = "GivePath"; *give a name to my graph; ODS GRAPHICS/RESET IMAGENAME = "SPLIT_HIST"; *write the template to create the histogram with two colors; *the first few lines are telling SAS how wide and long I want to graph, then gives some graph space preferences; *notice the two histogram statements (which I overlay), one for the below variable, one for the above variable; PROC TEMPLATE; DEFINE STATGRAPH Hist2Colors; BEGINGRAPH / DESIGNWIDTH=1074 DESIGNHEIGHT=724;    LAYOUT LATTICE / ROWDATARANGE=DATA COLUMNDATARANGE=DATA ROWGUTTER=10 COLUMNGUTTER=10;       LAYOUT OVERLAY / XAXISOPTS=( LABEL=('AGE'));          HISTOGRAM AGE_ABOVE / NAME='HISTOGRAM' BINWIDTH=1.0 FILLATTRS=GRAPHDATA1 OUTLINEATTRS=GRAPHDATA1;          HISTOGRAM AGE_BELOW / NAME='HISTOGRAM2' BINAXIS=FALSE BINWIDTH=1.0;       ENDLAYOUT;    ENDLAYOUT; ENDGRAPH; END; RUN; *the sgrender procedure will render the template PROC SGRENDER DATA=WORK.HAVE TEMPLATE=Hist2Colors; RUN; I hope it helps. Best of luck! Anca. ... View more