binning a continuous variable

[ashatsas]

I have a sas dataset with 2 continuous variables (say x and y) and the data set has been sorted on x.

I want to create about 50 bins on x and for each of these bins, I want to calculated the mean of both x and y.

So, the output dataset will have 50 values for x and y.

Thanks

[Reeza · Accepted solution]

1. Use PROC RANK to BIN the data

2. Use PROC MEANS to calculate the summary statistics

---

@ashatsas wrote:

I have a sas dataset with 2 continuous variables (say x and y) and the data set has been sorted on x.

I want to create about 50 bins on x and for each of these bins, I want to calculated the mean of both x and y.

So, the output dataset will have 50 values for x and y.

Thanks

---

[ashatsas]

Thanks so much for a quick response.