topic changing some levels for a character variable in SAS Programming

changing some levels for a character variable

Emma_at_SAS — Fri, 16 Jul 2021 20:47:17 GMT

I have a data set with the list of food items that kids ate during the day. For each category, for example, vegetables, there are words that are misspelled. I created a frequency for the variable vegetable and identified the misspelled words that I need to correct. I want to keep the correct reports as is. The way I introduce ELSE, my code only applies the last IF for lettuce and replaces cabbage with the original cabage. Thanks for your help.

data have;
length vagatables $ 20;
length fruits $ 20;
input vagetables $ fruits $ ;
datalines;
cabage orange
cabbage apple
carrot strwberry
lettuce apple
Letuce cherry
;
run;
proc print data=have; run;

data want;
set have;
if vagetables = "cabage" then vagetables_new="cabbage";
if vagetables = "Letuce" then vagetables_new="lettuce";
else vagetables_new=vagetables;
run;
proc print data=want; run;

The dataset have

Obs	vagetables	fruits
1	cabage	orange
2	cabbage	apple
3	carrot	strwberry
4	lettuce	apple
5	Letuce	cherry

The dataset want

Obs	vagetables	fruits	vagetables_new
1	cabage	orange	cabage
2	cabbage	apple	cabbage
3	carrot	strawberry	carrot
4	lettuce	apple	lettuce
5	Letuce	cherry	lettuce

Re: changing some levels for a character variable

Rydhm — Fri, 16 Jul 2021 20:50:26 GMT

You need to use else if

if vagetables = "cabage" then vagetables_new="cabbage";
else if vagetables = "Letuce" then vagetables_new="lettuce";
else vagetables_new=vagetables;

The last else otherwise which change all values to old ones.

Re: changing some levels for a character variable

Emma_at_SAS — Fri, 16 Jul 2021 21:03:51 GMT

Thank you, @Rydhm. It is fixed!

data want;
set have;
if vagetables = "cabage" then vagetables_new="cabbage";
if vagetables = "letuce" then vagetables_new="lettuce";
else if vagetables notin ("cabage","letuce") then vagetables_new=vagetables;
run;
proc print data=want; run;

The SAS System

Obs	vagetables	fruits	vagetables_new
1	cabage	orange	cabbage
2	cabbage	apple	cabbage
3	carrot	strwberry	carrot
4	lettuce	apple	lettuce
5	letuce	cherry	lettuce