Thanks all, I am writing sas strored process to bring data from sas olap cube and writes to the _webout, The strored process has measure parmeter , based on measure selection the strored process brings the data from cube. I have controll table which has list of measures and formats to the repective measures in seperate colums. My requirement is based on the measure slection the related measure format is applied and writes to the _webout(this is beacuse the client wants to controll formats from control table) parmeter value can be passed for single, double and triple measures from the control table. data table:- productname measure 2005 2006 2007 a price 25 25 25 a quantity 10 20 5 a totalsale 250 500 125 b price 30 30 30 b quantity 10 20 30 b totalsale 300 600 900 c price 40 40 40 c quantity 10 20 5 c totalsale 400 800 200 control table:- Measurename Measureformat price 5.2 quantity 4.2 totalsale 6.2 Thanks.
... View more