[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sas-l
Subject:    Re: How to copy variable names from a SAS data set
From:       Fried Egg <friedegg2012 () GMAIL ! COM>
Date:       2012-06-29 18:41:40
Message-ID: CANS8eEggHhJ_cKP3gaoGcuuxQDN6ZruO28ayFkHJzmZ3DueALw () mail ! gmail ! com
[Download RAW message or body]

My assumption is that the undetermined I/O failure is probably because the
remote sessions are executing without a shell and thus have no clipboard
the error may be different if the Object Spawner has ALLOWXCMD, but maybe
not as these sessions are also started typically with the noterminal option
as well as other factors that may prevent a clipboard from existing.

On Fri, Jun 29, 2012 at 12:32 PM, Thompson, Adam <
Adam.Thompson@stateauto.com> wrote:

> We have EG 4.3 installed locally, but connecting to a remote SAS server.
>  Copy/Paste from an open dataset on the remote server to a local word or
> excel document works just fine for me, but the output doesn't include
> column headers.
>
> I just tried the clipbrd filename method that Art mentioned, but it
> doesn't work from EG with our setup - it just says "ERROR: Undetermined I/O
> failure" in the log.
>
> The easiest way I know to get the headers from EG is to go to the file
> menu, then "send to", then choose either excel (alt+f+d+e) or word
> (alt+f+d+w).  It creates a new document with the headers and formatted data
> that can be moved from one office application to another like normal.
>
> I tend to like send-to a bit better than ods or the EG export task because
> it doesn't create a temporary file somewhere in my local file system that
> I'd have to clean up later.  Just send it, move the data to where you want
> it, then close the document without saving.
>
> -----Original Message-----
> From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
> Fried Egg
> Sent: Friday, June 29, 2012 12:07 PM
> To: SAS-L@LISTSERV.UGA.EDU
> Subject: Re: How to copy variable names from a SAS data set
>
> I don't see a problem if EG is connecting to a local server.  If you are
> connecting to a remote server than just don't expect the results to be in
> the local machines clipboard.
>
>
> -----Original Message-----
> From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
> Arthur
> Tabachneck
> Sent: Friday, June 29, 2012 9:49 AM
> To: SAS-L@LISTSERV.UGA.EDU
> Subject: Re: How to copy variable names from a SAS data set
>
> This is actually another question for the list: is there a way to use the
> clipbrd method from EG?
>
> I was about to suggest the following to Mirisage but, before sending it,
> re-
> read the original post and realized that Mirisage's question was EG
> specific.
>
> data have;
>  input name $1-11 age;
>  datalines;
> John        15
> Peter Smith 65
> ;
>
> proc printto print="c:\art\temp.txt" new; run;
>
> proc print data=have noobs;
>   title;
> run;
>
> proc printto;
> run;
>
> FILENAME _cb CLIPBRD;
> DATA _NULL_;
>  FILE _cb;
>  infile "c:\art\temp.txt";
>  input;
>  if _n_ eq 3 or _n_ gt 4 then do;
>    put _infile_;
>  end;
> RUN;
>
> FILENAME _cb CLEAR;
>
> Can such code be run from EG?  Having never used it, I don't know, but
> doubt
> it.
>
> Thanks in advance,
> Art
> -------
> On Fri, 29 Jun 2012 11:30:00 -0400, Mirisage Fernando <neilfrnnd@GMAIL.COM
> >
> wrote:
>
> >Hi Joe,
> >Your both responses are very helpful and they are the ones I have
> >exactly been looking for.
> >
> >Thank you very much
> >
> >Mirisage
>
[prev in list] [next in list] [prev in thread] [next in thread]