I exported the database to a text file and found that the data was stored in a text field as "3;4;6”.
Not sure if that matters, but the answers were associated with another table which store the underlying coding ; ie. when one select Banana, Melon and Strawberry in the form, it will be stored as “3;4;6” as above.
SAS was able to read it as Character field and displayed as a single digit character (length=3 format=$3. Informat=$3.) in the SAS viewer. However the PROC FREQ procedure suggested the frequency as follow (the layout is edited to fit the display on this forum). :
Q2ID --- Frequency --- Percent --- Cumulative Frequency --- Cumulative Percent
---------------------------------------------------------------------------------------
3 0 --- 3 --- 0.53 --- 165 --- 29.36
3 1 --- 1 --- 0.18 --- 166 --- 29.54
3 2 --- 2 --- 0.36 --- 168 --- 29.89
I was confused, b/c in the dataset, I was not able to find anything like 3 0, 3 1 or 3 2 ...
... View more