topic Creating bands in SAS Procedures

Creating bands

brophymj — Wed, 08 Oct 2014 10:35:51 GMT

Is there an easy way of creating band in SAS? I have a dataset where I would like to create bands for certain factors i.e. age etc. based on the volumn of data.

Re: Creating bands

LinusH — Wed, 08 Oct 2014 11:09:04 GMT

Is "band" a statistical term? If so, post this in Statistical Procedures forum instead to target your audience.

Re: Creating bands

brophymj — Wed, 08 Oct 2014 12:15:57 GMT

Not really. I just want to create something like the following:

Age Band

24 A.18-25

44 C.25-44

23 ...

65 ...

without having to define each level manually

So, given the width, lower and upper bounds i can create bands automatically

Re: Creating bands

user24feb — Wed, 08 Oct 2014 12:37:32 GMT

Proc Format should work:

Data A;
Input Age @@;
Datalines;
24 44 23 65 99
;
Run;

Proc Format;
Value AgeFormat 18-25 = "A"
25-44 = "C"
44-High = "Old" ;
Run;

Data B;
Set A;
Group=Put(Age,AgeFormat.);
Run;