First thing, the code you show will not generate ANY kappa values. You need to use the AGREE option on the tables statement to get them.
Second which "kappa value"?
The procedure would generate two tables, one for the Test statistic and the other Kappa coefficient.
Here is the approach for learning how to select any specific table(s) for output .
First run your code with the option ODS TRACE ON/off such as
ods trace on;
proc freq data=data;
tables var1 * var2 / agree;
test kappa;
run;
ods trace off;
The log will show some details about which tables were generated such as:
Output Added:
-------------
Name: CrossTabFreqs
Label: Cross-Tabular Freq Table
Template: Base.Freq.CrossTabFreqs
Path: Freq.Table1.CrossTabFreqs
-------------
Output Added:
-------------
Name: McNemarsTest
Label: McNemar's Test
Template: Base.Freq.StatFactoid
Path: Freq.Table1.McNemarsTest
-------------
Output Added:
-------------
Name: Kappa
Label: Simple Kappa Coefficient
Template: Base.Freq.StatFactoid
Path: Freq.Table1.Kappa
-------------
Output Added:
-------------
Name: KappaTest
Label: Simple Kappa Test
Template: Base.Freq.StatFactoid
Path: Freq.Table1.KappaTest
-------------
The key part you are looking for is the NAME.
You can then generate output for only the items you want by using ODS select such as:
ods select kappa;
proc freq data=data;
tables var1 * var2 / agree;
test kappa;
run;
will only generate the kappa table results. If want both the Kappa and the Kappatest use both names on the select.
To send to a different destination then you wrap the code generating the bits you want in an ODS destination "sandwich:
ods excel file="<system path>\file.xlsx" <many options may go here>
<code that generates the output you want goes here
can be multiple procedures
>
ods excel close;
That CLOSE is what terminates sending the results to the ods destination and if not present you will not get the desired output.
You can specify different or multiple ODS destinations in a single program
