I am trying to use an array to clean my data, I have tried a few different things and nothing seems to really change what I am seeing, either in the data or the log. array optionschar {4} $ gender
Marital_Status
Game_Attendance
games_attended;
do i = 1 to 10;
if optionschar{i} = "Male" then optionschar{i} = "M";
if optionschar{i} = "m" then optionschar{i} = "M";
if optionschar{i} = "Female" then optionschar{i} = "F";
if optionschar{i} = "Mar" then optionschar{i} = "M";
if optionschar{i} = "Married" then optionschar{i} = "M";
if optionschar{i} = "Single" then optionschar{i} = "S";
if optionschar{i} = "999" then optionschar{i} = ".";
if optionschar{i} = "Four" then optionschar{i} = "4";
end;
drop i;
keep gender Marital_Status Game_Attendance games_attended;
run;
... View more