Exporting data from graphs created in PROC step.

Kevin_L_ — Thu, 14 Feb 2019 21:06:34 GMT

Is there a way to tell SAS to create a data set with the data used to create graphs in PROC steps?

For example, in PROC VARMAX, the procedure produces a "Prediction Error Diagnostics Plot" which shows the ACF, PACF and IACF. I would like to save the data that produced those graphs into a SAS data set to create them in Excel.

Thanks.

Re: Exporting data from graphs created in PROC step.

Reeza — Thu, 14 Feb 2019 21:32:48 GMT

Yes! Most of the time at least.

You run the proc, with ODS TRACE ON before and after, find the graph name and save that as an output data set.

https://blogs.sas.com/content/iml/2017/01/09/ods-output-any-statistic.html

Here's an example for a different plot, I couldn't find the specific one you mentioned in the output so you likely are specifying an option somewhere. Table Names are also listed here: https://documentation.sas.com/?docsetId=etsug&docsetTarget=etsug_varmax_details85.htm&docsetVersion=15.1&locale=en

Line in red captures the data for the error distribution plot.

ods output ErrorDistribution = myGraphData;
proc varmax data=sashelp.workers plot(unpack)=(residual model forecasts);
   id date interval=month;
   model electric masonry / dify=(1,12) noint p=1;
   output lead=12;
run;

@Kevin_L_ wrote:

Is there a way to tell SAS to create a data set with the data used to create graphs in PROC steps?

For example, in PROC VARMAX, the procedure produces a "Prediction Error Diagnostics Plot" which shows the ACF, PACF and IACF. I would like to save the data that produced those graphs into a SAS data set to create them in Excel.

Thanks.

topic Re: Exporting data from graphs created in PROC step. in ODS and Base Reporting

Exporting data from graphs created in PROC step.

Re: Exporting data from graphs created in PROC step.