Hi, I am new to SAS script. Really apprecaite how to write sas script base on below logic steps: 1. Extract total monthly sales data = n volume 2. Group and count total volume from data field name = A (field A is product color code depending to monthly sales, mean if certain color code no sales in that month, that color code will not appear in n volume) 3. Randam pick each color code sales one case from each group 4. repeat to pick the randam sample observation from each group until total sample reach 5% from total monthly sales data (5%*n volume) 5. list down all sales from randam pick.
... View more