SAS Enterprise Guide: Getting Started

[#1]

Did you miss the Ask the Expert session on SAS Enterprise Guide: Getting Started? Not to worry, you can catch it on-demand at your leisure.

Watch the webinar

This session introduces you to SAS Enterprise Guide. You 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.

Below are some of the questions and answers that occurred during this webinar.

­Is there a way we can join two tables on customer ID in Query Builder itself, where one table has customer ID field in Char format, and other table has customer ID field in numeric format? ­

The Query Builder requires that the variables used for joins be defined in a compatible way. You can use the INPUT or PUT functions to convert values so that you can join within the Query Builder.

Is there a way to change the datatype of one of the variables while joining in the Query Builder itself?­

The Query Builder does not let you re-define data types for existing variables. However, you can create a new column that has the desired data type and then use it for the join.

How can I reformat numeric to character in an existing table?

You could use a computed column in the query builder and the using the PUT function. Top 10 SAS Functions materials are here.

The ­List Data task only works for a SAS dataset not a non-SAS file. Is that correct?­

Yes, List Data generates PROC PRINT code behind the scenes and is appropriate for SAS data only.

­How do your specify prompts for the process flow? How would I provide a value to the SQL that is running?­

The following paper has a very good description of creating and using prompts within SAS Enterprise Guide.

­How do you open multiple process flows? Is there something like an open -> new process flow?

­

­Yes. You can open a new process file by selecting File -> New -> Process Flow­.

What is the difference between SAS Enterprise Guide and SAS Enterprise Miner as it relates to analytics, especially predictive analytics?

SAS Enterprise Guide is a versatile Windows interface that harnesses data management, visualization, discovery and analytics techniques, via code generation (point-and-click tasks) and a sophisticated program editor. SAS Enterprise Miner is a specialized web browser that creates, compares, and executes predictive models.

When viewing output data, how can I see a summary total for a particular column? 

You could use the Summary Statistics, Summary Tables Tasks or the Query Builder. A Deeper Dive into SAS Enterprise Guide Reporting webinar covers some of these aggregations.

Want more tips? Be sure to subscribe to the Ask the Expert board to receive follow up Q/A, slides and recordings from other SAS Ask the Expert webinars. To subscribe, select Subscribe from the Options drop down button above the articles.

[MarkusWeick]

Thanks for the lively webinar!

[MarkusWeick]

Hi @dfrank, have a look at this page!

Best

Markus