Hello,
I am having issues with formatting when I export my results to Excel.
I used the following code:
ODS TAGSETS.EXCELXP
file="/folders/myfolders/sasuser.v94/Data.xlsx"
STYLE=minimal
OPTIONS (embedded_titles='yes' embedded_footnotes='yes'
Orientation = 'landscape'
FitToPage = 'yes'
sheet_name='Data');
PROC FREQ data=lib.data;
tables example1*example2;
RUN;
ODS tagsets.excelxp close;
As you can see above, I end up with a row of numbers instead of columns within each cell (see below).
This is what the results look like in SAS Studio:
How can I fix this?
I apologize if I haven't asked this very clearly--I'm quite new to SAS!
Thank you!
What version of SAS and tagsets are you using? This was a known issue but I thought it was fixed. The workaround was to use proc tabulate IIRC.
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.