Proc Freq Trend Test Output

[BTAinRVA]

I'm runing the code below to get Cochran-Armitage trend test output for each medical facility. Is there a way to get all test results outputted to a single table? The code below doesn't give me the trend test results.

proc freq data = PPIP_new ;

tables Tmt_ID_Name*PPH*CQ / trend out=trend_data;

title 'trend by MTF for each cq';

run ;

Thanks,

[Reeza]

Use the ODS TABLES. This post details how to filter/select your tables and save them to a dataset.

https://communities.sas.com/t5/SAS-Communities-Library/Okay-ODS-just-give-me-what-I-want/ta-p/221750

[FreelanceReinh · Accepted solution]

Using the ODS tables, as @Reeza has suggested, is always possible. In this specific case, however, I personally would prefer the OUTPUT statement:

proc freq data = PPIP_new;
tables Tmt_ID_Name*PPH*CQ / trend out=trend_data;
output out=catest trend;
title 'trend by MTF for each cq';
run;

(CATEST is just an arbitrary dataset name.)

I find the structure of this output dataset more convenient than that of the TrendTest ODS output dataset, which you could create as follows:

ods output TrendTest=tt;
proc freq data = PPIP_new;
tables Tmt_ID_Name*PPH*CQ / trend out=trend_data;
title 'trend by MTF for each cq';
run;

You will see, for example, that CATEST contains variable Tmt_ID_Name, whereas dataset TT (again an arbitrary name) does not.

[BTAinRVA]

@FreelanceReinh,

Yes, the output using the Output statement is more useful. Many Thanks!