topic Re: Frequency table with step increament in Statistical Procedures

Frequency table with step increament

ammarhm — Tue, 09 Sep 2014 11:02:46 GMT

I have been searching for this very simple thing. Creating a frequency table with certain increament steps

Let us say I have a continous variable taking values 1-100 and I have a thousand observations of that variable

What is the easiest wat to create a frequency table with a specific increamtnet, ie in groups of 10 or 20 or anything??

Using proc freq with formats seems a bit complicated for this task, or am i worng?

Regards

Re: Frequency table with step increament

JacobSimonsen — Tue, 09 Sep 2014 11:57:37 GMT

One solution can be to define a format with relevant ranges. Do this with the cntlin option allows you to benefit of the do-loop in a datastep:

data abc;

do i=0 to 100;

output;

END;

run;

data myformat;

type='N';

fmtname='myformat';

do start=0 to 100 by 5;

end=start+4;

label=compress(put(start,best3.)||'-'||put(end,best3.));

output;

end;

run;

proc format cntlin=myformat;

run;

proc freq data=abc;

format i myformat.;

table i;

run;

Re: Frequency table with step increament

Ksharp — Tue, 09 Sep 2014 13:46:20 GMT

OR you could try proc rank to split these data into a couple of groups.

data abc;
  do i=1 to 100;
   output;
  END;
run;
proc rank data=abc out=temp groups=10;
var i;
ranks group;
run;
proc freq noprint data=temp;
by group;
tables i/out=want nocum nopercent;
run;

Xia Keshan