Help using Base SAS procedures

proc survey select

Reply
Occasional Contributor
Posts: 5

proc survey select

HI i have a table with all my customers and customer attributes. The table only contains one customer per row. So no duplicates. From this group of customers I wany four groups that are representibe of my base and mutually exclusive. I am running the below code

proc surveyselect data=base

out =groups

methos =srs

samprate =0.07

seed = 1452

rep= 4;

strata gender cust_seg;

run;

when i run the above code I get four groups but a customer in group one could also be in group 3.does anyone know I can make the groups mutually exclusive

thanks

Super User
Posts: 11,343

Re: proc survey select

The REPlicate option generates independent samples so may have the same record in more than one replicate.

Some options would be to add another stratification variable if the 4 groups should have some desired feature in common such as industry or geographical region. OR cluster

Or create larger sample and then assign groups later in a data step with something like:

group = mod(_n_,4);

Ask a Question
Discussion stats
  • 1 reply
  • 165 views
  • 0 likes
  • 2 in conversation