ordered character ranges with gplot

deleted_user — Thu, 14 Sep 2006 15:06:27 GMT

This is irritatingly simple, but I can't get it.

I have a continuous variable (age) that I have created categorical ranges for.
Partial follows:

IF REALAGE <= 3 THEN AGERANGE = "0-3";
ELSE IF 3 <= REALAGE AND REALAGE <= 5 THEN AGERANGE = "3-5";
ELSE IF 5 <= REALAGE AND REALAGE <= 8 THEN AGERANGE = "5-8" ;
ELSE IF 8 <= REALAGE AND REALAGE <= 11 THEN AGERANGE = "8-11";
ELSE IF 11 <= REALAGE AND REALAGE <= 14 THEN AGERANGE = "11-14" ;

I am plotting a single value per agerange with gplot in SASEG. I WANT the horizontal axis to read as it should (i.e. 0-3, 3-5, 5-8, 8-11, 11-14) instead it plots it out as (i.e. 0-3, 11-14, 3-5, 5-8, 8-11).

I have tried inserting proc format with the insert code option, no good.

Thoughts?

Re: ordered character ranges with gplot

Cynthia_sas — Thu, 14 Sep 2006 20:08:39 GMT

Hi,
There are several different ways to do this. The easiest might be to insert a leading space before the single digit ranges. [pre]
IF REALAGE <= 3 THEN AGERANGE = " 0-3";
ELSE IF 3 <= REALAGE AND REALAGE <= 5 THEN AGERANGE = " 3-5";
ELSE IF 5 <= REALAGE AND REALAGE <= 8 THEN AGERANGE = " 5-8" ;
ELSE IF 8 <= REALAGE AND REALAGE <= 11 THEN AGERANGE = " 8-11";
ELSE IF 11 <= REALAGE AND REALAGE <= 14 THEN AGERANGE = "11-14" ;
[/pre]
you may also need a length statement so the AGERANGE variable does not get truncated:
[pre]
length agerange $5;[/pre]
For more about the other ways to do ordering, you could contact Tech Support.
cynthia

topic ordered character ranges with gplot in SAS Enterprise Guide

ordered character ranges with gplot

Re: ordered character ranges with gplot