I Have code similar to the following, using the coalesce function to join Value1 to taple Temp_Original from 6 possible tables.   Is there a way to also have it output which table the value was taken from?  I could write separate code to check the if the value is missing from each table in sequence, and output the Table name.  But I was hoping there might be a smoother way to do it, perhaps using some saved value from the coalesce function indicating the placement of the first non empty value.   any ideas? proc sql noprint; create table Temp_Join as select A.*, Coalesce(B.Value1,C.Value1,D.Value1,E.Value1,F.Value1,G.Value1) as Value1, Coalesce(B.Value2,C.Value2,D.Value2,E.Value2,F.Value2,G.Value2) as Value2 from Temp_Original as A left join Temp1 as B on A.SomeValue = B.SomeValue left join Temp2 as C on A.SomeValue = C.SomeValue left join Temp3 as D on A.SomeValue = D.SomeValue left join Temp4 as E on A.SomeValue = E.SomeValue left join Temp5 as F on A.SomeValue = F.SomeValue left join Temp6 as G on A.SomeValue = G.SomeValue; quit;         ... View more

In the following code, the first 4 steps just manipulate the SASHELP.Class dataset to illustrate my question.   Is it possible to remove certain row lines from spanned rows as noted below?   %LET FilePath=C:\Folder1\Folder2; data ClassTable; set SASHELP.Class; Section="A"; run; data ClassTable1; set SASHelp.Class; Section="B"; run; data ClassTable; set ClassTable ClassTable1; run; proc sql noprint undo_policy=none; delete from ClassTable where Name like '%J%' and Section="B"; quit; ods rtf file="&FilePath.\TestRTF.rtf"; ODS escapechar='^'; options nodate nonumber; proc report data=ClassTable spanrows split='~' style(Header)=[just=l background=white] Style(Report) = [Rules=Rows Frame=below]; Column ('^{Style[FontSize=12pt font_face="Times New Roman"]Table 3.2 This is my Table Title}'(Sex Name Section Age Height Weight)); Define Sex / group style(column)=[ cellwidth=0.6in Vjust=C] style(header)=[ background=greybb just=c vjust=c] center; Define Name / Display 'Student~Name' order order=internal style(Column)=[ borderleftwidth=1pt just=c vjust=c] style(Header)=[ borderleftwidth=1pt borderleftcolor=black borderrightwidth=1pt borderrightcolor=graybb background=graybb just=c vjust=c] CENTER; Define Section / order order=internal style(Column)=[ borderleftwidth=1pt borderleftcolor=black borderrightwidth=1pt borderrightcolor=black just=c vjust=c] style(Header)=[ borderleftwidth=1pt borderleftcolor=black borderrightwidth=1pt borderrightcolor=black background=greybb just=c vjust=c]; Define Age / style=[borderrightwidth=1pt] style(Header)=[ borderleftwidth=1pt borderleftcolor=graybb borderrightwidth=1pt borderrightcolor=black background=greybb just=c vjust=c] style(Column)=[ CellWidth=0.70in borderrightwidth=1pt borderrightcolor=black] CENTER; Define Height / Style(Column)=[CellWidth=0.75in] style(Header)=[ borderrightcolor=graybb borderleftcolor=black background=greybb just=c vjust=c] CENTER; Define Weight / display 'Student~^{style[fontstyle=italic]Weight}^' Style(Column)=[CellWidth=0.75in] style(Header)=[ borderleftcolor=graybb borderrightcolor=black background=greybb just=c vjust=c] CENTER; run; ods rtf close; A portion of the output is here. Is it possible to remove the messily highlighted row line, and all others similar?  (for Barbara, Carol, where the Student has an A and B Section)       ... View more