Plotting Data and output as PDF

[Pritish]

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-...

[Reeza]

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-...

---

[Pritish]

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.