SAS script to random pick obs from group data

kltee — Sat, 01 Jul 2017 07:21:59 GMT

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.

Re: SAS script to random pick obs from group data

Kurt_Bremser — Sat, 01 Jul 2017 07:36:24 GMT

Please post some example data (in a data step with datalines, NOT a Excel file!), the code you already have, and where the result differs from your expectations. If you get errors or warning messages, post the log.

topic Re: SAS script to random pick obs from group data in SAS Programming

SAS script to random pick obs from group data

Re: SAS script to random pick obs from group data