topic Re: Creating custom frequency bins for consecutive numbers in a dataset in New SAS User

Custom frequency bins

marksanter — Sat, 20 Jul 2019 16:30:38 GMT

Hello,

What is the best way to create custom frequency bins?

Re: Creating custom frequency bins for consecutive numbers in a dataset

Reeza — Wed, 17 Jul 2019 21:06:04 GMT

What about the 10's? Ignore them completely?

Have you looked into multilevel formats yet? I would highly recommend using a mlf to get this result, which becomes quite simple.

Re: Creating custom frequency bins for consecutive numbers in a dataset

marksanter — Sat, 20 Jul 2019 16:31:09 GMT

Hello,

I have not looked into MLFs. I am still quite new to SAS.

Mark

Re: Creating custom frequency bins for consecutive numbers in a dataset

ballardw — Wed, 17 Jul 2019 23:01:10 GMT

I haven't a clue what role the date plays in this.

Can you provide something with the counts done manually from the example data?

Re: Creating custom frequency bins for consecutive numbers in a dataset

marksanter — Wed, 17 Jul 2019 23:21:37 GMT

My apologies, the date does not really play a role in this dataset.

May I ask what you mean by providing something with the counts done
manually?

Re: Creating custom frequency bins for consecutive numbers in a dataset

Reeza — Thu, 18 Jul 2019 01:38:20 GMT

It means show what you expect as the final result from this data. Then we can test our programs to ensure they get the right result otherwise we're making guesses and this becomes a longer back and forth process.

Re: Creating custom frequency bins for consecutive numbers in a dataset

PGStats — Thu, 18 Jul 2019 05:09:59 GMT

Keep it simple:

data counts;
do n = 1 by 1 until(last.count);
    set have; 
    by count notsorted;
    end;
if count = 5 then do;
    do bin = 1 to 141 by 10;
        if n >= bin then output;
        end;
    end;
keep n bin;
run;

proc sql;
create table want as
select
    bin,
    count(n) as nbSequences,
    sum(n) as nb5Counts
from counts
group by bin;
quit;

proc print data=want noobs; run;

                                      nb
                           bin    Sequences    nb5Counts

                             1        5           155
                            11        2           135
                            21        2           135
                            31        2           135
                            41        2           135
                            51        2           135
                            61        1            81
                            71        1            81
                            81        1            81