Hi @pearson101 ,
PROC X11 allows you to specify more than one variable in the VAR statement, therefore, you can obtain your desired output data set by specifying something like the following, where Var1, Var2, Var3 and Var4 are the analysis variables:
proc x11 data = _all_clean_non noprint;
monthly additive date = date_new;
by district;
var var1 var2 var3 var4;
tables a1 d12;
output out = test_all_mal a1 = var1 var2 var3 var4
d12 = var1_adj var2_adj var3_adj var4_adj;
run;
For more details, please see the following link to the OUTPUT statement in the PROC X11 documentation:
https://go.documentation.sas.com/?docsetId=etsug&docsetTarget=etsug_x11_syntax08.htm&docsetVersion=15.2&locale=en
If you have a large number of analysis variables and you do not want to list out the variable names in the A1= and D12= options in the OUTPUT statement, then you might want to consider using PROC X13 for your analysis rather than PROC X11. The following code will perform a similar analysis to the code above without having to specify the variable names in the OUTPUT statement. They are generated automatically by the procedure:
proc x13 data=_all_clean_non noprint date=date_new interval=month;
by district;
var var1 var2 var3 var4;
x11 mode=add;
output out=test_all_mal a1 d12;
run;
In this case, the OUT= data set generated by PROC X13 will have variables:
district date_new var1_a1 var1_d12 var2_a1 var2_d12 ... var4_a1 var4_d12
The D12 table results generated by PROC X13 might be slightly different than those generated by PROC X11 due to updates to the Census Bureau algorithms used to generate the trend-cycle component.
I hope this helps you generate the output data set you want to use in your subsequent PROC SGPANEL steps.
DW
... View more
