BookmarkSubscribeRSS Feed
wkossack
Calcite | Level 5
I'm working with EG on a UNIX server and the only place I can write files is to the server. I'm attempting to create a spreadsheet with multiple tabs. Below is a sample program I pulled from the SAS site. The program works to a point creating multiple html files in the folder on the server. The program also creates a spreadsheet file but only 1K in size (the html files are each 28K in size).

When I try and open the resulting spreadsheet on my PC excel complains that it can not find the html files (curiously the path is given but it is to a PC folder with the slashes in the wrong direction). Apparently, SAS/EG is not really adding the html files to the spreadsheet but creating a link to them.

Is there a way to force SAS/EG to force it to copy the html into the spreadsheet? Or is there a way to get it to get the path correct?

proc sort data=sashelp.class out=test;
by age;
run;

ods tagsets.msoffice2k file='/path/temp.html' newfile=output;

proc print data=test;
by age;
run;

ods tagsets.msoffice2k close;


ods tagsets.msoffice2k_x
file="/path/multiple.xlsx" style=statistical
options(
worksheet_source="11#/path/temp.html,
12#/path/temp1.html,
13#/path/temp2.html,
14#/path/temp3.html,
15#/path/temp4.html,
16#/path/temp5.html"
);
data _null_;
file print;
put "test";
run;


ods tagsets.msoffice2k_x close;
run; quit;
1 REPLY 1
Cynthia_sas
Diamond | Level 26
Hi:
This is not really an ODS GRAPHICS or SAS/GRAPH question. It should be posted in the ODS and Base Reporting forum:
http://support.sas.com/forums/forum.jspa?forumID=6

Or, since your question involves EG, you might want to post this in the EG forum -- I believe there is a task in EG to copy files back and forth, if needed.

For more help with the FILE= option and the PATH= option (which you may need to use in this instance), you might want to open a track with SAS Tech Support or refer to this Tech Support note:
http://support.sas.com/kb/23/638.html
http://support.sas.com/kb/12/119.html

cynthia

hackathon24-white-horiz.png

The 2025 SAS Hackathon Kicks Off on June 11!

Watch the live Hackathon Kickoff to get all the essential information about the SAS Hackathon—including how to join, how to participate, and expert tips for success.

YouTube LinkedIn

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
  • 1041 views
  • 0 likes
  • 2 in conversation