BookmarkSubscribeRSS Feed
SanjayM
Calcite | Level 5
How to export data to excel but in two separate spreadsheets.

We cannot use PROC EXPORT as we do not have license.
4 REPLIES 4
deleted_user
Not applicable
option _last_= sashelp.class ;
ods tagsets.excelxp file='your.workbook.xls' style= default;
proc print;
proc means;
run;
ods _all_ close ;
railfan1975
Fluorite | Level 6
Does this only work for Excel XP or will it work for Excel 2000 as well? (Yes, we still are using Excel 2000.)
Cynthia_sas
SAS Super FREQ
Hi:
TAGSETS.EXCELXP generates MIcrosoft Spreadsheet Markup Language XML tags that describe the worksheet. Sadly, Microsoft introduced this XML description of the spreadsheet in Office 2002/2003. So even if you have SAS 9 and CAN create SpreadsheetML XML with SAS, you can only open it with Office 2002/2003 or higher.

If you use ODS HTML, you can create multiple HTML files; and then, there is one method for linking those separate HTML files together -- again, using a Microsoft form of XML and HTML for describing the relationship of the files. Basically, for this to work, you would use SAS to create the multiple HTML files. But, unless you know a lot about coding SAS data step programs, building the HTML and XML to link the files together is a manual process. (That method is described in this presentation:
http://support.sas.com/rnd/base/ods/excel/multisheet_excel_post.ppt )

cynthia
deleted_user
Not applicable
Hi Cynthia
This is great, but for some reason, I get the error message: ERROR: Insufficient authorization to access c:\your workbook.xls, although it works if I put the file on our server and change the file name accordingly...

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

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
  • 4 replies
  • 671 views
  • 0 likes
  • 4 in conversation