There are values in your BMI column in your Excel sheet that are causing it to import as a character. I can tell from the following notes in your data step log: NOTE: Invalid numeric data, BMI='N.A' , at line 84 column 9. NOTE: Invalid numeric data, BMI='N.A' , at line 85 column 15. The following notes are also showing that BMI is currently a character variable: NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column). 84:9 85:15 91:22 You can either clean the character values out of the spreadsheet and try to import it, or create a new BMI variable that just uses the numeric values from BMI (e.g. BMI2=bmi*1). It looks like the same thing is happening for your progesterone _nmol_l variable.
... View more