Hi all,
I'm fairly green when it comes to statistical procedures in SAS (and to be honest some stats in general). I have a dataset of customers that were used to conduct a test. The data was split into 3 segments, and then random control cells (~10%) were taken from each of these 3 segments.
I have a dataset that lists all the customers (segments and controls), the segment they were in, and whether or not they were part of the treatment or control. I have then appended data (left join) where the customer exhibited the desired behaviour.
So my dataset looks like the following example.
CUSTOMER | SEGMENT | GROUP | RESPONSE | RESPONSE DATE
--------------------|-------------------|----------------------|---------------------|-----------------------------
1234567 | SEG-A | TREATMENT | |
2225874 | SEG-A | TREATMENT | ABC123 | 12Jan2009
6657894 | SEG-A | CONTROL | ABC123 | 12Jan2009
3215870 | SEG-A | TREATMENT | ABC124 | 12Jan2009
--------------------|-------------------|----------------------|---------------------|-----------------------------
Please keep in mind this is not a complete sample and there are other segments that would/should be indicated here.
What I am wanting to do is to calculate is 2 things. Which groups had a statistically significant response (to 95% confidence level) and the number of incremental responses in each group.
It would be great to be able to determine this for each group over time (so I can indicate when the results became statistically robust).
Firstly, is there a SAS procedure that will allow me to do this easily, or am I going to have to do manual calculations to determine this?
Any help would be GREATLY appreciated. Thanks in advance.
DW