Hi PG, I have used proc glm on the same set of data successfully but my professor insists that I also run a proc reg. I changed my statements to: proc reg data=c; model Acar1 = ratio lnTEn lnSIZE TobinQ ADebtratio DEBTRT Cash HYBRID OTHER SHARES UNKNOWN Horizontal Vertical Conglomerate zero one two three four five six seven eight nine ten eleven twelve thirteen fourteen CPS ENERGY FINANCE HEALTH HT IND MATERLS REALEST RETAIL STAPLES TELECOM AEQW/noint; run; But I still get the notes: Note: Model is not full rank. Least-squares solutions for the parameters are not unique. Some statistics will be misleading. A reported DF of 0 or B means that the estimate is biased.  Note: The following parameters have been set to 0, since the variables are a linear combination of other variables as shown. Conglomerate = Cash + HYBRID + OTHER + SHARES + UNKNOWN - Horizontal - Vertical fourteen = Cash + HYBRID + OTHER + SHARES + UNKNOWN - zero - one - two - three - four - five - six - seven - eight - nine - ten - eleven - twelve - thirteen TELECOM = Cash + HYBRID + OTHER + SHARES + UNKNOWN - CPS - ENERGY - FINANCE - HEALTH - HT - IND - MATERLS - REALEST - RETAIL - STAPLES Parameter Estimates Variable Label DF Parameter Estimate Standard Error t Value Pr > |t| ratio ratio 1 0.08509 0.03495 2.44 0.0184 lnTEn lnTEn 1 -0.00575 0.00582 -0.99 0.3281 lnSIZE lnSIZE 1 -0.00398 0.00624 -0.64 0.5269 TobinQ TobinQ 1 0.00001882 0.00003795 0.50 0.6220 ADebtratio ADebtratio 1 2.35285 3.60842 0.65 0.5172 DEBTRT DEBTRT 1 -0.02118 0.02589 -0.82 0.4170 Cash ConsiStr CASHO B 0.04587 0.09930 0.46 0.6461 HYBRID ConsiStr HYBRID B 0.07168 0.10062 0.71 0.4794 OTHER ConsiStr OTHER B 0.08375 0.10428 0.80 0.4256 SHARES ConsiStr SHARES B 0.06744 0.09908 0.68 0.4991 UNKNOWN ConsiStr UNKNOWN B 0.04524 0.10627 0.43 0.6721 Horizontal Type 1 B -0.00760 0.01355 -0.56 0.5775 Vertical Type 2 B 0.01477 0.01575 0.94 0.3527 Conglomerate Type 3 0 0 . . . zero year 2000 B 0.04037 0.03713 1.09 0.2819 one year 2001 B 0.09816 0.03612 2.72 0.0089 two year 2002 B 0.08024 0.03817 2.10 0.0404 three year 2003 B 0.01385 0.03398 0.41 0.6853 four year 2004 B 0.04770 0.03453 1.38 0.1731 five year 2005 B 0.02025 0.03139 0.65 0.5217 six year 2006 B 0.02535 0.02826 0.90 0.3738 seven year 2007 B 0.00789 0.03068 0.26 0.7980 eight year 2008 B 0.08945 0.03590 2.49 0.0159 nine year 2009 B 0.04158 0.03096 1.34 0.1852 ten year 2010 B -0.00238 0.04236 -0.06 0.9553 eleven year 2011 B 0.04103 0.03513 1.17 0.2482 twelve year 2012 B 0.05978 0.03336 1.79 0.0789 thirteen year 2013 B 0.04555 0.04313 1.06 0.2958 fourteen year 2014 0 0 . . . CPS Industry CPS B 0.00974 0.05062 0.19 0.8481 ENERGY Industry ENERGY B 0.07491 0.06755 1.11 0.2725 FINANCE Industry FINANCE B 0.03148 0.05087 0.62 0.5388 HEALTH Industry HEALTH B -0.01152 0.05331 -0.22 0.8298 HT Industry HT B 0.02942 0.05232 0.56 0.5763 IND Industry IND B 0.00880 0.05026 0.18 0.8616 MATERLS Industry MATERLS B 0.03385 0.05001 0.68 0.5015 REALEST Industry REALEST B 0.01833 0.05719 0.32 0.7499 RETAIL Industry RETAIL B 0.02712 0.05067 0.54 0.5947 STAPLES Industry STAPLES B 0.05081 0.05409 0.94 0.3519 TELECOM Industry TELECOM 0 0 . . . AEQW AEQW 1 0.00003368 0.00018967 0.18 0.8598   Thanks, Niloo     ... View more

It is preferred on tis forum if the question is not closely related to the existing topic to start a new thread. Especially if the thread is marked answered. Many folks will not look for new questions in an answered thread. ... View more

Thank you Tom, I fixed the sort statement and the if statement works perfectly now. Thanks, Niloo ... View more