topic Re: Plotting Data and output as PDF in SAS Enterprise Guide

Plotting Data and output as PDF

Pritish — Sun, 29 Mar 2020 17:27:29 GMT

I have a dataset with millions of rows and around 500 variables. For each of these 500 variables, I am trying to generate a plot using gplot and save the output to a PDF file. However, the problem is my code ran for more than 18 hours and still it had only processed around 150 variables. I believe it is taking long primarily because I am saving my output to a PDF file (reviewed below forum discussion which probably supports my hypothesis). I am wondering if there is a better alternative that I can leverage to a. Speeds up the process b. Output graphs for all 500 variables either to excel/XML/pdf/RTF.

https://communities.sas.com/t5/SAS-Enterprise-Guide/PROC-GPLOT-takes-a-LONG-time-to-create-a-PDF/td-p/65299

Re: Plotting Data and output as PDF

Reeza — Sun, 29 Mar 2020 17:46:24 GMT

Please post your code so we can se if we can make it more efficient. Have you turned off other destinations? And have you tried SGPLOT? It's supposed to be a newer proc, so it may be more efficient in terms of resources. Are you using a macro to run it for each PDF or using call execute or by group processing????

@Pritish wrote:

Hi

I have a dataset with millions of rows and around 500 variables. For each of these 500 variables, I am trying to generate a plot using gplot and save the output to a PDF file. However, the problem is my code ran for more than 18 hours and still it had only processed around 150 variables. I believe it is taking long primarily because I am saving my output to a PDF file (reviewed below forum discussion which probably supports my hypothesis). I am wondering if there is a better alternative that I can leverage to a. Speeds up the process b. Output graphs for all 500 variables either to excel/XML/pdf/RTF.

https://communities.sas.com/t5/SAS-Enterprise-Guide/PROC-GPLOT-takes-a-LONG-time-to-create-a-PDF/td-p/65299

Re: Plotting Data and output as PDF

Pritish — Mon, 30 Mar 2020 18:25:37 GMT

Thank you for the suggestion on SGPlot. I have changed my code and am currently in the process of testing it. Will share an update once I have the output.

One related question I have regarding exporting output of sgplot results to excel - Is there a way, we can specify where the output of the sgplot should be placed on the excel file? For example: If I am generating three graph - I would want graph one and two side by side and the third graph below graph 1.