How to handle large volume of data and large number of columns by using PROC REPORT step

[Rani1]

Hi All,

Currently, I'm facing performance issue in one of my SAS report. The issue is that, The report is taking(30 minute) more time to run due to large volume of data and large number of columns. I'm are having 170 columns and 50,000+ records in the data set. I have used PROC REPORT step to load the data to excel(Used STPBEGIN and STPEND to load the data into excel) in Stored Process and PROC STEP is running around 30 mins due to 156 columns and 50,000+ records. How to run the reduce the report run time without minimizing the columns?.

Thanks,

Rani

[ballardw]

Some example data and the Proc Report code could be helpful.

Many times pre-summarizing data before a report procedure, either Proc Report or Proc Tabulate, can make a big difference.

Also with your statement of "156 columns" the main issue might be just creating the ods table structure prior to output and not actually calculations, in which case there may not be much that would reduce time.