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

[raghidazamzam]

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

[Reeza]

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.

[raghidazamzam]

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

[Reeza]

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

[FreelanceReinh]

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;