Hi , I need to do two bwlow tasks : 1: I have three reports/table , want all them to be placed horizontally in excel (sheet_interval='none') work to place them vertially can you suggest way in ods tagsets.excelxp 2: I have a report as a sample attached where there are multiple Desc and based on that creating different columns But I dont want the first heading in proc report output (Ex: Desc) How can I do that . Below is the code I have used proc report data=Sample style(report)=[font=(calibri, 10pt) just=left] style(column header)=[font=(calibri,12pt) font_weight = bold just=left] style(column)=[font=(calibri, 10pt)] nowd; column ('ID' ID) desc, Var; define ID / group ' '; define desc / across order=data; define var / analysis sum style={tagattr='format:#,##0;[RED]-#,##0'} ''; run;
... View more