topic Re: Formatting Chi-Sq Data in SAS Studio

Formatting Chi-Sq Data

cassylovescats — Wed, 20 Nov 2019 20:04:51 GMT

Hello,

I need to run chi-sq tests for a final project for school and I was not taught how to manipulate the data to make it a format to run the test when pulling data from a library/csv file. I am trying to do DistrictGroup vs. Monthly Rainfall with the amount of rainfall as the count.

I need the data to look like this:

Month

District Group Jul96 Aug96 Sep96 ...

Cairns/Mulgrave(Dry) 0 6 0

NorthCairns 45.8 9.6 7.4

...

Input DisrictGroup $ Month $ Count;

Datalines;

Cairns/Mulgrave(Dry) Jul96 0

Cairns/Mulgrave(Dry) Aug96 6

Cairns/Mulgrave(Dry) Sep96 0

NorthCairns Jul96 45.8

NorthCairns Aug96 9.6

NorthCairns Sep96 7.4

I attached my data.

This is my current code:

libname Example "~/my_courses/Homework/FinalHomework";

data Sugar;
infile '~/my_courses/Homework/FinalHomework/CaneData2.csv/' dsd firstobs=2;
input District $ DistrictGroup $ DistrictPosition $ SoilID SoilName $ Area Variety $ Ratoon $ Age HarvestMonth HarvestDuration TonnHect Fibre Sugar Jul96 Aug96 Sep96 Oct96 Nov96 Dec96 Jan97 Feb97 Mar97 Apr97 May97 Jun97 Jul97 Aug97 Sep97 Oct97 Nov97 Dec97;
;
run;

proc freq data=Sugar (obs=200);
tables DistrictGroup * Month / chisq expected cellchi2;

weight Count;
run;

Re: Formatting Chi-Sq Data

PGStats — Wed, 20 Nov 2019 20:19:11 GMT

@cassylovescats wrote:

I am trying to do DistrictGroup vs. Monthly Rainfall with the amount of rainfall as the count.

Chi-Square tests are for counts, not amounts. So a Chi-Square test might be used to compare the number of days with rainfall, but not total rainfall.

Re: Formatting Chi-Sq Data

cassylovescats — Wed, 20 Nov 2019 20:23:20 GMT

If I changed it, how do I still format the code?

I have to run multiple different tests but am stuck on the code to get it to move all of the dates to one column and all of the numbers to a second column.

I am not very good at SAS and do not have guidance.

Re: Formatting Chi-Sq Data

Reeza — Wed, 20 Nov 2019 20:26:12 GMT

Transposing data tutorials:

Wide to Long:
https://stats.idre.ucla.edu/sas/modules/how-to-reshape-data-wide-to-long-using-proc-transpose/

https://stats.idre.ucla.edu/sas/modules/reshaping-data-wide-to-long-using-a-data-step/

Looks like that's a proc transpose. See the tutorials linked above on how to wrangle your data.

@cassylovescats wrote:

If I changed it, how do I still format the code?

I have to run multiple different tests but am stuck on the code to get it to move all of the dates to one column and all of the numbers to a second column.

I am not very good at SAS and do not have guidance.