PROC SQL self-join might do what you want.   proc sql; create table have_linked as select a.*, b.id as related_id, b.var1 as var1_r, b.var2 as var2_r, sum(b.var1*a.var1,b.var2*a.var2) as cross_multiplication from have a, have b where a.year=b.year and a.id ne b.id order by a.id, year, b.id; quit; ... View more

You can use PROC SQL to get the count of missing values for character or numeric variables.  A coworker asked how to find all the variables in a data set that are missing for all observations.  The code example below can answer that question.     options mprint; /* Using SASHELP data sets while testing macro. Macro should list variables that are completely missing in data set, so need to create some data sets with such variables. */ data baseball; set sashelp.baseball; suzanne_favorite_team=''; cleveland_indians_rank=.; run; data class; set sashelp.class; teacher=''; grade_level=.; run; %macro missing_summary(lib=, dsn=); /* use dummy macro so that syntax highlighting shows up within missing macro */ %macro dummy(); %mend dummy; /* get data set variable names */ proc sql; create table vars_to_summarize as select name, label from sashelp.vcolumn where libname="%upcase(&lib)" and memname="%upcase(&dsn)"; quit; /* count number of variables to process */ proc sql noprint; select count(*) into :var_counter from vars_to_summarize; quit; /* do PROC SQL one variable at a time, append details for variable to summary report, then delete the variable's data set so that work library doesn't get cluttered. */ %do i=1 %to &var_counter; data _null_; obsnum=&i; set vars_to_summarize point=obsnum; if _error_ then abort; call symputx('field',name); call symputx('description',label); stop; run; proc sql; create table &field._report as select count(*) as n, count(&field) as not_missing, nmiss(&field) as missing from &lib..&dsn; quit; data &field._report; length variable $ 32 dataset $ 41 label $ 256; set &field._report; variable="&field"; dataset="&lib..&dsn"; label="&description"; run; proc append base=summary data=&field._report; run; proc datasets nolist; delete &field._report; quit; %end; proc datasets nolist; delete vars_to_summarize; quit; %mend missing_summary; %missing_summary(lib=work, dsn=class); %missing_summary(lib=work, dsn=baseball); proc print data=summary noobs; by dataset notsorted; * uncomment statement below if you only want to see the variables missing for ALL obs ; * where n=missing; var dataset variable label n not_missing missing; title 'Missing and not-missing counts by variable'; run; * clean up; proc datasets nolist; delete summary; quit;   References:   Top 10 Most Powerful Functions for PROC SQL   Dictionary Tables and Views: Essential Tools for Serious Applications   ... View more

If you have text that you want displayed only at the end of the table, you can use the format_text method instead.   Below is an example.   options nodate; %macro blank_row; t.row_start(); t.format_cell(); t.format_cell(); t.format_cell(); t.format_cell(); t.format_cell(); t.row_end(); %mend blank_row; proc sort data=sashelp.baseball out=sorted_by_team; by league team name; run; ODS PROCLABEL='1986 Major League Baseball Players'; ODS PDF FILE="/folders/myfolders/Report Writing Interface/1986 Baseball Roster.pdf" STYLE=HTMLBlue PDFTOC=1; data _null_; set sorted_by_team end=done; by league team; if _n_=1 then do; dcl odsout t(); t.title(data: 'Title method shows up at top of every page'); t.footnote(data: 'Footnote method shows up at bottom of every page'); t.table_start(); * create labels at top of table, first page only! ; t.head_start(); t.row_start(); t.format_cell(data: 'League', vjust: 'b', just: 'l'); t.format_cell(data: 'Team', vjust: 'b', just: 'l'); t.format_cell(data: 'Player', vjust: 'b', just: 'l'); t.format_cell(data: 'Position', vjust: 'b'); t.format_cell(data: 'Major#League#Years#of#Service', split: '#'); t.head_end(); end; * only show league and team for first player on each team ; if first.team then do; t.row_start(); t.format_cell(data: league, inline_attr: 'font_weight=bold'); t.format_cell(data: team, just: 'l', inline_attr: 'font_weight=bold'); t.format_cell(data: name, just: 'l', inline_attr: 'font_style=italic'); t.format_cell(data: position); t.format_cell(data: yrmajor, just: 'r'); t.row_end(); end; else do; t.row_start(); t.format_cell(); t.format_cell(); t.format_cell(data: name, just: 'l', inline_attr: 'font_style=italic'); t.format_cell(data: position); t.format_cell(data: yrmajor, just: 'r'); t.row_end(); end; * only want blank line between teams in report. ; * no need for blank line after last team in report. ; if last.team and not done then do; %blank_row end; if done then do; t.table_end(); t.format_text(data: 'This report is for the active players during the 1986 Major League Baseball season', style_elem: "SystemFooter" ); t.format_text(data: 'This text only shows up at bottom of table. Not the same as a footnote!', style_elem: "SystemTitle"); t.note(data: "Link to Report Writing Interface online documentation", url: "http://support.sas.com/documentation/cdl/en/odsadvug/67923/HTML/default/viewer.htm#n0w8et93ubh1enn1f34empn5948l.htm"); end; run; ODS PDF CLOSE; ... View more

  If you want that library automatically defined across sessions, make sure you check the box for Re-create this library at startup.   ... View more