Stack Overflow
Stack Overflow

Questions tagged [sas-dis]

SAS DI Studio, or SAS Data Integration Studio, is a SAS tool for performing ETL and other tasks integrating multiple different types of data (from Hadoop, Teradata, Cloudera, and other sources) alongside SAS data along with allowing programming tasks.

SAS DI Studio, or SAS Data Integration Studio, is a SAS tool for performing ETL and other tasks integrating multiple different types of data (from Hadoop, Teradata, Cloudera, and other sources) alongside SAS data along with allowing programming tasks.

See http://support.sas.com/software/products/etls/ for more information.

48 questions
1
vote
2 answers

Using SAS SET statement with numbered macro variables

I'm trying to create a custom transformation within SAS DI Studio to do some complicated processing which I will want to reuse often. In order to achieve this, as a first step, I am trying to replicate the functionality of a simple APPEND…
Rookatu
  • 1,487
  • 3
  • 21
  • 50
1
vote
0 answers

Retrieving login information based on AuthenticationDomain from the SAS Metadata Server failed

I am getting issue in SAS while executing the SAS job , getting error "Retrieving login information based on AuthenticationDomain from the SAS Metadata Server failed" My tables are in teradata server. please guide me. Here I'm posting some piece of…
user7709965
  • 11
  • 2
1
vote
1 answer

How can I schedule a stored process in SAS DI Studio?

I would like to use Enterprise Guide as a development environment for creating a SAS job (Base SAS code only), but I then need to use DI Studio to schedule that job to run at a particular time. I want to use EG for developing the job because I…
jl6
  • 6,110
  • 7
  • 35
  • 65
1
vote
1 answer

Removing quotes and spaces in SAS dataset

I am working in SAS EG and DI, facing a very peculiar problem. When I look into a column of a dataset in SAS DI Studio or EG, it is appearing fine. But when I paste the data into notepad, some quotes and spaces are appearing. The data which I am…
Karthaveeryarjun Vinjamoori
  • 473
  • 2
  • 12
1
vote
1 answer

SAS out of memory error

I'm getting a "The remote Process is out of memory" in SAS DIS (Data Integration Studio): Since it is possible that my approach is wrong, I'll explain the problem I'm working on and the solution I've decided on: I have a large list of customer…
Rookatu
  • 1,487
  • 3
  • 21
  • 50
1
vote
1 answer

SAS SPDS table primary constraint unable to add

I am trying to add primary constraint on a SAS SPDS table. Error i am receivig is - 1. ERROR: Engine SASSPDS does not support integrity constraint operations 2. ERROR: Requested function is not supported. I am unable to proceed. Query i have used -…
Akshat Jain
  • 11
  • 1
1
vote
1 answer

Check if a SAS DIS parameter is null

In SAS DIS I have set date parameters on a job. I tried setting the default values using the drop down menu provided, but each time I get the error Syntax error, expecting one of the following: !, !!, &, *, **, +, -, /, <, <=, <>, =, >, ><, >=,…
Rookatu
  • 1,487
  • 3
  • 21
  • 50
1
vote
2 answers

SAS Data integration Studio 4.6 empty data set

In a job when it reads an empty data set I want it not to abort the job with an error, but to move on to the next scheduled job. Any suggestions on how this can be done?
Daphne
  • 29
  • 3
1
vote
1 answer

Creating a user defined transformation in SAS DIS to produce work table

I have code which produces some job specific variables in SAS DIS, and rather than having to copy this code into a User written code block for every job I write, I would like to have a predefined transformation to do this which I would drag from the…
Rookatu
  • 1,487
  • 3
  • 21
  • 50
1
vote
1 answer

How to make a SAS DIS job loop over rows of a parameter table

I have a SAS DIS job which extracts and processes some timestamped data. The nature of the job is such that the data must be processed a bit at a time, month by month. I can use a time filter to ensure any given run is within the required timeframe,…
Rookatu
  • 1,487
  • 3
  • 21
  • 50
1
vote
1 answer

DI studio: SAS attempting to remote signon to local for transformations

Whenever I use a transformation directly on an oracle table in DI studio, the transformation is auto-generating a piece of code as below: (remote sign-on to local) Options comamid =tcp %let local= 7551; Data _null_; Signon local…
subin alex
  • 149
  • 2
  • 9
0
votes
1 answer

I am trying to modify and make permanent changes in the SAS data set, but I am not able to do so

I want to make permanent changes is the variable name Fclass and label Date as Departure date. i have used the modify statement along with rename but I am getting error when I am running the program. proc datasets library= ia; modify…
Abhishek Sharma
  • 1
  • 1
0
votes
0 answers

External files in SAS DI

*I am facing one concern when I executed Job in SAS DI to populate records in .dsv file then I am getting columns headers in multiple line instead in a single line, after column 257 external file is breaking the column values in next line so please…
harrysec726
  • 1
  • 1
0
votes
1 answer

Translating a SQL update to SAS DI

Assume we have a table P_DEF in which we want to update the value of column RUN_ID for a certain subset which we stored in another table TMP. Here how I would do it in SQL: update P_DEF set RUN_ID = (-1) * TMP.RUN_ID /* change the sign of the value…
B--rian
  • 5,578
  • 10
  • 38
  • 89
0
votes
0 answers

Can't convert varchar into date using sas data integation studio

I am new using sas data Integartion Studio 4.9005. i am using database oracle 18. the scenario is i move from table_A with data type varchar(100) to table_B with date data type. the format from table_A is YYYY/MM/DD but the result is give me…
yan
  • 37
  • 4
1
2
3 4