Help using Base SAS procedures

proc format for consecutive numbers of a character variable

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 93
Accepted Solution

proc format for consecutive numbers of a character variable

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.


Accepted Solutions
Solution
‎02-25-2015 12:53 PM
PROC Star
Posts: 7,364

Re: proc format for consecutive numbers of a character variable

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;

View solution in original post


All Replies
Solution
‎02-25-2015 12:53 PM
PROC Star
Posts: 7,364

Re: proc format for consecutive numbers of a character variable

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;

Super User
Posts: 5,092

Re: proc format for consecutive numbers of a character variable

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.

Frequent Contributor
Posts: 93

Re: proc format for consecutive numbers of a character variable

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

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 172 views
  • 4 likes
  • 3 in conversation