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!
... View more