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
SAS Super FREQ
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

SAS INNOVATE 2024

Innovate_SAS_Blue.png

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

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.

Get the $99 certification deal.jpg

 

 

Back in the Classroom!

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

View all other training opportunities.

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