No, with the formatted values I was using, even the format “DOLLAR32.” would not have worked. I had to mimic the appearance of a PDF the researcher I was collaborating with was using. For instance, one of the formatted values—the exact string (inside the double quotation marks)—was “$50,000 to $74,999”. Another formatted value I had to use was literally “$100,000 or more”. I used much simpler formatted values than those in my original post because I was trying to narrow down what the factors are that, together, reproduce the errors in the log. My boss and I initially suspected that the problem was caused by some kind of cell width issue in Excel, but as my original post implies (where the maximum string-length out of all the formatted values of that variable is 3), that is not the case. And as your first post indicates, you were able to sidestep the errors by using the LIST option in PROC FREQ, further narrowing down what causes the errors.
... View more
