topic Re: Proc Freq Trend Test Output in SAS Procedures

Proc Freq Trend Test Output

BTAinRVA — Mon, 04 Jan 2016 17:00:01 GMT

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,

Re: Proc Freq Trend Test Output

Reeza — Mon, 04 Jan 2016 17:19:42 GMT

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

Re: Proc Freq Trend Test Output

FreelanceReinh — Mon, 04 Jan 2016 17:35:18 GMT

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.

Re: Proc Freq Trend Test Output

BTAinRVA — Mon, 04 Jan 2016 18:40:04 GMT

@FreelanceReinh,

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