![]() ![]() However, for the second widest, which is 1500 characters wide and called FK_code, I get the following in the log: WARNING: Failed to scan text length or time type for column FK_code and the data is truncated to 255 characters on importing from excel. I have used the SAS import wizard and checked the MIXED data option, and also used the PROC IMPORT with MIXED=YES option.įor the widest column, which is 5500 characters wide and called FK_word, SAS imports this variable correctly and no log warnings are issued. However, I don't know why some columns are imported correctly with no truncation, while others are being truncated by SAS. I want to import all or even just some of the columns into SAS keeping the mixed data as character data. The some columns are mixed types with both numeric and character data as wide as 5500 characters. I have an EXCEL spread sheet that has 3000 rows and 140 columns of data. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |