Help for %do loop on variables bucketing

[kayne]

Hi all,

As you guys know that before anyone could start off with PROC GENMOD, they may be consider doing bucketing for their class/independent variables.

I am currently interested in doing a loop macro for the bucketing. The criteria will be ensuring that the maximum number of buckets for each variable is 5 and each variable bucket will have at least 5% of frequency, thus we might need to incorporate cumulative frequency into the loop.

Sadly to say, I know what I want to do, but I am unsure how to actually create the loop macros for SAS to automatically do the bucketing for me according to the criteria.

Will appreciate all feedback and ideas! Thanks for the help

[ballardw]

Before getting into any macro code for grouping I tend to look at Proc Format to assign group values. Most procedures will use the formatted value for groups. I would look at proc freq or univariate output to find likely values to set the boundary values for the format.