topic Help with Usage Note 22565: Performing multiple comparisons or tests on subtables in ODS and Base Reporting

Help with Usage Note 22565: Performing multiple comparisons or tests on subtables

raghidazamzam — Fri, 28 Jun 2019 17:40:32 GMT

In reference to Usage Note 22565,

http://support.sas.com/kb/22/565.html

I am trying to run multiple pairwise comparisons using Proc Multtest procedure. So I used

ods output chisq(persist)=chisq(where=(statistic="Chi-Square")
                                      rename=(Prob=Raw_P));

before the multiple tests to save them in chisq. However , I got a message saying

ERROR: You cannot open WORK.CHISQ.DATA for output access with member-level control because WORK.CHISQ.DATA is in use by you in resource environment __ODS_DS.

I followed the step as is. Can you please let me where went wrong!

Thank you,

Raghida

Re: Help with Usage Note 22565: Performing multiple comparisons or tests on subtables

Reeza — Fri, 28 Jun 2019 17:50:23 GMT

You ran it once, have the table open so can't run it again. Or you have a different table with the same name open. You can replace it while it's open.

Re: Help with Usage Note 22565: Performing multiple comparisons or tests on subtables

raghidazamzam — Fri, 28 Jun 2019 18:01:20 GMT

Thank you for your reply! Can you please explain more what table is opened or how to close the table.

Re: Help with Usage Note 22565: Performing multiple comparisons or tests on subtables

Reeza — Fri, 28 Jun 2019 19:11:51 GMT

If you ahve it open to view it's open.

Re: Help with Usage Note 22565: Performing multiple comparisons or tests on subtables

FreelanceReinh — Fri, 28 Jun 2019 19:26:38 GMT

Hi @raghidazamzam,

The PERSIST (or PERSIST=PROC) option of the ODS OUTPUT statement keeps the output dataset (here: CHISQ) open in order to allow each of the six PROC FREQ steps to contribute one observation to it. (Obviously, it's more convenient to end up with one dataset with six obs. than to have six datasets with one obs. each.) Once you submit

ods output clear;

(as suggested in the usage note), the dataset is closed so that you can work with it. This is indicated by the log message

NOTE: The data set WORK.CHISQ has 6 observations and 7 variables.

Alternatively, you can close the OUTPUT destination with

ods output close;