Stack Overflow
Stack Overflow

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
2
votes
1 answer

SAS Enterprise Guide Count IF

I'm looking to be able to perform the equivalent of a count if on a data set similar to the below. I found something similar here, but I'm not sure how to translate it into Enterprise Guide. I would like to create several new columns that count how…
Jamison
  • 73
  • 2
  • 8
2
votes
1 answer

SAS Enterprise Miner Server Directory

I am new to SAS enterprise Miner and trying to create my first project. When I click on "New Project", I was prompted to enter "project name" and "server directory". When I entered a project-name and local-directory (C:\Folder-name) I am getting…
user3007712
  • 57
  • 7
2
votes
1 answer

Size of a SAS dataset is increasing on using a where clause

I have a SAS dataset sized close to 20 GB, I am trying to use a where clause but am unable to do so as the size of the dataset is swelling up and I am getting as error stating: SAS file is full. When I last looked at the dataset being created in the…
Ishan Basu
  • 181
  • 1
  • 1
  • 12
2
votes
1 answer

Using SAS X Command with PCFILES server

I have some SAS code that writes out to a specific sheet in an excel workbook. The other sheets have formulas that look to this sheet so the workbook is basically a template that gets populated when my code is run. I want to be able to run the code…
JstSomeGuy
  • 119
  • 7
2
votes
2 answers

How to mark a task to not execute in a Flow?

I have a flow in SAS Enterprise Guide but for debug reasons I want some tasks to run and others don't. Is there a way to tell the flow to not execute some tasks? F.E. an export task.
songbuster
  • 43
  • 5
2
votes
2 answers

PROC APPEND massive log size is crashing Enterprise Guide

I am using Enterprise Guide 4.2 (no choice about this). I am using PROC APPEND to append about 80k+ observations to a SQL Server table. I believe that there are some issues with the format of the data (such as mismatching variable lengths), but it…
JDB
  • 25,172
  • 5
  • 72
  • 123
2
votes
1 answer

SAS EG Summary Table percentage

When I use Summary Tables in EG to calculate some percentages the result is always multiplied by 100 (5.2 percent is not displayed as 0.052 but as 5.2). Now, if I want to display this as '5.2%' I have to divide the number by 100 and then apply the…
Dejan Peretin
  • 10,891
  • 1
  • 45
  • 54
1
vote
4 answers

How do I loop through table records in SAS?

I am new to SAS and trying to solve the following scenario: Scenario: A loan (123) has more than 2 transactions on a given transaction date. And, each record has a columns: ID, Trans_Amt, LoanNo, etc. I was asked to create a column to show if two…
Dileep
  • 11
  • 2
1
vote
4 answers

How to fill missing values in numeric columns by using 0 in one table base on existing these columns in other tables in SAS Enterprise Guide?

I have tables in SAS Enterprise Guide like below: TABLE 1 COL1 | COL2 | ... | COLn -----|------|------|------- 123 | | ... | xxx | AAA | ... | xxx 122 | BCC | ... | xxx ... | ... | ... | xxx And also 2 other tables like…
dingaro
  • 2,156
  • 9
  • 29
1
vote
2 answers

How to create new column in PROC SQL with sum of values per month in SAS enterprise Guide?

I have query in proc sql in SAS Enterprise Guide like below: proc sql; select event , mnth , value from table1 order by mnth, name ;quit; Above proc sql query gives result as below: event| mnth | value -----|-------|------- ABC | APRIL |…
dingaro
  • 2,156
  • 9
  • 29
1
vote
4 answers

ERROR: Function SUBSTR requires a character expression as argument 1. and adding zeroes in front of data

My end goal is to add zeroes in front of my data, so 918 becomes 0918 and 10 becomes 0010 limited at 4 characters. My solution so far is to use SUBSTR like i do below: PROC SQL; CREATE TABLE WORK.QUERY_FOR_DAGLIGEKORREKTION_0000 AS SELECT…
Christoffer
  • 326
  • 1
  • 4
  • 20
1
vote
1 answer

How to transpose EG5.1

I have a data set of approximately this format: Table format : ID 2012 2013 2014 A 1 3 B 2 4 And I want to transpose it to this format: Table format : ID Source Value A 2012 1 A 2013 3 B 2012 2 B 2014 4 Using the…
KD97
  • 35
  • 4
1
vote
1 answer

Colorize background of grouped headers with tagsets excelXP

I'm trying to colorize the grouped headers in my tagsets.ExcelXP report, I know how to colorize the headers of the ungrouped columns but do not know how to change the background color of the grouped ones. This is the sample code I'm using: data…
Costantino Beretta
  • 13
  • 1
  • 4
1
vote
1 answer

Why am I unable to access SAS Library

I am running the following code in SAS EG: Data sashelp.air; proc sgplot data=sashelp.air; histogram AIR /; yaxis grid; run; ERROR: User does not have appropriate authorization level for library SASHELP.
as_cool_as_aish
  • 31
  • 4
1
vote
1 answer

Grouping range columns in SAS EG

I'm importing data into SAS that is divided into columns by monetary value. The data in the columns is a count of how many people fit into that category. Income_0-50K Income_50-100K Income_100K+ 5 10 5 Once imported, I'd…
Alice Wang
  • 29
  • 4
1 2 3
…
27 28