Questions tagged [enterprise-guide]

Questions about using SAS Enterprise Guide as an IDE for writing SAS programs, or about setting up Enterprise Guide to connect to your SAS server. Questions about using Enterprise Guide that are not related to programming are not on topic (such as using its interactive point-and-click features to perform data analysis) - ask those on the SAS community forums.

Enterprise Guide ("EG") is the graphical user interface/IDE for the SAS system intended for novice and advanced users, simplifying common tasks with wizards and menu options while permitting advanced code to be written and run as well. EG also manages server connections to allow a user to execute SAS tasks without owning an individual seat license for a full SAS installation. Many concepts from EG will look familiar to users of other IDEs - project flow, the connection manager, etc. - but it is also intended to be easily used by novice users by putting access to commonly performed tasks in easily found locations.

SAS EG is also the interface for many of SAS' advanced tools, such as SAS BI.

Link to EG guide on SAS website

408 questions
17
votes
3 answers

Open SAS .egp file to view code without having SAS installed

Is there any solution to open SAS .egp file without having SAS installed on my pc? I need to open project.egp to check my old code but I don't have SAS anymore. Is there any other way to do that?
Residium
  • 281
  • 1
  • 4
  • 8
11
votes
3 answers

Tell SAS not to add newly generated tables on the Process Flow

I have a SAS code that creates a lot of intermediary tables for my calculations. Thing is, I don't really care about this tables after the job is done, I only care to the finals results. But, everytime I run this code, SAS add all the generated…
cake
  • 1,336
  • 1
  • 13
  • 20
7
votes
3 answers

How to call one macro program from another in SAS Enterprise Guide?

Is there any macro command that allows calling one program from another (the %run_program() pseudo code)? Program "Settings": %let myvar="HELLO WORLD!"; Program "Program": %run_program(Settings); *Pseudo-code; %put &myvar; *Should print *Should…
Adam Ryczkowski
  • 7,592
  • 13
  • 42
  • 68
6
votes
3 answers

SAS Enterprise Guide customize interface color

Is there any way of changing the background color of SAS Enterprise Guide windows? I have spent more than an hour trying to find a solution, but no success. Unfortunately my eyes cannot take the white background anymore. Thanks in advance!
user3450188
  • 61
  • 1
  • 3
5
votes
1 answer

adjusting the project.xml file in a SAS Enterprise Guide project outside SAS EG

We are going to migrate our EG projects (over 1000 projects) to a new environment. In the old environment we use "W-Latin" as encoding on the Teradata database. In the new environment we will start using "UTF-8" as encoding on the Teradata…
Aniel
  • 53
  • 5
5
votes
3 answers

how to list all available user defined macros in SAS Enterprise Guide?

Say in my main code I have this code block: %macros hi5; %put hi five; %mend; %macros helloworld; %put hello world; %mend; How do I, in SAS Enterprise Guide, display something like this? (via log or via a SAS table) These are the user defined…
Atlas7
  • 2,726
  • 4
  • 27
  • 36
5
votes
3 answers

Shortcut to comment selected code in SAS Guide

is there some shortcut to just comment the selected code in SAS Enterprise Guide? There is Ctrl + / to comment the selected line. But would be really useful to comment just a selected part of the code. Thanks.
Ana Ferreira
  • 79
  • 1
  • 9
5
votes
1 answer

Running SAS Enterprise Guide Job on windows Server

I have written a piece of code in SAS EG that simply opens an Excel workbook. The Excel workbook contains VBA code that is executed upon the "Workbook Open" Event. All the code pretty much does, is it refreshes all data connections the first time…
HermannHH
  • 1,732
  • 1
  • 27
  • 57
5
votes
2 answers

SAS EG 4.1 path to code file

I'm using SAS Enterprise Guide 4.1 and my projects consist of a lot of code. That code is organized in external .sas files, mainly because .egp files are binary and plain text .sas files work better with git. Problem is that SAS EG 4.1 uses apsolute…
Dejan Peretin
  • 10,891
  • 1
  • 45
  • 54
5
votes
2 answers

How can I stop tables appearing in Enterprise guide?

I'm writing procedure for other users to run in Enterprise guide based on SAS 9.3. It logs various bits of information to a table. Is there any way to stop this table appearing in the process flow? NB This is almost all done using "User written…
syntheticbrain
  • 288
  • 2
  • 13
4
votes
2 answers

Referencing one computed column from another

I'm using SAS Enterprise Guide 7.1 and i'm having a problem with something that seems fairly basic. I'll simplify the problem but fundamentally I have one computed column (Computed_column1) that uses a CASE/WHEN statement e.g. CASE WHEN x > y THEN…
user3298004
  • 185
  • 2
  • 3
  • 10
4
votes
3 answers

How do you in SAS return the list of all columns in all tables in a library that contain a target value?

I am trying to map out fields I see in an application to columns in the source database using SAS EG. If I search for 'SomeString' or someNumericValue in Library = SomeLibrary I want the code to output a table that lists the tableName ColumnName…
SQALEX101
  • 209
  • 1
  • 3
  • 16
4
votes
1 answer

Exporting / Importing SAS Enhanced Editor color schemes

In this previous question, a solution was given to export registry entries pertaining to the editor schemes. However, the solution seems relevant only to the old Program Editor used in earlier SAS Display Manager versions, not to the Enhanced Editor…
Dominic Comtois
  • 10,230
  • 1
  • 39
  • 61
4
votes
2 answers

SAS EG - Open a table without creating table link in process flow

This seems rather trivial, but in SAS Enterprise Guide, is there a way to simply open a SAS dataset from a SAS library without having a shortcut added automatically to the process flow?
Dominic Comtois
  • 10,230
  • 1
  • 39
  • 61
4
votes
1 answer

How to create SAS EG Flow programmatically?

I write a solution which manages execution of complex calculations written in heterogeneous environments (R, SAS, Oracle). One of the features I might want to add is the ability to create a nice SAS Enterprise Guide flow using the SAS branches of…
Adam Ryczkowski
  • 7,592
  • 13
  • 42
  • 68
1
2 3
27 28