repalce certain values for a variable

[fengyuwuzu]

In my data set, the variable limit_set_period has both values of "Day" and "Daily". I want to change the "Day" values to "Daily" by

replace limit_set_period = "Daily" if limit_set_period = "Day";

but it does not work

any hints? Thanks

[Haikuo · Accepted solution]

You are close, but make sure the length is sufficient, then,

  if limit_set_period = "Day" then limit_set_period = "Daily";

[fengyuwuzu]

Thank you. Do you know why replace does not work?

[Haikuo]

It is simply not a legit SAS code.

[Reeza]

That's not valid SAS code...is there some reason you think it is? 

[fengyuwuzu]

Thanks. I googled and did not see clearly which software it is. Not I see it is Stata.

[fengyuwuzu]

indeed I have a length issue. I got the new values "Dai" because the length was defined by "Day".

I defined the length by

length limit_set_period $10 ;

before the set statement. I still got "Dai".

[Haikuo]

Put this statement right after data statement:

data want;
length limit_set_period $10 ;
set have;
blah blah;
run;

[fengyuwuzu]

that is where I put it. It does not work. very strange.

[Astounding]

Quite possibly the variable has a $3. format associated with it.  Add just before the RUN statement:

format limit_set_period;

[fengyuwuzu]

yes, this works!! Thanks!

[Haikuo]

Would you mind sharing your code?