topic Re: repalce certain values for a variable in SAS Programming

repalce certain values for a variable

fengyuwuzu — Thu, 25 Feb 2016 16:04:56 GMT

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 — Thu, 25 Feb 2016 16:10:10 GMT

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

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

fengyuwuzu — Thu, 25 Feb 2016 16:15:22 GMT

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

Haikuo — Thu, 25 Feb 2016 16:20:48 GMT

It is simply not a legit SAS code.

Reeza — Thu, 25 Feb 2016 16:21:08 GMT

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

fengyuwuzu — Thu, 25 Feb 2016 16:42:53 GMT

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

fengyuwuzu — Thu, 25 Feb 2016 17:00:23 GMT

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 — Thu, 25 Feb 2016 17:03:14 GMT

Put this statement right after data statement:

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

fengyuwuzu — Thu, 25 Feb 2016 17:12:40 GMT

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

Astounding — Thu, 25 Feb 2016 17:33:59 GMT

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

format limit_set_period;

Haikuo — Thu, 25 Feb 2016 17:36:26 GMT

Would you mind sharing your code?

fengyuwuzu — Thu, 25 Feb 2016 19:19:53 GMT

yes, this works!! Thanks!