@DanielePugno wrote:
First of all, thank you for your help! I saw in the import output that F7 column is taken as alfanum, but in excel (input file) the cells type is "number" and the content is only the value 0 or 1. How can I change the type of f7,F8 and ecc from Alfanum in Num? Thank you for your consideration!
Proc import by default only examines a very few rows of data. If a "column" is blank for the first few rows then that is a typical cause of a $1. informat. So I might look back to your Excel file and see about how many blanks exist in the source.
Note: this is just one frequent problem related to Import, which is a guessing procedure, and spreadsheet files.
... View more