topic Re: Splitting a data set into 10 equal deciles in SAS Procedures

Splitting a data set into 10 equal deciles

serveoverice — Fri, 29 Apr 2016 10:15:59 GMT

I have a dataset (1.2 million records) and I am wanting to assign a score of 1 to 10 to each record depending on the position in a list. I'm sure this is quite simple to do but I am new to SAS and I can't find anything on the forums. I'm guessing I need to rank the dataset first but then I'm not sure where to go from there. Any help would be gratefully received.

Re: Splitting a data set into 10 equal deciles

LinusH — Fri, 29 Apr 2016 10:24:12 GMT

Some sample input and desired output helps you describe your issue.

Especially describe the concept of a position in a list.

Re: Splitting a data set into 10 equal deciles

serveoverice — Fri, 29 Apr 2016 10:28:42 GMT

Thanks Linus. The file is a response file. Each line has a propensity score and I am trying to see the response rate by decile. For example:

Person_Key | Response Score | Responded

1 | 900 | 1

2 | 600 | 0

3 | 750 | 0...

I want to split the volume into 10 equal segments so I can see if I can refine the model to go deeper into marginal segments.

Does that help?

Re: Splitting a data set into 10 equal deciles

stat_sas — Fri, 29 Apr 2016 10:47:51 GMT

Seems like you are trying to calculate lift based on a model. Try the following code that will split data into 10 groups based on descending values of Response_score variable.

proc rank data=have groups=10 descending out=ranked;
var Response_score;
ranks decile;
run;

Re: Splitting a data set into 10 equal deciles

serveoverice — Fri, 29 Apr 2016 10:52:33 GMT

That's correct. Thank you very much stat_sas.