topic Re: grouping the value within subs group in SAS Procedures

grouping the value within subs group

thdang — Mon, 10 Dec 2012 23:49:41 GMT

Hello, can anyone help me on this? How can I grouping all the data in a sub group sort by the same date beta into for example 6 groups? Thank you

beta date group

Re: grouping the value within subs group

art297 — Mon, 10 Dec 2012 23:56:44 GMT

What result are you trying to achieve given your example dataset?

Re: grouping the value within subs group

thdang — Tue, 11 Dec 2012 00:05:14 GMT

I have sort the data by date and beta. I want to grouping the betas of the same date into 10 groups (1-10) with equally numbers of observation. so if date 01/01/1980 has 3 obs then I would have 3 groups, each has 1 obs, if date 04/01/1980 has 250 obs then i would have 10 groups each have 25 obs

Re: grouping the value within subs group

art297 — Tue, 11 Dec 2012 00:10:16 GMT

Can you use proc rank to do what you want? Take a look at: Base SAS(R) 9.2 Procedures Guide

Re: grouping the value within subs group

thdang — Tue, 11 Dec 2012 00:27:02 GMT

I have try something like this but it did not work.. the value of beta is replaced by the rank. how can I keep the beta and add a column for the rank

proc rank data=sasdata.Out_reg_betamdi_adj

out = sasdata.Out_reg_betamdi_adj1

groups = 10;

by date;

var beta;

run;

Re: grouping the value within subs group

Ksharp — Tue, 11 Dec 2012 01:08:21 GMT

RANK statement will keep the rank for you and remain the original data.

proc rank data=sasdata.Out_reg_betamdi_adj

out = sasdata.Out_reg_betamdi_adj1

groups = 10;

by date;

var beta;

ranks rank_beta;

run;

Re: grouping the value within subs group

thdang — Tue, 11 Dec 2012 09:38:04 GMT

Thank you!