SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Creating deciles

Reply
Contributor
Posts: 20

Creating deciles

I want to create decile. 

For example I have data like this:

Residual

12

11

12

12

11

11

13

14

15

12

11

9

7

8

9

7

8

I want the following table in return:

D1 D2 D3 D4 D5 D6 D7 D8 D9 D10

15 13

Thank you.

Super User
Posts: 19,876

Re: Creating deciles

There are two options, one is PROC RANK, which will group observations into groups, or PROC UNIVARIATE which will calculate the boundaries.

Here's a link to an example with PROC UNIVARIATE.
http://support.sas.com/documentation/cdl/en/procstat/63104/HTML/default/viewer.htm#procstat_univaria...

Ask a Question
Discussion stats
  • 1 reply
  • 562 views
  • 1 like
  • 2 in conversation