HI, 1) When I run the Proc Tab I get the date range out of sequence. The date should be 01/01/2012-01/07/2012, 01/08/2012-01/14/2012 ... DateRange 1/1/2012 - 1/7/2012 1/15/2012 - 1/21/2012 1/8/2012 - 1/14/2012 N Total Percent N Total Percent N Total Percent N N N ODS HTML3 file='H:\Test.xls' style=minimal; options missing=' '; proc tabulate data=Test1 f=10.2 S=[backGROUND=light yellow JUST=C] noseps; where Item='Shoe'; class DateRange VSB Compliance; classlev Compliance /S=[BACKGROUND=light grey]; keylabel pctn ='PERCENT' all='Total'; table VSB*(Compliance all), daterange*(n='N'*f=8.0 all pctn<Compliance all>='Percent') /RTS=50 MISSTEXT ='0' box=Shoe ; run; ODS HTML3 close; 2)In the same Proc Tab I'm trying get Total at the end of the table. It doesn't summerize each week with Total at end of the 3 weeks. 3) I've research the net and look in my SAS book and fig out how to add the % in the percent Column.Is that possible ? Thanks for your assistance DateRange 1/1/2012 - 1/7/2012 1/15/2012 - 1/21/2012 1/8/2012 - 1/14/2012 N Total Percent N Total Percent N Total Percent N N N VSB Compliance 1 1 100 0 0 0 0 0 0 Shoe YES Total 1 1 100 0 0 0 0 0 0
... View more
