Hello, We work with big files. They are more 8000000 rows and more than 2000 columns. Our program runs for 4 hours. We want to improve the running time of the program. I changed all merge section to sql code. It’s don’t help me very much. My program now runs for 3:45 hours. I tried using simple data set statements and used SPDE files and indexes. I removed all proc sort statements--now my program runs for 3:25 hours. May be you have another idea how can I improve the running time of the program. Many thanks, Irena
... View more