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.
Is "band" a statistical term? If so, post this in Statistical Procedures forum instead to target your audience.
Not really. I just want to create something like the following:
Age Band
24 A.18-25
44 C.25-44
23 ...
65 ...
99
without having to define each level manually
So, given the width, lower and upper bounds i can create bands automatically
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;
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: