VARIABLE CHARACTER

Barkamih — Wed, 09 May 2018 13:06:16 GMT

I want to change the month number to a season for the variable camonth

month from 1 to 5 = spring

month from 9 to 12 = autumn

months from 6 to 8 others

in data HO

I did this code which results in missing data

if camonth = 1 then camonth = autumn;
if camonth = 2 then camonth = autumn;
if camonth = 3 then camonth = autumn;
if camonth = 4 then camonth = autumn;
if camonth = 5 then camonth= autumn;
if camonth = 6 then camonth = other;
if camonth = 7 then camonth = other;
if camonth = 8 then camonth = other;
if camonth = 9 then camonth = spring;
if camonth = 10 then camonth = spring;
if camonth = 11 then camonth = spring;
if camonth = 12 then camonth = spring;

Regards

Re: VARIABLE CHARACTER

RW9 — Wed, 09 May 2018 13:09:47 GMT

I am going to assume that cammonth is a numeric variable, therefore you cannot put character data into it. You have a few methods to do what you want, most simple is a format which you apply to the data - don't know what software your using so this is simple SAS code:

proc format;
  value season
    1-5="Autumn"
    6-8="Other"
    9-12="Spring";
run;

data want;
  set have;
  format cammonth season.;
run;

topic VARIABLE CHARACTER in SAS Data Management

VARIABLE CHARACTER

Re: VARIABLE CHARACTER