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

User-written code to create macro, how to debug

In SAS DI studio I'm attempting to create a macro, and assign a value to it with a user written code transformation. How do I print the value of this macro to test if my code does what I want it to do. I need a macro that takes a value based on the…
Rob Wanders
  • 3
  • 1
0
votes
1 answer

Should I skip SAS DI Studio?

I work in an organization where we for many years have been planning to start using SAS DI Server/DIStudio. Now we are just a few months away from starting to use the product. It's a huge investment. The license cost is just a minor part. Training…
user3861948
  • 3
  • 1
0
votes
0 answers

SAS Data Integration issue with empty string showing as "NULL"

I am having an issue with SAS DI. In certain columns, I would like the empty strings to appear as empty, instead of them being displayed as "NULL". While they some times appear as empty, once I later run them in SQL, they come up as "NULL". I have…
Andreas Antoniou
  • 1
  • 1
0
votes
0 answers

Finding Multiple file type with date restriction linux

I use SAS Grid and I'm trying to set up a process which looks for files older than 180 days. I need to locate both .sas7bdat and .sas7bndx files. The results are output to a .txt file for manipulation in SASDI I have been able to locate each file…
Jordan Wood
  • 1
  • 1
0
votes
1 answer

Partition a table in teradata using SAS DI studio 4.902

For ETL operations we use SAS DI studio and then finally the tables are loaded in Teradata. DDL is dynamically generated in SAS DI Studio for the tables created. But when we want to customize the DDL to include partitions it throws an error. Can…
Abasesha
  • 41
  • 7
0
votes
1 answer

Select row with datediff 1 and latest timestamp

Sorry, there might be a really simple solution to this but I am new to SQL and SAS data integration studio. The code is in "proc SQL" in SAS-language. I am trying to create a job in SAS DI and I am having trouble removing rows that are wrong. This…
n00b
  • 3
  • 4
0
votes
1 answer

Error when running cast statement on SAS DI

I'm currently trying to automate through SAS DI a piece of code that I've written in SAS EG. While it runs without any issue in SAS EG, DI is returning an error on a SQL statement that is executed on my Teradata server. the error is the…
user3096300
  • 1
  • 2
0
votes
2 answers

SAS DI LAG1 alternative?

Trying to use the LAG function in SAS to replicate a piece of code in a migration into SAS DI, however there doesn't seem to be the same function in SAS DI at all. Using SAS DI 4.21 currently, with a view to move up to 4.9 soon. So my question is,…
EkulSregor
  • 1
  • 1
0
votes
0 answers

SAS DI Stop job if dataset is populated

I'm quite new to SAS and really can't get my head around it's code, so asking here for help. I've a job that is reading an external csv file, and have a macro created by a colleague that validates the data in this external file and prints out error…
titan31
  • 185
  • 4
  • 17
0
votes
1 answer

Improvement on %NRQUOTE 'removal'

I have the following piece of code that works, but I'd like to know if anyone can come up with a better way of 'removing' the %nrquote. I have had to add a %SUBSTR function, which works, but I'm keen to know if there are any other suggestions, and…
mjsqu
  • 5,151
  • 1
  • 17
  • 21
0
votes
2 answers

Best order of joins and append for performance

I'm having huge performance issues with a SAS DI job that I need to get up and running. Therefore I'm looking for clever ways to optimize the job. One thing in particular that I thought of is that I should perhaps permute the order of some joins and…
Rookatu
  • 1,487
  • 3
  • 21
  • 50
0
votes
1 answer

sas DI JOBS troubleshoot and Monitor in unix

If sas is installed on windows os then How to troubleshoot or catch its performance of sas DI jobs on unix? using any tools or commands or By using nmon? Thank you...
Vishal
  • 1
  • 2
0
votes
2 answers

Getting File Name in a variable

I am using sas DI studio and I am trying to get a date value written within the name of the input file,to put the same date also in the output file name. So first I need to get the filename and the extract the date and then put the date back.…
Aritra Basu
  • 43
  • 1
  • 8
0
votes
1 answer

kickout process to publish tables in SAS DIS

I have a job which does some matching but may produce duplicates. When this happens, I want the job to create a table containing these duplicates and send an email with the data. Putting aside the conditionality for the moment (on whether duplicates…
Rookatu
  • 1,487
  • 3
  • 21
  • 50
0
votes
0 answers

Append contains more rows than constituent tables

I've got 4 tables (in SAS DIS 4.9) with the following numbers of rows respectively: A - 38 rows B - 13 rows C - 4575 rows D - 22 601 rows Each table has the same set of columns with the same formats, as…
Rookatu
  • 1,487
  • 3
  • 21
  • 50
1 2
3
4