BookmarkSubscribeRSS Feed
tir
Calcite | Level 5 tir
Calcite | Level 5

Hi All,

I am creating an excel file using ODS HTML statement:

ods html file="filepath" style=minimal;

proc print data=have;

run;

ods html close;

it is creating an excel file but along with its creating a folder with pieces which includes HTML, XML files.

i am not sure why its creating an folder. do i need to configure something in SAS so that ODS to HTML (.xls) is properly created.?

Regards,

Sudt

2 REPLIES 2
ballardw
Super User

One: ODS HTML creates HTML regardless of how you name the file. The folder has those bits that HTML references.

You might be better off using TAGSETS.EXCELXP instead of HTML, which creates XML that Excel can open.

Reeza
Super User

What version of SAS d you have?

Is there any reason to not switch over to ODS Excel or Tagsets.ExcelXP?

In SAS 9.4 ODS EXCEL generates a native Excel file, tagsets.excelxp generates an XML file.

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 803 views
  • 1 like
  • 3 in conversation