I tired correcting this code I was given. However, it is not working. How should I go about correcting it? INITIALLY GIVEN: OPTIONS PS = 58 LS = 8 NODAT NONUMBER DATA sales; INPUT weekof mmddyy8. Store $ Mon Tues Wed Thur Fri; AvgSales = (Mon + Tues + Wed + Thurs + Fri)/4; length Group $6; lable weekof = 'Date; if AvgSales = '.' then Group = 'N/A'; else if AvgSales LE 605 then Group = 'Low'; else if 605 LT AvgSales LE 750 then Group = 'Average'; else if AvgSales GT 75O then Group = 'High'; if Store = 110 then region = 'South'; else if Store = 111 then region = 'South'; GOAL IS TO GET THE FOLLOWING RESULTS - attached else if Store = 112 then region = 'North'; else if Store = 113 then region = 'North'; else if Store = 114 then region = North; drop Mon Tues Wed Thur Fri; DATALINES 10/12/07 11O 412 532 641 701 802 10/12/07 111 478 567 699 789 821 10/12/07 112 399 501 650 712 812 10/12/07 113 421 532 698 756 872 10/12/07 114 401 510 612 721 899 17/12/07 110 710 725 789 721 799 17/12/07 111 689 701 729 703 721 17/12/07 112 899 812 802 738 712 17/12/07 113 700 712 748 765 801 17/12/07 114 699 799 899 608 24/12/07 110 340 333 321 401 490 24/12/07 111 801 793 721 763 798 24/12/07 112 598 798 684 502 412 24/12/07 113 980 921 832 812 849 24/12/07 114 798 709 721 799 724 31/12/07 110 487 321 399 312 321 31/12/07 111 501 532 598 581 601 31/12/07 112 598 512 540 523 549 31/12/07 113 601 625 674 698 601 31/12/07 114 900 805 700 601 811 ; RUN; PROC PRINT data = sales / label; RUN; HOW I HAVE CORRECTED IT SO - STILL NOT WORKING DATA sales; input Date $ 1-8 Store 10-12 Mon 14-16 Tues 18-20 Wed 22-24 Thurs 26-28 Fri 30-32; DATALINES; 10/12/07 110 412 532 641 701 802 10/12/07 111 478 567 699 789 821 10/12/07 112 399 501 650 712 812 10/12/07 113 421 532 698 756 872 10/12/07 114 401 510 612 721 899 17/12/07 110 710 725 789 721 799 17/12/07 111 689 701 729 703 721 17/12/07 112 899 812 802 738 712 17/12/07 113 700 712 748 765 801 17/12/07 114 699 799 899 608 . 24/12/07 110 340 333 321 401 490 24/12/07 111 801 793 721 763 798 24/12/07 112 598 798 684 502 412 24/12/07 113 980 921 832 812 849 24/12/07 114 798 709 721 799 724 31/12/07 110 487 321 399 312 321 31/12/07 111 501 532 598 581 601 31/12/07 112 598 512 540 523 549 31/12/07 113 601 625 674 698 601 31/12/07 114 900 805 700 601 811 ; AvgSales=(Mon + Tues + Wed + Thurs + Fri)/5; length Group $6; label week ='Date; if (AvgSales = '.') then Group = N/A; else if (AvgSales <= 605) then Group = Low; else if (AvgSales 605 < sales <=750) then Group = Average; else if (AvgSales sales >750) then Group = High; if Store = 110 then region = South; else if Store = 111 then region = South; else if Store = 112 then region = North; else if Store = 113 then region = North; else if Store = 114 then region = North; drop Mon Tues Wed Thur Fri; OPTIONS PS = 58 LS = 8 NODAT NONUMBER RUN; PROC PRINT data=sales / label; RUN;
... View more
