SAS expertise delivered to your desktop -- on-demand and free!

Join Now

Getting Started with SAS Enterprise Guide

by SAS Employee megak8 on ‎03-03-2017 04:14 PM - edited on ‎11-21-2017 11:23 AM by Community Manager (1,856 Views)

Did you miss the Ask the Expert session on Getting Started with SAS Enterprise Guide? Not to worry, you can review it on-demand here.

Watch the webinar


Technical experts from the SAS Customer Loyalty team will introduce you to SAS Enterprise Guide.

You'll learn how to access SAS data, run tasks and change output format, manipulate data in the Query Builder window, and use the SAS Enterprise Guide programming interface.

 Getting Started with EG image.jpg




Here are some highlighted questions from the Q&A segment held at the end of the session for ease of reference. Attached you'll find the slides.


How do we transpose­?

There are a few different tasks in Enterprise Guide that will do this, such as: Split Columns, Stack Columns, Transpose. These tasks can be found under Tasks -> Data­.


For Excel sheets what are the limitations...# of records?­

SAS does not limit the number of records that you can read or write – your hardware and architecture dictate scalability. If you are creating Excel spreadsheets and reach the maximum number of rows, SAS will create another worksheet for the remaining data.­ Please check with Microsoft for its technologies’ constraints.


Do we need to have a database? Can we work off Excel sheets only?­

Yes, you can work from Excel spreadsheets only. With SAS/ACCESS to PC File Formats, you can read Excel data and Enterprise Guide will create SAS data sets.­


What are the options for accessing EG? Client/server, local individual machines, Citrix based?­

Yes, all of those configurations are supported.


What is the difference between a Project and a Program?­ How does a process flow differ from a program?

A program is SAS code that can be stored externally or within an Enterprise Guide project. A project is the main way that Enterprise Guide organizes its work; a project can contain code, tasks, data and other components.­ ­A process flow is a portion of a project; it can contain code, tasks, data, etc. A project may contain multiple process flows­ and programs; a process flow can contain multiple programs and tasks.


Can you pull data directly from an Oracle database with an access front end directly into SAS Enterprise? ­

You would need SAS/ACCESS Interface to Oracle. This technology allows you to view, analyze, write and build load Oracle data from within Enterprise Guide as if it were a SAS data set.­


How do you handle the data when SAS Enterprise Guide removes the leading zero when it's exported? This is a zip code and has already been converted to numeric. SAS holds the zero but it's removed upon export. Is there a way around this within SAS?­

Is the number stored as numeric in the SAS data? If so, the leading zeros would not be stored as part of the value. You may want to experiment with storing the zip code as character in the SAS data.­ It was converted into a numeric within SAS because as a character it was stripped in both SAS and Excel; converting it to numeric SAS retained the leading zero but Excel stripped it out­. ­If it was stored as a numeric in SAS, then it would not store the leading zeros. Perhaps the leading zeros were there because of applying a SAS format?


Can Enterprise Guide be used as a data/document repository with Windows File Explorer like navigation?­ ­

You can navigate your files and data via Enterprise Guide’s ‘servers’ icon of the lower left corner’s resources pane. Your administrator’s decisions dictate how your server’s storage is organized and how it appears in SAS Enterprise Guide.


How to identify and delete duplicates rows­?

There are many techniques for de-duplicating, such as running data explorations or distributions, generating match codes.


Will they cover system security set-up including user roles and rights and permissions into data sources?­

This recording for SAS administration tasks is a good place to start.

The SAS Administration Coaches Corner on March 8 is a great way to get your SAS administration-related questions aired and answered.

Also check out this SAS administrators support page, this series of how-to tutorials and this blog about resources for SAS admins.


When a project has multiple process flows, can you run all process flows in succession, without having to click on each flow in the project tree window and click run?­

Yes, you can run an entire project or portions of it via right mouse clicking and running. Scheduling is also available via file -> schedule.


Can you report data from SAS into a JMP data table? Instead of Excel, PowerPoint, pdf, etc... ?

Yes, creating these outputs his can be handled programmatically from the program window.


Can you show an example of the audit trail from Process Flows, e.g. user id/name, date, time, action - how is this saved and can it be printed?­

View -> Project Log invokes and reviews more detailed audit trail specifications. We encourage you to visit and interact with your peers in SAS Health Care and Pharma and SAS Clinical Development healthcare specific communities to see how they handle healthcare-specific audit trails.


Can we set up a session to address the two questions that were out of scope for this session?

Please contact your SAS representative after reviewing the suggested communities and links if additional assistance is required.


Recommended Resources

Course: SAS Enterprise Guide 1: Querying and Reporting

Book: The Little SAS® Enterprise Guide® Book


Want more tips? Be sure to subscribe to the Ask the Expert Community Library to receive follow up Q/A, slides and recordings from other SAS Ask the Expert webinars. From the Ask the Expert Library, just click Subscribe from the orange bar underneath the list of the recent articles.


NOTE: For best results when opening the attached slides, click on the “download” icon.

by Contributor bondtk
on ‎04-04-2017 06:34 AM

Please advise how do I import excel file in SAS enterprise guide.