sas >> Enterprise guide questions

by cool_guy » Wed, 11 Jan 2006 22:13:28 GMT

We've just installed EG (3.1) in our shop and it looks pretty cool. I like the way it draws a process flow (when you point and click build a project). Learning that it is difficult to take an existing SAS program and try to "re-do" in in EG. But I'm stubborn and trying anyway (really want the cool process flow). I've several questions here and hope someone else has already solved.

1) Global search and replace for all code tasks (nodes). I have a dozen or so code tasks, and it seems I have to manually open them up one at a time to search for words or phrases. I'd like to search all code tasks (nodes) simultaneously. Am I missing something?

2) Global options settings. I want to test my code with an "options obs=99" for the whole project. When I add a code node at the top, It seems that I have to run it twice for the options to take effect. Also, If I run this same project as a scheduled process, the "obs = 99" is ignored altogether. Weird I know.... Also, are macro variables global and available to all code nodes?

3) order of code nodes. Is the execution order the same as the order in the project window? Is there a good way to change the order of these nodes? Dragging and dropping in the project window sucks (it does not auto scroll when you reach the top or bottom of the window).

4) Data set views no longer have different icons compared to non view data sets (yes I'm being picky here)

5) Big red "X" in a node, but I can't find any error in the log. What gives?

6) Is there a "types=" option in the summary node?

Thanks to anyone who can give advice here!

Cool

sas >> Enterprise guide questions

by ipmikon » Thu, 12 Jan 2006 00:02:09 GMT


Hello Dave.
I personally like EG very much, despite it still looks like unfinished
product.

No, you're correct. Thats why i prefer to store my code tasks as .sas
files. If i need global search/replace, i use UltraEdit.
Actually you can do it even with the code embedded in project (i do not
recommend it though):
1) backup your project file.
1) Made a copy of project file with extension .zip
2) Extract project.xml
3) Do search/replace with any editor, which supports Unicode.
4) Repack project.xml back into zip file
5) Change extension from .zip back to .egp
6) Open project file with EG and pray that all will be OK!

You can have your custom code to run before EACH task. Go to
Tools->Options->Tasks->Tasks General, check "Insert custom SAS code
before task and query code" and press "Edit...".

Execution order is from up to down and from left to right on Process
Flow view, not Project view! Also remember, you can have several
process flows in one project. Process flows can be scheduled
separately.

Well, use naming conventions (prefix views with "view_", for example)
;-)

There is a bug when "X" remaines from last failed run, even if
succeeding runs were successful.

I'm afraid not. But you can always add lines to generated code by
checking "Preview Code" and then pressing "Insert Code".

Regards, Mikhail

sas >> Enterprise guide questions

by cool_guy » Thu, 12 Jan 2006 21:54:14 GMT

Mikhail,

Thanks very much for your detailed response. Coupla more comments if I may:

1) I've found that you can keep (and edit) your sas programs outside of the EG system and just link them into an EG project. I also use Ultra Edit also

2) Yep, found it.....thanks

3) Understood about the top-bottom, left-right. Only problem is that there is no link (line) if you have manual code nodes. I guess you have to trust your positioning

4) Agree, I usually use the "V" prefix (e.g., vMyData)

5) This really is an issue!

6) I'll give it a try. Thanks!

Thanks again,
Dave









Hello Dave.
I personally like EG very much, despite it still looks like unfinished
product.



No, you're correct. Thats why i prefer to store my code tasks as .sas
files. If i need global search/replace, i use UltraEdit.
Actually you can do it even with the code embedded in project (i do not
recommend it though):
1) backup your project file.
1) Made a copy of project file with extension .zip
2) Extract project.xml
3) Do search/replace with any editor, which supports Unicode.
4) Repack project.xml back into zip file
5) Change extension from .zip back to .egp
6) Open project file with EG and pray that all will be OK!



You can have your custom code to run before EACH task. Go to
Tools->Options->Tasks->Tasks General, check "Insert custom SAS code
before task and query code" and press "Edit...".



Execution order is from up to down and from left to right on Process
Flow view, not Project view! Also remember, you can have several
process flows in one project. Process flows can be scheduled
separately.



Well, use naming conventions (prefix views with "view_", for example)
;-)



There is a bug when "X" remaines from last failed run, even if
succeeding runs were successful.



