topic How to create a variable with n levels based on the size of the data in SAS Procedures

How to create a variable with n levels based on the size of the data

Ruth — Thu, 18 Aug 2011 18:08:57 GMT

Hi,

To explain what I want, please let me show the simple code:

proc sort data=work.city;

by descending gdp;

run;

Then I want to create a variable in the data work.city, which indicates the group that the case belongs to based on its gdp level. Group 1 has the largest gdp, and group 10 has the lowest gdp. Each group has equal number of cases.

How can do it?

Cheers.

Ruth.

How to create a variable with n levels based on the size of the data

art297 — Thu, 18 Aug 2011 18:21:33 GMT

Couldn't you just use proc rank .. the data doesn't even have to be sorted. Just specify the number of groups you want. e.g.,

data city;

input city gdp;

cards;

1 10

2 9

3 8

4 7

5 6

6 5

7 4

8 3

9 2

10 12

11 13

12 14

;

proc rank data=city groups=4 out=want;

var gdp;

ranks gdprank;

run;