DATA Step, Macro, Functions and more

SAS script to random pick obs from group data

Reply
Occasional Learner
Posts: 1

SAS script to random pick obs from group data

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.

Super User
Posts: 6,951

Re: SAS script to random pick obs from group data

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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Ask a Question
Discussion stats
  • 1 reply
  • 94 views
  • 0 likes
  • 2 in conversation