creating a spreadsheet using tagsets on a UNIX EG server

wkossack — Thu, 03 Feb 2011 16:29:18 GMT

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;

Re: creating a spreadsheet using tagsets on a UNIX EG server

Cynthia_sas — Thu, 03 Feb 2011 16:44:57 GMT

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

topic creating a spreadsheet using tagsets on a UNIX EG server in Graphics Programming

creating a spreadsheet using tagsets on a UNIX EG server

Re: creating a spreadsheet using tagsets on a UNIX EG server