topic Re: how to group ages data into several interval in New SAS User

how to group ages data into several interval

sz247 — Mon, 28 Sep 2020 13:47:34 GMT

In the Bank data, the client's age is individual figuer. I want to group them into several group for my analysing purpose. May I know how to do it? any link for it? Thanks.

Re: how to group ages data into several interval

ghosh — Mon, 28 Sep 2020 13:50:41 GMT

Use proc format to create your age ranges

Re: how to group ages data into several interval

PaigeMiller — Mon, 28 Sep 2020 14:35:42 GMT

What analysis do you intend to do?

Re: how to group ages data into several interval

Reeza — Mon, 28 Sep 2020 15:32:45 GMT

Use PROC FORMAT

https://github.com/statgeek/SAS-Tutorials/blob/master/proc_format_example.sas

https://support.sas.com/resources/papers/proceedings/proceedings/sugi30/001-30.pdf

Or use IF/THEN statements

https://gist.github.com/statgeek/227565537f3dffcd8627f1fe2eff844f

@sz247 wrote:

In the Bank data, the client's age is individual figuer. I want to group them into several group for my analysing purpose. May I know how to do it? any link for it? Thanks.

Re: how to group ages data into several interval

sz247 — Mon, 28 Sep 2020 21:16:13 GMT

Hi Thank you for your reply.
A Portuguese bank provided a direct marketing campaign, selling term-deposit product by calling its customers. THe data includes customers' age. I want to show the age distribution and yes/no subscription through a stack bar chart. I need to group age into several groups.

Re: how to group ages data into several interval

PaigeMiller — Tue, 29 Sep 2020 10:56:53 GMT

Then I agree with @ghosh and @Reeza, use PROC FORMAT to create the groups, then apply the format to the variable age.