2009 eg 4.1 for pc sas users group... · 2016-03-11 · thursday -may 7 th, 2009 4 eg 4.1 for...

Thursday - May 7th , 2009

I C TEG 4.1 for PC-SAS Users

EG 4.1 EG 4.1 EG 4.1

PCPC--SAS usersSAS usersforfor


2

EG 4.1 for PC-SAS UsersI C T

AgendaAgenda

EG 4.1 for PCEG 4.1 for PC--SAS UsersSAS Users� What EG 4.1 is?

� EG 4.1 vs. PC-SAS.

� Why not to use EG 4.1?

� Why to use EG 4.1?

� What’s next for EG?

� Conclusion.

� Questions.


3


Monday, October 7th, 2002

SAS Enterprise Guide 2.0 Empowers Users !

What EG 4.1 is?What EG 4.1 is?

Tuesday, September 5th, 2000

SAS ships Enterprise Guide !


4



� GUI interface on top of SAS 9 engine.� Same as Windows 3.1 GUI on top of DOS OS

� Visual workspace for Local and Remote SAS 9 servers.

� Project, process flow and Task Oriented.� Saves .egp and .sas files

� A SAS GUI & Development tool for Power users.� Ad-hoc reports.

� Data Analysis.

� Automate SAS scripts.

� Create EG projects with parameters.

EG 4.1 is : Point EG 4.1 is : Point -- and and -- Click Click access to the power of SASaccess to the power of SAS

I


5



