Michael,

Hope you find exactly what you are looking for. But just in case you don't, I have accomplished the same thing by having SAS write tab delimited files. Then I write VB code in the Excel workbook to pick up the delimited files. Not as scary as it sounds, because you can pick up the first file with the macro recorder on, and then modify the code to pick up the rest.

Bill

----- Original Message ----- From: "Durbin, Michael" <MDurbin@ERAC.COM> Sent: Thursday, March 28, 2002 8:58 AM Subject: Creating Unix Environmental Variables

> All, > > I have a situation where I need to write data from SAS to multiple > worksheets in an EXCEL workbook from Unix. I have a PERL program that can > write the binary form of the EXCEL workbook with multiple sheets that was > created from a CSV file that was output from SAS. I now need to automate > this process, however, I need to pass parameters from SAS to PERL. The only > way I think I can achieve this is to create UNIX environmental variables > from SAS. Every time I try this from SAS my variables are always blank on > Unix? When using the X command does SAS spawn another sessionid? This may > account for my problem. Does anyone know how to achieve what I'm trying to > do? > > Thanks, > > Mike Durbin >