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
You are close, but make sure the length is sufficient, then,
if limit_set_period = "Day" then limit_set_period = "Daily";
You are close, but make sure the length is sufficient, then,
if limit_set_period = "Day" then limit_set_period = "Daily";
It is simply not a legit SAS code.
That's not valid SAS code...is there some reason you think it is?
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".
Put this statement right after data statement:
data want;
length limit_set_period $10 ;
set have;
blah blah;
run;
Quite possibly the variable has a $3. format associated with it. Add just before the RUN statement:
format limit_set_period;
Would you mind sharing your code?
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.