I am trying to import a very large text file into SAS. For various reasons, I can't just create code and run a data step. So I am attempting to read it in in pieces using the Import Wizard using "Data records starts at" and "Limit the number of records to". It is spending a lot of time examining millions of records for file attributes, then creating a cleansed copy before writing out to permanent storage. I went into the Performance options in the Wizard and set max rows for attributes to 500,000 and no cleansed copy but it is still doing them. Why is this happening and how do I fix so it doesn't take hours for each partition?
... View more