@vicdicenzo wrote:
Thanks, but pounds is not a character variable - it is numeric (not currency). There are just a number of missing cells. I cannot use prof freq because I am trying to compute a mean.
I did not say to use Proc Freq to calculate your wanted result but to examine the values actually occurring in your data set.
It is quite possible that if a column that should be numeric but gets imported as character is shorter than needed. You might expect that you have a value of 135.46 in your data but the IMPORTED character variable only holds 13 (or even 1). Proc Freq will show the characters values read so that you can verify that the expected values were read. Then if so, a correct numeric variable can be created using the INPUT function so you can calculate your needed mean.
Did you try the example data step to convert the character values to numeric?
If not, why not?
... View more