topic Re: How to handle large volume of data and large number of columns by using PROC REPORT step in SAS Programming https://communities.sas.com/t5/SAS-Programming/How-to-handle-large-volume-of-data-and-large-number-of-columns/m-p/621461#M182690 <P>Some example data and the Proc Report code could be helpful.</P> <P>&nbsp;</P> <P>Many times pre-summarizing data before a report procedure, either Proc Report or Proc Tabulate, can make a big difference.</P> <P>&nbsp;</P> <P>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.</P> Fri, 31 Jan 2020 16:08:23 GMT ballardw 2020-01-31T16:08:23Z How to handle large volume of data and large number of columns by using PROC REPORT step https://communities.sas.com/t5/SAS-Programming/How-to-handle-large-volume-of-data-and-large-number-of-columns/m-p/621446#M182684 <P>Hi All,</P><P>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?.</P><P>&nbsp;</P><P>Thanks,</P><P>Rani</P> Fri, 31 Jan 2020 15:19:46 GMT https://communities.sas.com/t5/SAS-Programming/How-to-handle-large-volume-of-data-and-large-number-of-columns/m-p/621446#M182684 Rani1 2020-01-31T15:19:46Z Re: How to handle large volume of data and large number of columns by using PROC REPORT step https://communities.sas.com/t5/SAS-Programming/How-to-handle-large-volume-of-data-and-large-number-of-columns/m-p/621461#M182690 <P>Some example data and the Proc Report code could be helpful.</P> <P>&nbsp;</P> <P>Many times pre-summarizing data before a report procedure, either Proc Report or Proc Tabulate, can make a big difference.</P> <P>&nbsp;</P> <P>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.</P> Fri, 31 Jan 2020 16:08:23 GMT https://communities.sas.com/t5/SAS-Programming/How-to-handle-large-volume-of-data-and-large-number-of-columns/m-p/621461#M182690 ballardw 2020-01-31T16:08:23Z