Converting numeric to character via format

[RattyRatskin]

Hi,

I have numeric data representing provinces that I formatted as characters using a proc format

proc format

     value provFmt 10='NL' 11='NS'  ...

I can use the character value in a model statement for example but in an if statement

if province='NL' or province='NS' then ...

then I get

NOTE: Character values have been converted to numeric values at the places given by:

      (Line):(Column).

and the statement fails.

Any ideas on how to get around this?

Thanks!

RR

[ballardw]

if put(province,provFmt.) in ('NL', 'NS') then ...

[Astounding]

By creating a format, you haven't changed the values of PROVINCE.  You have only changed how they print.  So the IF statement should refer to the actual values:

if province=10 or province=11 then ...

if province in (10, 11) then ...

Good luck.

[RattyRatskin]

Thanks, Astounding. I'm confused, though. I can use

class province(ref='NL')

and that works fine...i.e. it's behaving as if 'NL' is the value (or an alias).

Anyway, is there a way to really change the values of province?

Thanks,

RB

[ballardw · Accepted solution]

Many place SAS will use the formatted value if the variable was permanently associated with the format.

For use in a datastep IF you'll basically need to create a new variable with the text value.

Either a straight forward:

ProvinceText = put(province,provFmt.);

or if the variable just has to be named Province

data want;

     set have (rename=(province=provnum));

    Province = put(provnum,provFmt.);

    /* and optionally */

   drop provnum;

run;

[RattyRatskin]

Thanks, ballardw.

[Tom]

Why you have to use ref='NL' instead of ref=10 is explained in this note: 

37108 - Setting the reference levels for the CLASS predictor variables