|Date: ||Tue, 5 Jan 2010 18:21:57 -0600|
|Reply-To: ||Sudo Ku <crafty876@HOTMAIL.COM>|
|Sender: ||"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>|
|From: ||Sudo Ku <crafty876@HOTMAIL.COM>|
|Subject: ||Re: SAS using advanced excel|
|Content-Type: ||text/plain; charset="Windows-1252"|
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..
> 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
> 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 */
> and, of course, then clear the filename: i.e.,
> filename _cb clear;
> On Tue, 5 Jan 2010 10:52:11 -0800, Raj <rajiv468@GMAIL.COM> wrote:
> >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
> >Can anyone suggest me how to automate this.
Windows Live: Make it easier for your friends to see what you’re up to on Facebook.