Re: Remote server and proc univariate histogram graphics

Dear SAS-L-ers,

Alex Pavluck posted a reply to the ever helpful David L. Cassell's query for more information on his problem.

<<Alex's entire posting can be found beneath the Sig line.>>

Alex, this is a toughie, and I cannot offer a good opinion/solution about your particular problem on the foreign server. However, I can offer a workaround. And that, my friend, may at least get you over the hump on this problem.

You have been working with SAS/CONNECT'S Compute Services. How about working with its Remote Library Services. In doing so, you will allocate the foreign host's SAS data library as a "local library" using SAS/CONNECT, and then run your PROC UNIVARIATE on your desktop. It will haul the data over the network to your PC and perform the Univariate on your workstation. Since you _CAN_ see the graphics on your workstation, you will achieve your desired end result.

Here is how I might code the workaround:

LIBNAME UNIXLIB "/home/alexlib/sasdir" SERVER=ALEX1;

PROC UNIVARIATE DATA=UNIXLIB.ONE;
VAR AGE_INT;
HISTOGRAM AGE_INT /NAME="AGE_HIST";
RUN;

In the example, let's assume that you already have signed onto your "UNIX" server by the time that the LIBNAME is executed. The LIBNAME statement is using the SERVER option, which tells SAS that it should look for the "/home/alexlib/sasdir" SAS data library on the ALEX1 server that it is connected to. Now, you can execute the PROC UNIVARIATE on your desktop (without sandwiching it between RSUBMIT and ENDRSUBMIT) to get your UNIVARIATE completed--avec graphics--on the privacy of your desktop. Not too shabby, eh?

Now, I know that this may not be the greatest way to do this, considering that you are hauling buckets of data across your network, and that you are heaping mounds of data on your own beleaguered C-drive, and that your workstation may glow bright red burning up CPU time. But, hey: THIS IS A WORKAROUND FOR GOODNESS SAKES!

Alex, best of luck to you in resolving your primary problem and/or using this workaround to satisfy your analysis needs!


I hope that this suggestion proves helpful now, and in the future!

Of course, all of these opinions and insights are my own, and do not reflect those of my organization or my associates. All SAS code and/or methodologies specified in this posting are for illustrative purposes only and no warranty is stated or implied as to their accuracy or applicability. People deciding to use information in this posting do so at their own risk.

++++++++++++++++++++++++++++++++++++++++++++++++++ +++++++++
Michael A. Raithel
"The man who wrote the book on performance"
E-mail: MichaelRaithel@westat.com
Author: Tuning SAS Applications in the MVS Environment
Author: Tuning SAS Applications in the OS/390 and z/OS Environments, Second Edition
http://www.sas.com/apps/pubscat/book...tid=1&pc=58172

Currently Writing: The Complete Guide to Creating and Using SAS Indexes (due Fall 2005)

++++++++++++++++++++++++++++++++++++++++++++++++++ +++++++++
A friend is someone who will help you move. A real friend
is someone who will help you move a body. - Unknown
++++++++++++++++++++++++++++++++++++++++++++++++++ +++++++++

<<Alex's entire posting>>

> -----Original Message-----
> From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On
> Behalf Of Alex Pavluck
> Sent: Wednesday, May 11, 2005 10:02 AM
> To: SAS-L@LISTSERV.UGA.EDU
> Subject: Re: Remote server and proc univariate histogram graphics
>
>
> David, Thanks for the reply. Here is what we know:
>
> No error message is being generated. Here is the program and
> the log. It does work when we run it locally but that is not
> the ideal setup.
>
>
> PROC UNIVARIATE DATA=ONE;
> VAR AGE_INT;
> HISTOGRAM AGE_INT /NAME="AGE_HIST";
> RUN;
>
> NOTE: Background remote submit to NHOSAS01 in progress. ß
> remote submit
> NOTE: Remote submit to NHOSAS01 commencing.
> 98 PROC UNIVARIATE DATA=ONE;
> 99 VAR AGE_INT;
> 100 HISTOGRAM AGE_INT /NAME="AGE_HIST";
> 101 RUN;
>
> NOTE: The PROCEDURE UNIVARIATE printed pages 1-2.
> NOTE: PROCEDURE UNIVARIATE used (Total process time):
> real time 1.18 seconds
> cpu time 1.14 seconds
>
>
> NOTE: Remote submit to NHOSAS01 complete.
>
> 102 PROC UNIVARIATE DATA=ONE; ß- Local begins here
> 103 VAR AGE_INT;
> 104 HISTOGRAM AGE_INT /NAME="AGE_HIST";
> 105 RUN;
>
> NOTE: PROCEDURE UNIVARIATE used (Total process time):
> real time 39.57 seconds
> cpu time 1.53 seconds
>
>
> We are not able to determine if the graphics format is
> supported by the server since it was setup by a consultant.
> We can generate list output (stem and leaf plot) but not
> graphics (ie histogram option in proc univariate). Our hope
> is that it is being written to the server and we are unaware
> of how to retrieve it. Is there some sort of rchart command?
>