Hi all,
I'm having some trouble dealing with my data set. First my orginal data FREQ looks like this:

I want to clean the data set and turned them into number so I write these codes:
data hth1n18.data;
set hth1n18.data;
If Qu_11 = 'Very Low' then Qu_11=1;
If Qu_11 = 'Ver Low' then Qu_11=1;
If Qu_11 = 'Very Low ' then Qu_11 = 1;
If Qu_11 = 'Low' then Qu_11 = 2;
If Qu_11 = 'Medium' then Qu_11 =3;
If Qu_11 = 'Meduim' then Qu_11 = 3;
If Qu_11 = 'High' then Qu_11 =4;
If Qu_11 = 'Very High' then Qu_11 = 5;
run;
Now my FREQ looks like this, I have duplicate value in the FREQ table. Also I cannot run the proc means for this variable.

Proc means show the following error:
103 Proc Means data=hth1n18.data Maxdec=2 Mean Median Min Max;
104 var Qu_11;
ERROR: Variable Qu_11 in list does not match type prescribed for this list.
105 run;
Please help! Thanks a lot 😄 😄