Is there a way to incorporate an xml table into an ODS tagsets.excelxp proc print statement or can I incorporate it in mystyle (style sheet) or is there any other way? I need to add an xml table to the underneath this rpt. I do not have access to create the xml table in SAS I only get the result to be placed into the excel sheet with these results. Thanks for any help code Ods listing close; %include Old_data.xml define style styles.mystyle; parent = styles.statictical; replace colors / 'titlebg' = "#FFFFFF" 'titlefg' = "#000000"; replace fonts / 'titleFont' = ("Georgia,Roman",18pt,bold); ods tagsets.excelxp file = test style=mystyle options (autofilter="all" embedded_titles = "yes"); Proc print data=test_file label split = "_" noobs; Title "Detail"; Title "as of: today" Label add_time = "Time_entry_made" FC = "False_Code_Enter" CC = "Correct_Code_Enter" Proc print data=old_data.xml ; run; Ods tagset.excelxp close;
... View more