Date:         Thu, 20 Oct 2011 11:23:25 -0700
Reply-To:     Shell Bell <cherryhill@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Shell Bell <cherryhill@HOTMAIL.COM>
Subject:      ods tagsets ExcelXP on Unix How to get into Excel?
Content-Type: text/plain; charset="iso-8859-1"

 I have the SAS add-in for excel. Working on Unix EG I wrote the following to get one tab per name.
 I cannot open the excel directly, as it has to be written to Unix, but EG has a results window that asks "Download Results?" Click download and miraculously it comes opens into excel.
Can I automate this or have some other method of getting it from the unix to the NT side where excel lives?
 
%macro seeit;
 
proc sql noprint;
select Name into: Name1-:Name20
from sashelp.class;
quit;
 
ods tagsets.ExcelXP style=sasdocprinter file="~/agencydata/SeeClass1.xls"; 
   %do i= 1 %to 20; 

ods tagsets.ExcelXP 
options(sheet_name="See Class" width_fudge='1.0' ORIENTATION='LANDSCAPE' );
 
title'Class';
title2"&datetime";
proc print data=class noobs;
where name="&&name&i";
run; 
%end; 
 
ods tagsets.ExcelXP close; 
 
%mend seeit;
%seeit;
 
Thanks in advance, 
Shell Bell