Hi All, I tried to import an excel dataset to SAS 9.4, and got some blank data if the cell has a green triangle on the top left in excel spreadsheet. I understand that was a error indicator telling me a mix format of the column. For a small excel dataset, I can find and fix it in excel before importing to SAS using either IMPORT Wizard or PROC IMPORT. If I have large dataset and many columns it will be time consuming. Can anyone help what SAS statement I should use to take care of those problem green triangle? So far, I used code and data as shown in attached file. Rows 810-813 of column C (Acuity level) were ok, but row 814 and after were blank after import. Thanks.
... View more