Sorry Cynthia that it took me so long to thank you for this. This is totally correct. Thanks! ... View more

Hi Robert-- I have another questions if you have time.  I am trying to incorporate the charts into a report - see my program below.  I have  to include a table and both charts in one page. Is it possible that  I can shrink the charts and have them side by side horizontally?  Any assistance will be greatly appreciated proc sort data=touches_month_chart out=touches_month_chart; by media_method; run; ods listing; options leftmargin=".1 in" topmargin=".1 in"         rightmargin=".1 in" bottommargin=".1 in"         nodate nonumber orientation=portrait; ods pdf file="U:\Matt Local\Programs\VLSS Programs\Report.pdf" startpage=yes; ods escapechar='^'; footnote; /*This creates a table from another dataset*/ proc report data=touches_month_table nowd headline headskip style(column)={just=c font_size=11pt font_face= 'Arial Narrow' /*cellwidth=2.5in*/} style(header)={font_size=11 pt font_face= 'Arial Narrow' FONT_WEIGHT =BOLD background=cxcccccc}; title1 "^S={font_face='Arial Narrow' font_weight=bold font_size=14pt} Marketing Touches"; column ("^S={font_face='Arial Narrow' FONT_WEIGHT =BOLD background=CXDC143C just=c font_size=12pt} Frequency of Marketing Touches by Month ^S={}"  Month MEDIA_METHOD  Control Test); define Month / group style(column)={just=l cellwidth=.8in bordertopcolor=black borderrightcolor=black borderlefttcolor=black borderbottomcolor=black}; define MEDIA_METHOD / display style(column)={just=l cellwidth=1in  bordertopcolor=black borderrightcolor=black borderlefttcolor=black borderbottomcolor=black}; define Control / display style(column)={just=c cellwidth=.7in bordertopcolor=black borderrightcolor=black borderlefttcolor=black borderbottomcolor=black}; define Test / display style(column)={just=c cellwidth=.7in bordertopcolor=black borderrightcolor=black borderlefttcolor=black borderbottomcolor=black}; run; ods pdf startpage=no; options nobyline; title1 ls=1.5 "Marketing Touches Results: #byval(media_method)"; axis1 label=none major=(number=7) minor=none offset=(0,0); axis2 label=none value=none; axis3 label=none offset=(8,8); legend1 label=(position=top color=white) position=(bottom center) shape=bar(.15in,.15in); pattern1 v=r color=red; pattern2 v=s color=red; goptions device=png xpixels=500 ypixels=400 gunit=pct htitle=4.0 htext=3.2; proc gchart data=touches_month_chart; by media_method; format touch_count comma10.0; vbar pilot_category / type=sum sumvar=touch_count legend=legend1 group=month subgroup=pilot_category outside=sum width=10 space=0 gspace=8 coutline=same raxis=axis1 maxis=axis2 gaxis=axis3 noframe autoref clipref cref=graycc; run; title; ods _all_ close; ods listing; ... View more

Thanks Robert! This is perfect. I appreciate it. ... View more

Still does not work data test2; set data;     LOB=scan(CreativeName, 1, "_");   Bundle=scan(CreativeName, 3, "_");   CreativeConcept=scan(CreativeName, 4, "_");     price=input(scan(CreativeName, 5, "_"), 8.)/100;   date2=input(scan(CreativeName, 8, "_", 8.), anydate.);   Sweetner=scan(CreativeName, 6, "_");   date=scan(CreativeName, 8, "_");     format price dollar8.2;     price2=put(input(scan(CreativeName, 5, "_"), 8.)/100, dollar8.2 -l); run; ... View more

ok I get  Price but I'm having issues pulling out date and formatting it 2102014 data test2; set data;     LOB=scan(CreativeName, 1, "_");   Bundle=scan(CreativeName, 3, "_");   CreativeConcept=scan(CreativeName, 4, "_");     price=input(scan(CreativeName, 5, "_"), 8.)/100;    date=scan(CreativeName, 8, "_");  /*just pulls out the value*/   date2=input(scan(CreativeName, 8, "_", mmddyyyy );  /*does not work*/   Sweetner=scan(CreativeName, 6, "_");     format price dollar8.2;     price2=put(input(scan(CreativeName, 5, "_"), 8.)/100, dollar8.2 -l); run; ... View more

And again, the value can change but its always a two digit two decimal number (so four characters)  or 0. ... View more

Thanks Rezza. Sorry its always the 5th parameter. Thanks! ... View more

Thanks.  the string values change though. Could look something like this: acq_newsale_0_CartChat_0_Flash_1192014 or this: acq_old_3x_GadgetPotomac_7999_Flash_112014 so $0.00 or $79.99.  The value is not always  $89.99 ... View more

Hi Reeza-- Thanks! I am still getting a funny output. It looks like this. KPI Lift Response Rate -20.38% Conversion Rate N/A Yield Rate N/A VideoQual RR -22.10% Cost Per Response 29.72% Cost Per Sale N/A --N/A should be black --Cost Per Response should be green. proc report data=Final nowd;   column KPI Control Test lift Statistically_Significant_95 percent_Significant;   define KPI / display   style(column)={ just=right  font_size=10pt font_face= 'Arial Narrow' FONT_WEIGHT =BOLD  cellwidth=1.4in}   style(header)={ just=center font_size=10 pt font_face= 'Arial Narrow'  FONT_WEIGHT =BOLD background=cxcccccc};   define lift  / display   style(column)={just=center font_size=10pt font_face= 'Arial Narrow'cellwidth=.7in}   style(header)={just=center font_size=10 pt font_face= 'Arial Narrow'  FONT_WEIGHT =BOLD background=cxcccccc};   compute lift; if KPI in('Response Rate' 'Conversion Rate' 'Yield Rate' 'VideoQual RR') and lift < 0 then call define(_col_,"style","style=[foreground=red]"); else if KPI in('Response Rate' 'Conversion Rate' 'Yield Rate' ' VideoQual RR') and lift > 1 then call define(_col_,"style","style=[foreground=green]"); else if KPI in('Response Rate' 'Conversion Rate' 'Yield Rate' ' VideoQual RR') and  lift = .  then call define(_col_,"style","style=[foreground=black]"); else if KPI in('Cost Per Response' 'Cost Per Sale') and lift > 1 then call define(_col_,"style","style=[foreground=red]"); else if KPI in('Cost Per Response' 'Cost Per Sale') and lift < 0 then call define(_col_,"style","style=[foreground=green]"); else if KPI in('Cost Per Response' 'Cost Per Sale') and  lift = .  then call define(_col_,"style","style=[foreground=black]"); endcomp; run; ... View more