ETS: How to extract more displayed tables into data sets, besides A1, D11..

[tanyuanbin]

Hi,

Does anyone can help on this:

When I ran X12 procedure, I need to output the forecasts table into a data set, however, the OUT= option can not do this table of ForecastCL, it marks as 'P'. the helper also said 'Data from displayed tables can be extracted into data sets using the Output Delivery System (ODS). '
But when I checked the section of "Using the Output Delivery System" in the SAS/ETS User's Guide, it looks lacking of detail information.

It would be very much appreciated if anyone would help on this! Thank you!

[udo_sas]

Hello -
Here is what I would do:
First determine the name of the ODS output object by using ODS TRACE statements in the LOG file - for example:
ods trace on;
proc x12 data=sashelp.air date=date;
var air;
transform power=0;
arima model=( (0,1,1)(0,1,1) );
estimate;
run;
ods trace off;
Let's suppose the table you are looking for is called: "AvgFcstErr" - i.e. you should see:

Output Added:
-------------
Name: AvgFcstErr
Label: Average absolute percentage error in within-sample forecasts:
Template: ets.x12.AvgFcstErr
Path: X12.AIR.ModelEstimation.AvgFcstErr

Then the following ODS statement will write this output object into a SAS data set called work.test:
ods output AvgFcstErr=work.test;
proc x12 data=sashelp.air date=date;
var air;
transform power=0;
arima model=( (0,1,1)(0,1,1) );
estimate;
run;
Hope this helps,
Udo

[tanyuanbin]

This really helps. Thank you so much for your time!