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
1
vote
1 answer

SAS EG image in footnote

i would like to insert an image in the footnote. What command should i use ? For example , my image file is locate at "C:\Image\img_footnote.jpg". thanks. sreenshot image link(not enough reputation to post an image here)…
gensius
  • 243
  • 1
  • 2
  • 7
1
vote
1 answer

Is there a way to apply SAS EG processes to new files?

I'm taking over a project from a coworker that involves several extensive SAS process flows. I have all the files with all the same names and a copy of the process flows they used. Since the file paths in their processes are direct references to…
Meg Ortiz
  • 11
  • 1
1
vote
1 answer

Write multiple SAS datasets into one Excel sheet

I am using SAS enterprise guide 7.15. I want to export several datasets into multiple excel sheets (multiple tables in every sheet). I'm using ODS and even though i'm setting sheet_interval="none", after two tables it breaks the page, and shoves the…
Mashdool
  • 13
  • 4
1
vote
2 answers

SQL error using INSERT INTO to build a table

I'm trying to put together a table in SAS Enterprise Guide using INSERT INTO using online tutorials but keep getting errors when I do the same thing as the tutorial. What could be going wrong? My code: /* Create the table */ CREATE TABLE…
KD97
  • 35
  • 4
1
vote
1 answer

How to calulate a cumulative sum for each observation by id

My problem is about calculating the cumulative sum for each id and for each date taking into account a sliding period of 15 previous days. If the cumulative sum exceeds 10k, the variable top is incremented. The treatment is done for Juen only. Here…
ZBS
  • 11
  • 1
1
vote
2 answers

SAS EG - Individual Datasets split by date vs Single appended dataset containing all dates

This is mainly a question about efficiency, as I'm unfamiliar with how SAS processes datasets. A lot of code that I run reads from multiple datasets with consecutive dates (whether this is consecutive months/quarters/years depends on the…
Chickenpet
  • 17
  • 3
1
vote
3 answers

SAS Enterprise Guide – Split/Stack Columns

I'm currently using SAS Enterprise Guide for one of my assignments and I'm trying to alter my current table to a desired table such as this one. I've already used the split/stack column task, but I'm not sure which variable(s) I should put in…
smoothiegirl97
  • 19
  • 1
  • 5
1
vote
2 answers

How to maually input data in SAS EG

Just started learning SAS and am going through a textbook where a table is created using the following code. Data travel; input City $ 1-9 Nights 11 LandCost 13-16 NumberOfEvents 18 EventDescription $ 20-36 TourGuide $ 38-45 …
Serge Kashlik
  • 361
  • 4
  • 16
1
vote
1 answer

How to call a prompt that selects a date range when I create a table using proc sql?

I would like to ask how to call a prompt (I am using SAS Enterprise Guide) in a proc sql that creates a table. I am interested in associate a number to date month (as in the table below) where d_month can be selected by using the prompt.…
still_learning
  • 776
  • 9
  • 32
1
vote
1 answer

Running Things in Parallel with SAS Enterprise Guide

Good afternoon, Stack Overflow gods and goddesses. I have a question about running code in SAS Enterprise Guide 7.1 in parallel. Currently, I have 5 small PROC SQLs running in a project. The code runs fine, but it executes in series (IE: One at a…
A_Pirates_Favorite_Letter
  • 141
  • 1
  • 12
1
vote
2 answers

Split a column by values into new columns SQL

I'm trying to learn SAS and I want to split the different rows of a table into different columns, to group the data. Namely, Table Detailed Num Date Type Amount A1 6/12/2018 Merc 5 A2 7/3/2014 Merc 10 A2 6/5/2014 Merc 6 …
Mariana da Costa
  • 173
  • 2
  • 12
1
vote
1 answer

Is there a way to SFTP files from Linux directory to Windows within SAS Enterprise Guide?

I am trying to SFTP files from Linux to a Windows directory using SAS, but I keep running into errors. My code is: filename attn '//file.doc'; filename outfile sftp '//file.doc'; cd…
Mya Rogers
  • 23
  • 4
1
vote
1 answer

(1) Create a job flow, (2) copy-paste program sheets and (3) action of specific a specific program (sheet) - sas

I am quite new to SAS, and I am having a general question that I am interested in: This question englobes 3 small questions: Those are: How to create a job flow using SAS Code How to copy paste programs sheets (from a main file) and changing…
Carles
  • 2,731
  • 14
  • 25
1
vote
1 answer

SAS EG Editor Macro to perform an operation on each line in the selection

I am using the Editor Macros feature that is part of the SAS Enterprise Guide software. I have written a small macro to reformat a line by removing the comma at the end, and moving it to the front (with two indentations before it). I would like to…
Bilbottom
  • 725
  • 8
  • 12
1
vote
1 answer

Daily data not showing days with no data - need 0-dates for report also

I'm making a report data for SAS VA. Example from data: Date - Customers 01Mar2019 - 4 02Mar2019 - 5 03Mar2019 - 2 05Mar2019 - 9 So I got 0 customers on 04Mar2019. That day does not show in my report data as 0 because it's not in the original…
RR91
  • 11
  • 2
1 2 3
…
27 28