Hi all— So, I need a little help regarding a joining two tables together and then rename variables. Any assistance will be greatly appreciated. I start with two tables that are similar to the examples below. All the variable names are the same in each table but there are over 100 variables in each table. FY11 SCORES Agency Safety_Score Recreation_score Contacts_score Agency1 98% 95% 95% Agency2 100% 96% 96% Agency3 94% 91% 91% Agency4 92% 92% 92% Agency5 95% 95% 95% Agency6 96% 83% 83% Agency7 99% 87% 87% Agency8 93% 88% 88% Agency9 93% 86% 86% Agency10 96% 87% 87%   FY12 SCORES Agency Safety_Score Recreation_score Contacts_score Agency1 98% 93% 93% Agency2 100% 96% 96% Agency3 94% 93% 91% Agency4 93% 92% 100% Agency5 95% 95% 95% Agency6 96% 83% 83% Agency7 99% 100% 87% Agency8 93% 88% 88% Agency9 93% 86% 93% Agency10 100% 87% 87% The final product need should look like this: Agency FY11 _Safety_Score FY12 _Safety_Score % Difference FY11_Recreation_score FY12_Recreation_score % Difference FY11_Contacts_score FY12_Contacts_score % Difference Agency1 98% 95% -3% 98% 96% -2% 95% 95% 0% Agency2 100% 96% -4% 99% 96% -3% 96% 96% 0% Agency3 94% 91% -3% 91% 88% -3% 91% 91% 0% Agency4 92% 92% 0% 91% 94% 3% 92% 92% 0% Agency5 95% 95% 0% 95% 94% -1% 95% 95% 0% Agency6 96% 83% -13% 94% 73% -21% 83% 83% 0% Agency7 99% 87% -12% 98% 83% -15% 87% 87% 0% Agency8 93% 88% -5% 95% 89% -6% 88% 88% 0% Agency9 93% 86% -7% 93% 79% -14% 86% 86% 0% Agency10 96% 87% -9% 92% 84% -8% 87% 87% 0% What I need to do is: Add a FY11_ or FY_12 prefix to all the variables to identify which are they are from. Combine the tables so I have FY11 and FY12 scores side by side. Calculate the % cent difference for each paring. Now, I have a program that adds the prefixes to the varibles (see below) but the issue is some of the variable titles are too long so  when the program trys to attach the  prefix it doent work and I get error meaages. Is there a way to delete some of the charters in the variable names which are too long?   proc sql; select cat(name, ' = ', cats('FY11_', name )) into :renstr separated by ' ' from dictionary.columns where libname = 'WORK' and memname='FY11_data'; quit; data Fy11_data_new;   set Fy11_data (rename = (&renstr)); run; You can see why combine these tables just by cutting and pasting in excel would be very difficult and take forever. Again , any help with this is greatly appreciated!!!!!!!!! ... View more

Hello-- I have some tricky numeric transformations I’m having trouble figuring out. I'm finding them tricky because I have to start by basing the scores off to values in one variable.  The data set below are the variables I start with plus the variables I need to calculate. Start With Variables which need to be calculated A B C D E F G H I J Office Certification Total_of_Homes Closed Compliance_Rate Home_Type_Proportion Points_Available Home_Points_Earned Total _Points Total_Score Office1 12 -month 173 1% 99% 88% 8.8 8.8 9.8 98% Office1 kinship 90 days 23 13% 87% 12% 1.2 1.0 I need to start by calculating a Home_Type_Proportion for the values of “12-month” and “kinship 90 days” so the calculations look like this:  “12-month”           =  C4/(C4+C5)    =  Home_Type_Proportion “kinship 90 days”  =  C5/(C4+C5)    =  Home_Type_Proportion     Then I need to calculate Points_Available: “12-month”            Home_Type_Proportion   =  F4*10    = Points_Available “kinship 90 days”  Home_Type_Proportion   =  F5*10    = Points_Available     Then I need to calculate Home_Points_Earned: “12-month”         Points_Available  =  G4*E4  =  Home_Points_Earned “kinship 90 days” Points_Available  =  G5*E5  =  Home_Points_Earned     Then I need to Combine “12-month”  and “kinship 90 days” to get: Total _Points =H4+H5 And last  Total_Score = I4/10 or Home_Points_Earned / 10 Can you see why this may be a little tricky to figure out? Any help is greatly appreciated!  Thanks ... View more