is it possible to have 2 (or more) reports side-by-side using excelxp tagset?
say i have 2 reports both are (theoretically) 8x8 cells.
can i have 1 report upper left in A1 and the second report upper left in J1?
Hi:
Generally speaking, it is easier to get side-by-side tables using RTF or PDF. The program below shows using COLUMNS=2 with ODS PDF. Sadly, the PDF and RTF destinations are the only ones that support COLUMNS=. If you had the SAS Add-in for Microsoft Office, you could run a stored process and control the starting column/row for Excel ouput in a popup window, which theoretically would let you put one report starting in A1, and another report starting in J1. However, with regular TAGSETS.EXCELXP, the tables would appear underneath each other in one table or on two separate sheets.
cynthia
ods pdf file='c:\temp\twocolumns.pdf' columns=2;
proc print data=sashelp.class(obs=5);
where sex = 'M';
run;
proc print data=sashelp.class(obs=5);
where sex = 'F';
run;
ods _all_ close;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.