Dear colleagues, I'm importing Excel file[.xlsx] via the import data wizard. One of the columns contains missing data, some numeric values [right aligned in Excel], some text values [left aligned in Excel] When I reach the stage where I can amend the attributes of the columns the suggestion from SAS is that this should be a numeric column and the Type is slightly greyed out. I wasn't able to change the type directly from the row, but when I selected it I succeeded via Modify in the bottom right corner. I have set this to String and with enough length to accommodate all text data. I think as a result SAS imports that variable as numeric and then converts it to text. The text in not imported and all the missing data has . [dot], which is left aligned. I should probably mention that the file is pass protected, but I have it opened. Can I just ask, why the attributes are greyed out and why when specifically instructed to import string fails to do so... I do apologise but it is clients data, so I cannot share any Thank you Kind regards Marin
... View more