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.
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.
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.
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.