Hi there. Thanks for your feedback.  your modification did not work. I still get the same result. the vars G19 and G20 drop. I need to keep both of them in the data set even though when the data set is transposed their values turn to missing.  ... View more

Hi TomKari- I need the vars only on the first row. Thanks. ... View more

Hi Cynthia-- So, I have been working on the program above and I'm still have issues. Any advice would be greatly appreciated. I made a sorting variable like you suggested  and then I was trying to use the sorting variable as a way to modify the indentation and font weight in certain cells in the column measure “Measure?” . Again, I'm trying to produce this: Safe_Total Safe_Outcomes      Freq_OSI      AWOL Safe_Practice_Score Safe_Process_Score     Timeliness_OSI     Timeliness_Certs Perm_Total Perm_Outcomes_Score     Perm_Discharges     Adoption_Final Perm_Practice_Score     FASP WellBeing_Total WellBeing_Out_Score     Step_Ups     Lateral_Moves     SD_Incentive WellBeing_Practice_Score FPS_Scores     Recruitment     FPS_Practice_Score Foster_Training Here I make the sort variable: data Scorecared_vars ; retain sort Agency_code agency Measure score;  set Scorecared_vars; if Measure='Safe_Total' then sort=1; if Measure='Safe_Outcomes' then sort=2; if Measure= 'Freq_OSI' then sort= 3   ; if Measure= 'AWOL' then sort=4  ; if Measure= 'Safe_Practice_Score' then sort= 5; if Measure= 'Safe_Process_Score' then sort=6; if Measure= 'Timeliness_OSI'  then sort= 7  ; if Measure= 'Timeliness_Certs' then sort= 8  ; if Measure= 'Perm_Total' then sort= 9 ; if Measure= 'Perm_Outcomes_Score' then sort=  10 ; if Measure= 'Perm_Discharges' then sort= 11  ; if Measure= 'Adoption_Final'  then sort= 12  ; if Measure= 'Perm_Practice_Score' then sort= 13  ; if Measure= 'FASP'    then sort= 14  ; if Measure= 'WellBeing_Total' then sort= 15  ; if Measure= 'WellBeing_Out_Score' then sort= 16  ; if Measure= 'Step_Ups'    then sort=17   ; if Measure= 'Lateral_Moves' then sort=18   ; if Measure= 'SD_Incentive' then sort=19   ; if Measure= 'WellBeing_Practice_Score' then sort=20   ; if Measure= 'FPS_Scores' then sort= 21  ; if Measure= 'FPS_Practice_Score' then sort=22   ; if Measure=  'Recruitment' then sort=23   ; if Measure=  'Foster_Training'  then sort= 24  ; run; proc sort data=Scorecared_vars_withms;  by  descending Agency_code  sort ; run; Here is the rest of the program: ods listing; options leftmargin=".1 in" topmargin=".1 in"        rightmargin=".1 in" bottommargin=".1 in"       nodate nonumber orientation=landscape; ods pdf file="Z:\SAS\SASCODE\Scorecardtest.pdf" style=journal startpage=yes; ods escapechar='^'; title j=l '^S={preimage="Z:\SAS\SASCODE\NYC ACS Logo2.jpg"}'; title2 'FY12 Familly Based Scorecard'  ; footnote; proc report data=Scorecared_vars_withms nowd style(column)={just=c font_size=10pt font_face= 'Verdana'} style(header)={font_size=10 pt font_face= 'Verdana' FONT_WEIGHT = BOLD background=cxcccccc}; column Measure SCORE1 mean1 Max1 min1; define measure / display style(column)={just=left font_size=10pt font_face= 'Verdana' cellwidth=4.in} style(header)={font_size=10 pt font_face= 'Verdana' FONT_WEIGHT =BOLD}; compute Measure;   If sort=1 then ;     CALL DEFINE('_c1_',"STYLE","STYLE={PRETEXT='   ' ASIS=ON FONT_STYLE=BOLD}"); endcomp; run; title; footnote; ods _all_ close; ... View more

This is great Cynthia! Thanks so much. I may have to bug you with a few more questions. Thanks!! ... View more

Wow thanks so much Data_Null_. I am not familiar with some of the staments in your code (still learning base sas) like nway,index,key,unique and what is happeneing in this step: if _error_ then do; _error_ = 0; Your feedback is greatly appreciated. Again, still learning. Thanks!! ... View more