06-21-2016 11:04 AM
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;
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!
06-21-2016 12:47 PM
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.