Exporting results: formatting issues

am2016 — Tue, 21 Jun 2016 15:04:17 GMT

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!

Re: Exporting results: formatting issues

Reeza — Tue, 21 Jun 2016 16:47:11 GMT

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.

topic Exporting results: formatting issues in ODS and Base Reporting

Exporting results: formatting issues

Re: Exporting results: formatting issues