Yaw,

Here is an ARRAY approach with DO loop, though the preferred "something" for me would be the FORMAT as previously illustrated.

data old; array bnd{4} _temporary_ (0 1.5 4.5 7.5); input agemo; i=0; do agecat = 0, 3, 6; i=i+1; if agemo <= bnd{i+1} then leave; end; cards; .1 1.49 1.5 1.51 3 4.5 5 ;

proc print; run;

Robin High

From: Yaw <linkyox@GMAIL.COM> To: SAS-L@LISTSERV.UGA.EDU Date: 02/10/2010 12:43 PM Subject: Automating age bin creation Sent by: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>

Dear all:

I want to create agebins in months but I find myself writing several lines of codes for this task. Given the age range I have my current method will take a long time to get all the codes in.

Is there anyway I can expeditiously do this? like with an array or something?

Thanks,

Yaw

Here's what I have been doing tirelessly:

if agemos le 1.500 then agecat=0;

else if agemos gt 1.500 and agemos lt 4.500 then agecat=3;