Chevell Parker mentioned this in his SAS Global Forum paper Secrets from a SAS Technical Support Guy: Combining the Power of the SAS® Output Delivery System with Microsoft Excel Worksheets.   Below is the macro from pages 4 and 5 of Chevell's paper.      * create empty data set to use as example with macro ; data temp; set sashelp.class(where=(name='Suzanne')); run; %macro test(libref=, dsn=); %let rc=%sysfunc(open(&libref..&dsn, i)); %let nobs=%sysfunc(attrn(&rc, NOBS)); %let close=%sysfunc(CLOSE(&rc)); %if &nobs ne 0 and %sysfunc(Exist(&libref..&dsn)) %then %do; proc print data=&libref..&dsn; title "%upcase(&libref..&dsn)"; run; %end; %else %do; proc sql noprint; create table temp as select name from dictionary.columns where libname=%upcase("&libref") and memname=%upcase("&dsn"); run; quit; proc transpose data=temp out=temp1(drop=_label_ _name_); id name; var name; run; proc report noheader style(column)=header[just=center] nowd; title "No data for current report"; run; title; %end; %mend; ODS EXCEL FILE="/folders/myfolders/SAS Communities/Excel output with empty dataset.xlsx" options(embedded_titles='yes' sheet_interval='proc'); %test(libref=work, dsn=temp) ; %test(libref=sashelp, dsn=class) ; proc datasets nolist; delete temp; quit; ODS EXCEL CLOSE; ... View more

Use the DESCRIPTION= option on the PROC SGPLOT statement.   ods rtf file='XXXX\try.rtf' contents=yes toc_data bodytitle; options nobyline; data class; set sashelp.class; dummy_c=1; run; ODS PROCLABEL="Table: class_table"; proc report data=class nowindows contents=''; column dummy_c name sex age height weight; define dummy_c /group noprint; break before dummy_c /page contents=' '; footnote 'Measurements are in metric tons.'; run; ods graphics on; ODS PROCLABEL="Figure: class_figure"; proc sgplot data=class description=''; scatter x=height y=weight / group=sex; run; ods rtf close; ... View more

http://support.sas.com/software/products/sas-studio/faq/SASStudio_sharesnippets.htm might have a suggestion you can use. ... View more

That code will show notes in the log, when the second word has letters.  To prevent those notes in the log, you can test to see if there are any letters in the second word before converting it to a number.   if anyalpha(scan(char_string,2,' '))=0 then middle_number=input(scan(char_string,2,' '),12.); ... View more