BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
Primavera
Quartz | Level 8

Hi,

 

I am trying to do a very simple FH test using a very simple 3X3 test using SAS 9.4. When I try a 2X2 table and the chi-square test it works but my 3X3 table just gets populated with ones after running the proc freq and I get wrong answers. Here is my code:

data mydata;
   input  outcome $ msgroup $ count;
   datalines;
inc PT 6 
inc FT 11
inc surg 12
dec PT 3
dec FT 4
dec surg 2
unch PT 8
unch FT 2
unch surg 3
;
run;

proc freq data=mydata;
   tables outcome*msgroup  / chisq exact;
run;

Do you know what is happening here? 

 

Thanks,

1 ACCEPTED SOLUTION

Accepted Solutions
Watts
SAS Employee

It looks like you probably need to add a WEIGHT statement. Otherwise, each observation is assigned a frequency of 1.  

Weight count;

View solution in original post

2 REPLIES 2
Watts
SAS Employee

It looks like you probably need to add a WEIGHT statement. Otherwise, each observation is assigned a frequency of 1.  

Weight count;
Primavera
Quartz | Level 8

Thank you very much. That was exactly what was missing from my proc freq.

sas-innovate-2024.png

 

Time is running out to save with the early bird rate. Register by Friday, March 1 for just $695 - $100 off the standard rate.

 

Check out the agenda and get ready for a jam-packed event featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events. 

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 418 views
  • 1 like
  • 2 in conversation