Cynthia - Yes, i did. options obs=max; proc sort data=sashelp.prdsale out=prdsale1; by month; run; options obs=720; data prdsale; set prdsale1; run; proc freq data=prdsale; tables prodtype*product/list norow nocol nocum; run; proc format; value $prod 'CHAIR'='Chair' 'DESK'='Desk' 'TABLE'='Table' 'LAMP'='Lamp'; run; ods listing close; ods noresults; ods tagsets.excelxp file="c:\temp\sales1.xls" style=sansprinter; proc report data=prdsale nowd spanrows style=sasweb completerows; where country='U.S.A.' and region='EAST' and division='CONSUMER' and prodtype='OFFICE'; column (country region division Prodtype Product) Month, (Actual Predict); define country/group; define region/group; define division/group; define prodtype/group; define product/group f=$prod. preloadfmt order=internal; define month/across order=internal; define actual/display sum noprint; define predict/display sum ; run; ods tagsets.excelxp close; ods results; ods listing; Here is the output, Lamp below is not display correctly. its shifted a column. Any inputs as to how i can correct it? Thanks! Anu. Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Country Region Division Product type Product Predicted Sales Predicted Sales Predicted Sales Predicted Sales Predicted Sales Predicted Sales Predicted Sales Predicted Sales Predicted Sales Predicted Sales Predicted Sales Predicted Sales U.S.A. EAST CONSUMER OFFICE Chair $789.00 $988.00 $220.00 $946.00 $986.00 $129.00 $433.00 $492.00 $306.00 $154.00 $206.00 $81.00 Desk $619.00 $332.00 $669.00 $487.00 $994.00 $331.00 $739.00 $665.00 $921.00 $862.00 $662.00 $517.00 Lamp Table $649.00 $838.00 $439.00 $207.00 $804.00 $875.00 $473.00 $845.00 $91.00 $630.00 $185.00 $317.00
... View more