Date:         Thu, 20 Nov 2008 10:33:04 -0500
Reply-To:     joey m <sasuser.joey.m@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         joey m <sasuser.joey.m@GMAIL.COM>
Subject:      (optionally) ending a process after sql
Content-Type: text/plain; charset=ISO-8859-1

Hi there:

I have the following code, and I would like to end the program in case
the p-value is >0.05; but if it isn't (i.e. p<=0.05), thereafter I would
like to run any other code.

Many shall find it easy, but it is still a difficult one to me. Any
suggestion is welcome.

Thanks in advance.


*

data* react;

input Stim Time @@;

datalines;

1 1.94 1 1.94 1 2.92 1 2.92 1 2.92 1 2.92 1 3.27

1 3.27 1 3.27 1 3.27 1 3.70 1 3.70 1 3.74

2 3.27 2 3.27 2 3.27 2 3.70 2 3.70 2 3.74

3 2.25 3 3.21 3 1.35 3 3.7 3 2.5 3 3.5

;
*

proc* *npar1way* wilcoxon data=React;

class Stim;

var Time;

exact wilcoxon;

ods output kruskalwallistest=kw_test;

*run*;
*

proc* *sql*;

select cValue1 into:KW_pvalue

from kw_test where name1="XP_KW";

/* if exact p-value is >0.05, I want to stop the program,

if not, do proc means (or any other code thereafter) */
*

proc* *means* data=react;
*

run*;