/* This part of the program inputs the Plano Sales Tax Revenue Data. */ data Plano; input month $ 1-3 yr 4-5 rev; title 'Plano Sales Tax Revenue Data'; title2 'By Month'; datalines; Feb90 2068592 Mar90 867387 Apr90 791878 May90 1731316 Jun90 911839 Jul90 909258 Aug90 1826999 Sep90 964868 Oct90 1020941 Nov90 1881435 Dec90 1075607 Jan91 964977 Feb91 2699324 Mar91 884494 Apr91 1035007 May91 1930143 Jun91 1124814 Jul91 1098136 Aug91 1812798 Sep91 1095294 Oct91 1163039 Nov91 1920424 Dec91 1000743 Jan92 1075763 Feb92 2341127 Mar92 1062449 Apr92 1120898 May92 1939866 Jun92 1316907 Jul92 1284888 Aug92 2098891 Sep92 1375423 Oct92 1201251 Nov92 2165295 Dec92 1301110 Jan93 1251165 Feb93 2986796 Mar93 1271028 Apr93 1228055 May93 2349629 Jun93 1385267 Jul93 1537452 Aug93 2576586 Sep93 1642938 Oct93 1577049 Nov93 2765401 Dec93 1940847 Jan94 1640531 Feb94 3271545 Mar94 1383909 Apr94 1495825 May94 2772734 Jun94 1592051 Jul94 1560732 Aug94 2773904 Sep94 1523255 Oct94 2013622 Nov94 2957306 Dec94 1789103 Jan95 1848972 Feb95 3507801 Mar95 1821378 Apr95 1930585 May95 2823010 Jun95 1970356 Jul95 1970534 Aug95 2982305 Sep95 1795240 Oct95 2145180 Nov95 3021075 Dec95 1908781 Jan96 1957956 Feb96 3955970 Mar96 2119970 Apr96 2208176 May96 3063504 Jun96 2190613 Jul96 2197082 Aug96 3085586 Sep96 2642591 Oct96 2550586 Nov96 3230872 Dec96 2482466 Jan97 2315274 Feb97 4388396 Mar97 2335249 Apr97 1956240 May97 3183566 Jun97 2421722 Jul97 1879301 Aug97 3094563 Sep97 2599894 Oct97 2320012 Nov97 3518486 Dec97 2407487 Jan98 2291118 Feb98 4813948 Mar98 2380134 Apr98 2223477 May98 3378416 Jun98 2876314 Jul98 2650942 Aug98 3788448 Sep98 2651506 Oct98 2450710 Nov98 4118992 Dec98 2434040 Jan99 2763878 Feb99 5227962 Mar99 2762093 Apr99 2528931 May99 4040412 Jun99 2883152 Jul99 3100274 Aug99 4149743 Sep99 3061236 Oct99 2805394 Nov99 3962285 Dec99 3197688 Jan00 3149649 Feb00 5401137 Mar00 3393528 Apr00 2852524 May00 4708691 Jun00 3567883 Jul00 3405732 Aug00 4885709 Sep00 4142396 Oct00 3564755 Nov00 4794159 Dec00 3459785 Jan01 3600702 Feb01 5789400 Mar01 3283596 Apr01 3411052 May01 4783941 Jun01 3706871 Jul01 3756080 Aug01 4318154 Sep01 3201376 Oct01 3502712 Nov01 4864603 Dec01 3108517 Jan02 3357796 Feb02 5904823 Mar02 2951480 Apr02 3185525 May02 4729624 Jun02 3282329 Jul02 3271971 Aug02 4559047 Sep02 3350292 Oct02 3286394 Nov02 4566940 Dec02 2863028 Jan03 3049842 Feb03 5780438 Mar03 3286533 Apr03 3016081 May03 4533575 Jun03 3296881 Jul03 3535071 Aug03 5290070 Sep03 3323063 Oct03 3318144 Nov03 5206490 Dec03 3240679 Jan04 3673046 Feb04 6166054 Mar04 3573983 Apr04 2999256 May04 5177550 Jun04 3845943 Jul04 3492933 Aug04 4975878 Sep04 3531498 Oct04 3611446 Nov04 5145814 Dec04 3260597 Jan05 3715755 Feb05 6239931 Mar05 3730730 Apr05 3431157 May05 5404423 Jun05 4049371 Jul05 3648390 Aug05 5394527 Sep05 3968853 Oct05 3970771 Nov05 5384216 ; DATA plano; SET plano; t = _n_; t2 = t*t; if month = 'Jan' then d1 = 1; else d1 = 0; if month = 'Feb' then d2 = 1; else d2 = 0; if month = 'Mar' then d3 = 1; else d3 = 0; if month = 'Apr' then d4 = 1; else d4 = 0; if month = 'May' then d5 = 1; else d5 = 0; if month = 'Jun' then d6 = 1; else d6 = 0; if month = 'Jul' then d7 = 1; else d7 = 0; if month = 'Aug' then d8 = 1; else d8 = 0; if month = 'Sep' then d9 = 1; else d9 = 0; if month = 'Oct' then d10 = 1; else d10 = 0; if month = 'Nov' then d11 = 1; else d11 = 0; if month = 'Dec' then d12 = 1; else d12 = 0; run; /* Here we are using the autocorrelated DTDS model to test comprehensively for Trend, Curvature of the slope, Seasonality, and Jointly, testing for Trend and Seasonality. */ ods html; ods graphics on; proc autoreg data = plano; model rev = t t2 d2 d3 d4 d5 d6 d7 d8 d9 d10 d11 d12/ nlag = 4 DW=4 DWPROB method=ml backstep slstay=0.05; Trend: test t,t2; Curvature: test t2; Season: test d2,d3,d4,d5,d6,d7,d8,d9,d10,d11,d12; Trend_Season: test t,t2,d2,d3,d4,d5,d6,d7,d8,d9,d10,d11,d12; run;