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?
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.