proc survey select

Syndey — Mon, 23 Mar 2015 10:04:49 GMT

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

Re: proc survey select

ballardw — Mon, 23 Mar 2015 14:54:07 GMT

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);

topic proc survey select in SAS Procedures

proc survey select

Re: proc survey select