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;
![Screen Shot 2016-06-21 at 7.59.43 AM.png Screen Shot 2016-06-21 at 7.59.43 AM.png](https://communities.sas.com/t5/image/serverpage/image-id/3696iE778BBFA0DC14B71/image-size/original?v=v2&px=-1)
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:
![Screen Shot 2016-06-21 at 8.02.51 AM.png Screen Shot 2016-06-21 at 8.02.51 AM.png](https://communities.sas.com/t5/image/serverpage/image-id/3697i7516D2EC4C80FDE1/image-size/original?v=v2&px=-1)
How can I fix this?
I apologize if I haven't asked this very clearly--I'm quite new to SAS!
Thank you!