proc format for consecutive numbers of a character variable

[lizzy28]

Hi all,

I've got lots of help here. Here is another question I come across.

I have a character variable agegrp with values of "01", "02", "03", "04", "05", and "06". The value labels are 01: younger than 8, 02: age 9-12, 03: age 13-17, 04-06: adults.

To do proc format for the variable, is there a quick way to do 04-06? Here is how I started:

proc format;

value $agegrp

   "01"="younger than 8"

   "02"="age 9-12"

   "03"="age 13-17"

   "04"="adult"

  "05"="adult"

   "06"="adult";

run;

Thanks a lot.

[art297 · Accepted solution]

Not sure what you are asking. Are you just looking for how to declare a range? If so,:

proc format;

value $agegrp

   "01"="younger than 8"

   "02"="age 9-12"

   "03"="age 13-17"

   "04"-"06"="adult";

run;

[Astounding]

Be very wary of defining ranges for character formats.  I would prefer to see a list of values:

"04", "05", "06" = "adult"

If you define a range, here are some values that would fall into the "adult" classification:

"0500"

"04C"

That doesn't save you much on the typing so you have to decide if it's worth the trouble.

Good luck.

[lizzy28]

I think I overthought. I did "04"--"06"="adult" at the beginning. Thanks a lot.