I have delimited txt files that I want to import into SAS. Each contains character and numeric variables, some of which are more interesting than others. Each file contains millions of records, so importing all of the cases and all of the variables is taking way too long. I'm currently running a proc import (sample code below), but it's taking forever. Is there a more efficient way to do this? Can the proc import specify certain variables to drop before even reading in the program datavector? For instance, if I only want to import var1 and var3, can I specify that in the proc import? sample code: proc import datafile="C:\rawdata\sales.txt" out=output.sales dmbs=dlm; delimiter="|"; getnames=yes; run; data sales_small; set output.sales (keep= var1 var3); run;
... View more