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

How to use DATETIME in WHERE clause in SAS PROC SQL

I have this data in a SAS table: 01Sep2016:21:31:27 I want to do this: PROC SQL; UPDATE lib1.tablename1 set Valid_From = '2000-01-01 00:00:00'dt WHERE Valid_From = '1Sep2016:21:31:26'dt; QUIT; But the WHERE clause doesn't match. What is the correct…
Dirk Sachse
  • 57
  • 3
  • 12
2
votes
4 answers

Extract parts of a string after a key word in SAS EG

I am attempting to extract parts of a string with carriage returns based on a keyword in SAS eg. Str="started manually 23:56:22 Skipped: obtain name Completed: verify dob Skipped: ask again Skipped: verify address Completed: verify country Stopped…
hadoo
  • 213
  • 1
  • 12
2
votes
3 answers

Replacing Turkish characters with English characters

I have a table which has 120 columns and some of them is including Turkish characters (for example "ç","ğ","ı","ö"). So i want to replace this Turkish characters with English characters (for example "c","g","i","o"). When i use "TRANWRD Function" it…
Doganay Yildiz
  • 75
  • 2
  • 7
2
votes
1 answer

Changing SAS EG project from local server to sas app server

Is there a way to change my SAS enterprise guide project from running local to run on my sas app server, without making the a new project from the beginning?
Jannick Mikkelsen
  • 121
  • 2
  • 15
2
votes
1 answer

How to view a SAS dataset in form view via Enterprise Guide?

The Background In Base SAS, you can view a SAS dataset in either "form view" or "table view" For example... In table view, you view the entire table, showing all columns and rows. in form view, you view one record (or row) at a time. By default…
Atlas7
  • 2,726
  • 4
  • 27
  • 36
2
votes
2 answers

How to run SAS using batch if I do not have it locally

Is there a way to run SAS using batch if I don't have the sas.exe in my machine? My computer has the SAS EG but the code is ran on our companies servers Thanks
Daniel Pereira
  • 167
  • 3
  • 12
2
votes
1 answer

SAS Enterprise Guide - process dependence and parallel execution

I am working on a project in SAS EG (7.1) which involves process dependence and parallel execution, as depicted below: I have the following questions: Is there a way to retrieve or set relations (i.e. process_C --> program_D) between the processes…
kacperdominik
  • 194
  • 2
  • 10
2
votes
3 answers

can PC SAS be used to bypass SAS EG connection to Unix session?

We've migrated our data warehouse and we are being asked to use SAS EG to connect to a metadata server where all our libraries are. Is there a way to still use PC SAS to connect to those libraries ? If so, any hints on how to do this ? I prefer…
Crna Krv
  • 127
  • 2
  • 11
2
votes
2 answers

SAS stored process to a web service link

I have created a SAS stored process and I need to attach it to a web service link which I intend to use it as an input in a python program . I would really appreciate if I could get help in creating a web service from a SAS stored process . Thank…
jinsi
  • 123
  • 9
2
votes
2 answers

How do you stop an input/output table from loading and return to the process flow in SAS EG?

SAS can take a very long time to load an output table after you click on it from the process flow, is there a way to cancel it? I've wasted hours waiting for tables to load, I am hoping there is a way to exit the "Input Data" or "Output Data" tabs…
heyydrien
  • 971
  • 1
  • 11
  • 28
2
votes
2 answers

code for order list in SAS / schedule order list

I use SAS EG, and am trying to schedule some daily work. is there a way to schedule a order list instead of scheduling the whole process flow? if not, I looking for a code that can execute order list, so that I can only schedule on that…
Zhefu Chen
  • 21
  • 2
2
votes
2 answers

sas insert table into html email

Is it possible to loop through the records of a table to populate an html email without repeating the beginning and the end of the email? With this example I get a mail with 5 tables of 1 row (because WORK.MyEmailTable is table of 5 records and set…
stallingOne
  • 3,633
  • 3
  • 41
  • 63
2
votes
1 answer

Adding percent % to the proc tabulate report

I have a proc tabulate code as below: proc tabulate data=want; class TERM CAMPUS GENDER ; var count ; table GENDER ALL, (CAMPUS all)*TERM*(count='#Enrl '*f=best8.*sum=' ' count=''*colpctsum='% Tot Enrl ' ) / rts=20; run; and my result is as…
beren
  • 39
  • 4
2
votes
3 answers

Get list of files in directory under NOXCMD

Can not use Xcommands in SAS EG. No access to SAS Management Console. How can I get a list of files in a directory without using Xcommands? Tried DINFO but can only get 1 piece of info. Need a list of all files in the selected directory. Am I…
Chris
  • 151
  • 3
2
votes
2 answers

Split a row into multiple rows in SAS enterprise guide

I need help to split a row into multiple rows when the value on the row is something like 1-5. The reason is that I need to count 1-5 to become 5, and not 1, as it is when it count on one row. I've a ID, the value and where it belong. As exempel:…
user1770961
  • 101
  • 2
  • 2
  • 9
1 2 3
…
27 28