topic Re: proc format for consecutive numbers of a character variable in SAS Procedures

proc format for consecutive numbers of a character variable

lizzy28 — Wed, 25 Feb 2015 17:27:08 GMT

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.

Re: proc format for consecutive numbers of a character variable

art297 — Wed, 25 Feb 2015 17:53:27 GMT

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;

Re: proc format for consecutive numbers of a character variable

Astounding — Wed, 25 Feb 2015 18:12:29 GMT

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.

Re: proc format for consecutive numbers of a character variable

lizzy28 — Wed, 25 Feb 2015 18:31:42 GMT

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