BookmarkSubscribeRSS Feed
am2016
Calcite | Level 5

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

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

How can I fix this?

I apologize if I haven't asked this very clearly--I'm quite new to SAS!

 

Thank you!

 

1 REPLY 1
Reeza
Super User

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. 

 

 

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1054 views
  • 0 likes
  • 2 in conversation