Hello,   This is my current code:   libname Example "~/my_courses/Homework/FinalHomework"; data Sugar; length DistrictGroup $ 30; 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; data SugarLong;  set Sugar; array mon{*} _numeric_; do _n_=9 to dim(mon); Month=vname(mon[_n_]); Count=mon[_n_]; output; end; drop Month DistrictGroup 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; data SugarLongResult;   set SugarLong;   select;     when (Count > 0) Result='Yes';     otherwise Result='No';     end;     Proc print data=SugarLongResult (obs=50); var District DistrictPosition Result; print; proc sort data=SugarLongResult out=SugarLongResultDupe NODUPKEY;   by District DistrictPosition Result; run; proc freq data=SugarLongResultDupe; tables DistrictPosition* Result / out=SugarLongResultFinal; run; proc print data=SugarLongResultFinal; run;   There are only 15 District options but the output is currently adding up to 20. The problem seems to be with S, W, and C, it looks like it's including the count of No in both No and Yes.   The correct numbers are below:   DistrictPosition Result Count N Yes 2 N No 0 E Yes 2 E No 0 S Yes 0 S No 2 W Yes 4 W No 2 C Yes 2 C No 1   This is the current output which is almost correct: ... View more

Hello, I am trying to create a new column of a count based on multiple conditions.   Current Code: libname Example "~/my_courses/Homework/FinalHomework"; data Sugar; length DistrictGroup $ 30; 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; data SugarLong;  set Sugar; array mon{*} _numeric_; do _n_=9 to dim(mon); Month=vname(mon[_n_]); Count=mon[_n_]; output; end; drop Month District 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; data SugarLongResult;   set SugarLong;   select;     when (Count > 0) Result='Yes';     otherwise Result='No';     end; Proc print data=SugarLongResult (obs=10); print;   My current output:                                                             DistrictGroup     Count    Result 123456789101112131415161718 Cairns/Mulgrave(dry) 0.0 No Cairns/Mulgrave(dry) 6.0 Yes Cairns/Mulgrave(dry) 0.0 No Cairns/Mulgrave(dry) 308.0 Yes Cairns/Mulgrave(dry) 35.0 Yes Cairns/Mulgrave(dry) 353.5 Yes Cairns/Mulgrave(dry) 505.0 Yes Cairns/Mulgrave(dry) 476.0 Yes Cairns/Mulgrave(dry) 453.0 Yes Cairns/Mulgrave(dry) 0.0 No Cairns/Mulgrave(dry) 220.0 Yes Cairns/Mulgrave(dry) 127.0 Yes Cairns/Mulgrave(dry) 47.0 Yes Cairns/Mulgrave(dry) 48.0 Yes Cairns/Mulgrave(dry) 73.0 Yes Cairns/Mulgrave(dry) 66.0 Yes Cairns/Mulgrave(dry) 198.0 Yes Cairns/Mulgrave(dry) 222.0 Yes What I'm looking to do is to get the data grouped by district group and yes/no (From above Data):      District Group           Result          CountFinal Cains/Mulgrave(Dry)       Yes                 15 Cains/Mulgrave(Dry)       No                   3   All help is appreciated (:! ... View more

Hello,   I am creating a code to view the district position and soil type. I wanted to create a count for the soil type so instead of the data being like this:   DistrictPosition SoilID SoilName            S                 838       Prior            N                 802     Liverpool            N                 802     Liverpool            N                 802     Liverpool            N                 803     Brosnan   To this: I need to remove soilname, I am running a dataset with 3775 lines but condensed it to just the 5.   DistrictPosition SoilID  Count            S                 838        1            N                 802        3            N                 803        1   Hopefully this is possible,   I appreciate the help! ... View more

Hello,   I am trying to transpose this data - I am struggling with the months because they have different characters:   libname Example "~/my_courses/Homework/FinalHomework"; data Sugar; infile '~/my_courses/Homework/FinalHomework/CaneDataTestChi.csv/' dsd firstobs=2; input DistrictGroup $ Direction $ Jul96 Aug96 Sep96 Oct96; ; run;   proc print data=Sugar; run;   To make it from:   DistrictGroup Direction Jul96 Aug96 Sep96 Oct96 Region1                S             1         2         3           4 Region1                E             5         6         7           8 Region2                E             9         10       11         12 Region3                N             13       14       15         16   To:   DistrictGroup Month Amount Region1            Jul96       1 Region1            Jul96       5 Region2            Jul96       9 Region3            Jul96      13 Region1            Aug96      2 Region1            Aug96      6 Region2            Aug96      10 Region3            Aug96      14 ...   Thank you! ... View more

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; ... View more

Hello,   I'm trying to make a graph where the y axis is DBP and the x-axis is SBP which I got.   But I need to make the symbol based on the race of the clinic data, some of the datalines are B and some are W.   How do I make the graph only show the numbers based on people who are labeled B?   Currently I'm making a graph that shows both B and W.   proc plot data=CLINIC; plot DBP*SBP=RACE; run;   Thank you, I appreciate it ... View more