� Windows tool only (written in .Net C#).� SAS runs on Windows, UNIX/LINUX and Mainframe.

� Custom Add-in Tasks.� Create your own Tasks using .Net VB or C#.

� EG Task for almost every SAS PROC.

� PDF, HTML, RTF and OLAP viewer.

� Query Builder & Stored Processes Wizards.

� Visual Process Flow (Input �� Process �� Output)

� Similar to a Flowchart diagram.

EG provides a guided mechanism EG provides a guided mechanism to exploit the power of SAS to exploit the power of SAS

II


6


� Project designer (Workspace)� Contains one or more Process Flow

� Process Flow� Contains one or more branches

� Branch� Each branch contains

� Two or more Objects

� one or more Links

EG 4.1 Project ComponentsEG 4.1 Project Components

Process Flows

A simple Branch contains: two objects & one Link

What EG 4.1 is?What EG 4.1 is? III


7


� EG 4.1 Objects � Data

� Code

� Reports

� Note

� Log

� Output file

� EG Task� Schedule

� Email

� Export

� Query

EG 4.1 ObjectsEG 4.1 Objects

IV

Code

Export step

Notes

Data Set or View (Output)

Excel file

Query

Report

Schedule Process Flow

Email Step

SAS Data Set (Input)



8



� EG 4.1 Page Layout� Grid

� Layout

� Auto arrange

� Zoom

�EG 4.1 Page Setup� Page Setup

� Print Preview

� Print

EG 4.1 Project Designer LayoutEG 4.1 Project Designer Layout

V


9


EG 4.1 vs. PCEG 4.1 vs. PC--SASSAS


10



� PC-SAS *IDE � Program Editor Window

� Log Window

� Output Window

� PC-SAS Explorer� Results Window

� Explorer Window (File & Libraries)

� PC-SAS Debugger� Debugger source Window

� Debugger log Window

PCPC--SAS componentsSAS components

I

*IDE (Integrated Development Environment)


11



� PC-SAS IDE

� Program Editor Window

� Log Window

� Output Window

PCPC--SAS IDESAS IDE

II


12



� PC-SAS Explorer� Explorer Window

� (File & Libraries)

� Results Window

PCPC--SAS ExplorerSAS Explorer

III


13



� PC-SAS Debugger

� DEBUGGER SOURCE Windows

� DEBUGGER LOG Windows

PCPC--SAS DebuggerSAS Debugger

IV


14


Why Why notnot to use EG?to use EG?

EGEG


15



� Yet, One more Reporting tool to learn? � EG learning curve is moderate

in the beginning, but it getssteeper as you go.

� You need to know more:� You can create basic SAS EG

reports, but to get the mostof EG, you need also to have good knowledge of :� SQL & DBMS

� SAS programming

� Data analysis

� Problem solving skills

� .NET Visual Basic or C# (to build EG Custom add-in tasks)

EGEGIs it worth it to learn EG 4.1? Is it worth it to learn EG 4.1?

I


16



� EG GUI Intimidation & Complexity.� You need to learn EG GUI very well to

be able to navigate, customize and troubleshoot EG problems.

� So many new terminologies.� EG Projects, Project designer, Project

Explorer, Process Flows, Branches, Objects, Links, Note, Code, Tasks, Properties, Add-in Manager, Custom add-in task, SAS Folders, Task List, Server list, Local SAS server, SASmainSAS server, Query builder, Project Parameters, Stored Process, Repository, OLAP viewer, SAS reports, …………………

EGEGEG Barriers to EntryEG Barriers to Entry

II


17



� No SAS debugger support.

� No /debug support in EG ��

� No SAS/AF Application support.� No SAS/AF (Application Facilities).

� Only .NET VB or C# Applicationsthat is Called Custom add-in taskand is based on .Net framework 1.1.

� Not for complex SAS development.� Simple Ad-hoc reports.

� Better GUI than EG 3.0� But Still has few bugs.

EG Application Support EG Application Support EGEG

III


18



� Complex EG GUI for new users.� Busy & Crowded GUI especially when

used on small screen.

� EG projects are different from PC-SAS.� Workspace layout

� Organization, Analysis and Development

� EG is Slower than PC-SAS 9.1.� Slower to start up and open SAS servers.

� Much Slower (real time) to run simple SAS tasks –with almost the same (cpu time) due to GUI overhead.

The Project Paradigm and Workspace The Project Paradigm and Workspace In SAS Enterprise GuideIn SAS Enterprise Guide

EGEG

VI


19


Why to use EG?Why to use EG?


20



� Schedule task, Export or Email results.

� Add GUI Project parameters � To manipulate macro variables

� Add and Link objects� such as notes, tasks & code in process flow

� Graphs and tabulate made easy!� Proc Tabulate & Active X SAS Graph tasks!

� EG user-id and password authentication � Is done through *LDAP (Active Directory)

� Saves User-id and password for quick access� No need to memorize yet one more password

With EG , you can do magic! With EG , you can do magic!

*LDAP (Lightweight Directory Access Protocol)

I


21



EG is the “Swiss army knife” SAS toolEG is the “Swiss army knife” SAS tool

II

� EG Editor-Split screen (hidden) feature.� The same as IBM Xedit “set screen 2 v”

� for only the same “Code” file

� Helps to organize, document and automate your SAS work.� From scattered .sas scripts into

a set of organized EG projects!

� You can use both EG and PC-SAS for different tasks!

� Very useful tool for any SAS programmer, as it generates SAS code for you to preview and study!


22


What’s next for EG?What’s next for EG?

� The next release of SAS EG 4.2� Enterprise Guide 4.2

� Simpler GUI interface.

� Easier to use.

� Improvements and bug fixes.

� SAS Enterprise Guide 4.2� supports only SAS 9.2

� and SAS 9.2 Metadata server.

SAS Enterprise Guide FutureSAS Enterprise Guide Future

� The question now is :Will SAS Enterprise Guide be the preferred SAS development tool on (Windows) desktop in the future?


23


� Debug SAS code.

� SAS macro creation.

� Intricate data step manipulation� Such as Complex sort & merge processes..

� If PC-SAS is all what you need to get the job done and you don’t need the new features in EG

� Or .. simply .. you don’t have the time to learn a new SAS tool (if it aint broken ...)

ConclusionConclusion

Then, EG 4.1 is definitely not the

tool for you if you mainly use PC-SAS to:

Is PCIs PC--SAS all what you need? SAS all what you need?

I


24


From my experience, once you start to “think” EG and learnhow to use and navigate EG menus, options, tools and tasks, you’ll find iteasier to use and more than capablein 90% of scenarios where you would have traditionally written SAS code only.

Overall, I would say that EG can make you up to 3X as productive using EG & SAS code than just SAS code alone!

ConclusionConclusion

EG 4.1EG is the tool for you EG is the tool for you ––onlyonly-- if you need it.if you need it.

II


25


QQuestions?uestions?

??????????

?? ??????????

??????????

????????

??????????

?? ??????????

??????????

????????


26


Thank Thank You!You!


27


/debug in EG/debug in EG

/debug in EG

17 ! data iSquare/debug;18 do i=1 to 10;19 isqr=i*i;20 output;21 end;22 run;

ERROR: Unable to initialize the DATA STEP Debugger environment.NOTE: The SAS System stopped processing this step because of errors.WARNING: The data set WORK.ISQUARE may be incomplete. When this step

was stopped there were 0 observations and 2 variables.NOTE: DATA statement used (Total process time):

real time 3.01 secondscpu time 1.18 seconds

Back

2009 eg 4.1 for pc sas users group... · 2016-03-11 · thursday -may 7 th, 2009 4 eg 4.1 for...

Documents