I've attached the excel sheets. I created the smaller list to try evening out the number of variables in each column and make things more manageable. When I use it with this code I don't get any p values or F value and the degrees of freedom for each variable displays zero.
proc anova data=cpi; class CPIAllMinusFnE2 CPIFood2 CPIEnergy2 CPIMedical2 CPIShelter2; model MinWageCPI2= CPIAllMinusFnE2 CPIFood2 CPIEnergy2 CPIMedical2 CPIShelter2; run; proc glm data=cpi; class CPIAllMinusFnE2 CPIFood2 CPIEnergy2 CPIMedical2 CPIShelter2; model MinWageCPI2= CPIAllMinusFnE2 CPIFood2 CPIEnergy2 CPIMedical2 CPIShelter2 ; output out=diag r=res p=pred; run;
I'm using SAS Studio.
First, avoid PROC ANOVA as I seriously doubt it is appropriate for such a model.
Show us the output from PROC GLM that concerns you, by pasting it into your reply. Many of us will not download Microsoft Office documents as they are security threats.
Show the log please.
Your right hand side doesn't look like CLASS variables. Remove CLASS statement.
options ls=max center=0;
data cpi;
infile cards dsd firstobs=2;
input CPIAll2 CPIAllMinusFnE2 CPIFood2 CPIEnergy2 CPIMedical2 CPIShelter2 MinWageCPI2;
cards;
CPIAll2,CPIAllMinusFnE2,CPIFood2,CPIEnergy2,CPIMedical2,CPIShelter2,MinWageCPI2
28.09,28.93,28.93,21.48,19.68,23.96,29.85
28.86,29.59,30.17,21.53,20.63,24.47,29.85
29.15,30.18,29.66,21.90,21.49,24.73,29.85
29.58,30.64,30.02,22.43,22.25,25.23,29.85
29.89,30.98,30.36,22.49,22.93,25.45,31.34
30.25,31.41,30.63,22.58,23.53,25.73,34.33
30.63,31.80,31.07,22.63,24.09,26.07,35.32
31.02,32.28,31.48,22.53,24.58,26.50,37.31
31.51,32.74,32.18,22.95,25.18,26.99,37.31
32.46,33.54,33.81,23.30,26.30,27.80,37.31
33.36,34.71,34.06,23.84,28.15,28.77,41.42
34.78,36.32,35.29,24.19,29.86,30.13,47.26
36.68,38.43,37.11,24.82,31.93,32.58,47.76
38.83,40.83,39.20,25.50,33.95,35.54,47.76
40.49,42.74,40.35,26.51,36.15,37.03,47.76
41.82,44.05,42.09,27.24,37.32,38.68,47.76
44.40,45.58,48.18,29.45,38.76,40.48,47.76
49.31,49.34,55.12,38.05,42.37,44.41,55.72
53.82,53.89,59.79,42.09,47.48,48.79,62.69
56.91,57.43,61.63,45.11,51.99,51.48,68.66
60.61,61.03,65.52,49.39,56.96,54.95,68.66
65.23,65.48,72.06,52.53,61.77,60.49,79.10
72.58,71.86,79.92,65.74,67.48,68.90,86.57
82.41,80.78,86.78,86.03,74.88,80.99,92.54
90.93,89.24,93.56,97.72,82.93,90.48,100.00
96.50,95.85,97.35,99.15,92.55,96.89,100.00
99.60,99.62,99.41,99.93,100.59,99.13,100.00
103.88,104.54,103.23,100.93,106.86,103.99,100.00
107.57,109.12,105.57,101.63,113.52,109.82,100.00
109.61,113.53,108.94,88.23,122.04,115.83,100.00
113.63,118.20,113.48,88.58,130.14,121.24,100.00
118.26,123.42,118.18,89.25,138.64,127.08,100.00
123.97,128.98,125.08,94.32,149.25,132.83,100.00
130.66,135.46,132.37,102.09,162.80,139.98,110.07
136.19,142.11,136.25,102.45,177.02,146.28,123.51
140.32,147.31,137.89,103.00,190.07,151.19,126.87
144.46,152.18,140.86,104.15,201.41,155.73,126.87
148.23,156.52,144.28,104.63,211.02,160.53,126.87
152.38,161.20,148.42,105.24,220.47,165.68,126.87
156.85,165.56,153.28,110.13,228.23,171.03,130.60
160.52,169.51,157.28,111.52,234.58,176.28,145.77
163.01,173.38,160.68,102.88,242.13,182.11,153.73
166.58,176.98,164.10,106.62,250.58,187.26,153.73
172.20,181.29,167.82,124.61,260.75,193.35,153.73
177.07,186.13,173.08,129.29,272.76,200.56,153.73
179.88,190.45,176.22,121.68,285.60,208.09,153.73
183.96,193.23,179.98,136.49,297.08,213.12,153.73
188.88,196.63,186.18,151.39,310.13,218.84,153.73
195.29,200.89,190.73,177.05,323.23,224.43,153.73
201.59,205.92,195.18,196.86,336.18,232.13,153.73
207.34,210.73,202.92,207.72,351.05,240.61,164.18
215.30,215.57,214.11,236.67,364.06,246.67,185.07
214.54,219.24,217.96,193.13,375.61,249.35,205.97
218.06,221.34,219.63,211.45,388.44,248.40,216.42
224.94,225.01,227.84,243.91,400.26,251.65,216.42
229.59,229.76,233.78,246.08,414.92,257.08,216.42
232.96,233.81,237.04,244.41,425.13,263.06,216.42
236.74,237.90,242.72,243.58,435.29,270.51,216.42
237.02,242.25,247.23,202.90,446.75,278.80,216.42
240.01,247.60,247.93,189.53,463.67,288.23,216.42
245.12,252.17,250.06,204.54,475.32,297.80,216.42
251.11,257.57,253.56,219.94,484.71,307.66,216.42
255.66,263.21,258.32,215.29,498.41,318.05,216.42
;;;;
run;
proc print width=min;
run;
proc glm data=cpi;
model MinWageCPI2=CPIAllMinusFnE2 CPIFood2 CPIEnergy2 CPIMedical2 CPIShelter2 / solution;
run;
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.