I'm afraid not. But you can always add lines to generated code by
checking "Preview Code" and then pressing "Insert Code".

Regards, Mikhail

Similar Threads

1. SAS and Enterprise Guide Question

2. Questions about SAS Enterprise BI Server/Enterprise Guide

Hello,

  I work for the NYC Dept. of Health.  NYCDOH is thinking of purchasing
SAS's Enterprise BI Server, and I was wondering if any of you SAS gurus have
had any experience with this product.  SAS recently demo'd Enterprise BI
Server for us.

  I'm wondering how hard it is to learn to use this product?  Also, as
someone who considers himself a "real" SAS programmer (though not as expert
as many on this list) who writes code "from the ground up" (no
point-and-click creation of code), I had the impression that under
Enterprise BI Server the user will not "write" code anymore, but rather
create it using point-and-click operations.  Is this the only way to create
code in this product, or will one still be able to write code the
old-fasioned way?  I'm worried that use of this product will lead to atrophy
of my SAS programming skills, which is not good for the career/resume.
Also, much SAS programming is to manage/massage data, and I had the
impression one cannot do this in Enterprise BI Server.

  Any thought?

  Thanks,

  Howard Alper

3. Enterprise Guide and Enterprise Miner.

4. Cleaning up Enterprise Guide - two questions

Hello colleagues,
Isn't EG full of useless problems?  (That's not one of the questions).
Any help with the questions below gratefully appreciated.
Thanks!

1 - How do you get EG version 3 to read an autoexec.sas?

2 - How do you get EG version 3 to lose the completely unnecessary
bits of code in the log - e.g. the code below that I asked sas to run
was:
%put;
and look at all the rubbish that comes out.


1          *';*";*/;run;
2          OPTIONS PAGENO=MIN;
3          ODS _ALL_ CLOSE;
NOTE: Some of your options or statements may not be supported with the
Activex or Java series of devices.  Graph defaults for these
      drivers may be different from other SAS/GRAPH device drivers.
For further information, please contact Technical Support.
4          OPTIONS DEV=ACTIVEX;
5
6          ODS LISTING;
7
8          %LET _CLIENTTASKLABEL=%NRBQUOTE(Code1);
9          %LET _EGTASKLABEL=%NRBQUOTE(Code1);
10
11         %put;

12
13
14
15         %LET _CLIENTTASKLABEL=;
16         %LET _EGTASKLABEL=;
17
18         ODS _ALL_ CLOSE; RUN;
19         *';*";*/;run;
NOTE: Writing HTML Body file: _EGCLOSE
20
21         QUIT; RUN;
22         %_egepilogue;

NOTE: 1 lines were written to file PRINT.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds


NOTE: Fileref _EGCLOSE has been deassigned.

5. ODS - Enterprise Guide output question

6. Enterprise Guide 3.0: Which Graph Question...

Hi,

I know this is probably a really simple question, but I'm trying to make a
Bar graph, with a line over the top of it .... I wan the bars to represent
one stat, and the line to represent another.

Eg. I have one column which represents average transaction value for the
day, and another which represents the volume of transactions.

I hoped I could get both these on the one graph.... any idea which graph
type I could use from the task list ?

Regards,
Timothy Findlay.



************************************************************************
      IMPORTANT -

(1) The contents of this email and its attachments may be confidential
      and privileged. Any unauthorised use of the contents is expressly
      prohibited. If you receive this email in error, please contact us,
      and then delete the email.

(2) Before opening or using attachments, check them for viruses and
     defects. The contents of this email and its attachments may become
     scrambled, truncated or altered in transmission.  Please notify us
     of any anomalies.

(3) Our liability is limited to resupplying the email and attached files
     or the cost of having them resupplied.

(4) We collect personal information to enable us to perform our
     functions. For more information about the use, access and
     disclosure of this information, refer to our privacy
     policy at our website.

************************************************************************

7. Help on SAS Graph Code question in Enterprise Guide

8. Enterprise Guide SAS/Graph Problem

All

I've been trying to use SAS/GRAPH in Enterprise Guide and the graphics
are blurrier than in plain old SAS program editor.  Has anyone else
had these problems before?  Unfortunately, our set up here is to use
EG and SAS is only installed on the Windows Server and us little ole
SAS programmers are not allowed to remote into it.

-Darryl