topic Re: duplicate value in proc freq in New SAS User

duplicate value in proc freq

Cassie2 — Mon, 08 Apr 2019 12:53:52 GMT

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 😄 😄

Re: duplicate value in proc freq

PeterClemmensen — Mon, 08 Apr 2019 13:01:56 GMT

This happens because Qu_11 is a character variable and you try to use it in a numeric context. Use some other variable name for you numeric representations and use that in your analysis.

Re: duplicate value in proc freq

Tom — Mon, 08 Apr 2019 13:03:06 GMT

You cannot change the type for a variable once it is set. So SAS will convert the numbers to strings to store them into the character variable. That is why the numbers in your second PROC FREQ are right aligned instead of left aligned.

You cannot take mean of a string.

Make a new variable.

Note that trailing spaces are meaningless to SAS. More likely one of the Very Low values has leading spaces instead.

If left(Qu_11) = 'Very Low' then Qu_11_num = 1;

Re: duplicate value in proc freq

Cassie2 — Tue, 09 Apr 2019 09:35:52 GMT

It worked thank you very much

Re: duplicate value in proc freq

Cassie2 — Tue, 09 Apr 2019 09:36:08 GMT

Thank you!