05-10-2012 04:27 PM
I'm using an Excel Spreadsheet to import data and was wondering what changes I need to make or be concerned about when going from a variable length record to a fixed one. Especially when it comes to the options settings I am using (i.e. GETNAMES, SCANTEXT, etc.). I'm looking more for generic answers than specific ones here.
05-10-2012 04:38 PM
SAS's PROC IMPORT will use the maximum number of columns that it observes in the rows that are scanned to determine a size unless you do a manual override. It's in the documentation for SCANTEXT and TypeGuessingRows.
I'm not sure how the EGuide import wizard does it, though I've generally found it to be accurate.