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

Join Now

SAS Enterprise Guide: Hidden Gems

by SAS Employee ShannonMoore on ‎07-03-2017 05:48 PM - edited Tuesday by Community Manager (1,063 Views)

Gems.png

 

Did you miss the Ask the Expert session on SAS Enterprise Guide: Hidden Gems? Not to worry, you can catch it on demand at your leisure. I’ve attached the slides as well.

 

Watch the webinar

 

This session looks at both new and existing functionality of SAS Enterprise Guide to help both novice users and longtime programmers.

 

Learn about filtering options, task and code templates, prompts, computed columns, subqueries, adding SAS code to a process flow and more.

 

Here are some highlighted questions from the Q&A segment held at the end of the session for ease of reference.

 

Does the equal to option have to be in numeric?­

 

It can also be alpha-numeric­.

 

­What is the reason of using query builder instead of using the query code?­

­

 

The Query Builder allows you build the SQL query code using a point-and-click wizard­.

 

­I must've disabled the Log Summary. Is there a way to get it back?­

 

­Yes, you can get it back from the View tab from the tool bar­. ­You will see the Log Summary towards the bottom of the list or near the middle of the context sensitive tool bar on the log tab in Enterprise Guide­.

 

­

I clicked on Log Summary in the View tab and nothing happens.

­

 

It may be minimized at the very bottom, you may have to look for it and stretch it using the mouse, and depending on your version of EG, you may be able to select the summary once you run another program in EG­.

 

­

How do you display the actual values on the x-axis for the Bar Chart?­

­

 

There should be a check box option in the Bar Chart task as you step through the different options.  You should see the check box option to turn on/off x and y data labels and/or values.

 

­If I am using the Summary Tables Wizard and I've selected a specific variable to utilize as a Column for Step 3. In creating my table, how can I select the order the values appear as columns in the table instead of the default alphabetical order?

 

The values selected will appear in the order you select them.  If you want to change the order you can use the up and down arrows to change the order.

 

­

A basic question - how to easily change data type between character and numeric in an EG program­?

 

You can use data step code or various functions in code or in the Query Builder node.  Check out this SAS Note for more information. 

 

­In logistic regression - how can I change the code to display the original data as points (rather than the default of hollow circles) and to 'jitter' them?­

 

You can’t really change these options in the built-in task.  You can, however, edit the code generated by the task.  You could also use the procedure to create an output dataset and use SGPLOT to graph the data.­  Please see this document for more information. 

 

­How to transform data in CSV to SAS format using Enterprise Guide?­

 

­There is a wizard from the tool bar under file select Import Data and step through the wizard and it will convert the CSV file into a SAS data set.

 

­Can we create dimensional models using SAS Enterprise Guide?­

 

You can but it would be via SAS code as there is no Task that is part of the interface.

 

Recommended Resources

Course: SAS Enterprise Guide 2: Advanced Tasks and Querying
Book: SAS® Programming for Enterprise Guide® Users, Second Edition

 

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.

Contributors