Help for %do loop on variables bucketing

kayne — Fri, 07 Aug 2015 19:35:08 GMT

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

Re: Help for %do loop on variables bucketing

ballardw — Fri, 07 Aug 2015 19:46:44 GMT

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.

topic Help for %do loop on variables bucketing in SAS Programming

Help for %do loop on variables bucketing

Re: Help for %do loop on variables bucketing