Hi Art:

Thanks for that I hadn't considered using the filename clipbrd as a method of filling the clipboard buffer. The next time I'm moving information between SAS and Excel or SAS and Word I'll give it a go..

Regards,

Kevin > Date: Tue, 5 Jan 2010 15:39:42 -0500 > From: art297@NETSCAPE.NET > Subject: Re: SAS using advanced excel > To: SAS-L@LISTSERV.UGA.EDU > > Tumu, > > Since you can copy and paste, I would presume that the 'clipbrd' method > should work. > > i.e., if you assign a filename to the clipbrd method e.g.: > > filename _cb clipbrd; > > couldn't you then just build a simple data step that writes to that > filename (which turns out to simply be the clipboard), from which you can > paste directly into excel? e.g., > data _null_; > file _cb; > /* put whatever data step statements you need here simply using > put statements to write the desired values to the clipboard */ > run; > > and, of course, then clear the filename: i.e., > filename _cb clear; > > HTH, > Art > ------- > On Tue, 5 Jan 2010 10:52:11 -0800, Raj <rajiv468@GMAIL.COM> wrote: > > >Hi, > > > >Im using SAS on Z/OS. I have advanced excel where i usually copy and > >paste the values from SAS table to excel.(because formulas get > >disturbed) > >Can anyone suggest me how to automate this. > > > >Regards, > >Tumu _________________________________________________________________ Windows Live: Make it easier for your friends to see what you’re up to on Facebook. http://go.microsoft.com/?linkid=9691816