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
2 answers

Cannot create output with user generated code in SAS DIS

I'm trying to do some manipulations on a csv file which I've read in to the Job Editor Window using the standard file reader. In order to do so, I connect the file reader to the input node of a User Generated Code transformation, and then follow the…
Rookatu
  • 1,487
  • 3
  • 21
  • 50
0
votes
1 answer

Read large tables from Teradata into SAS via DI Studio for further processing

I am creating a ETL job in SAS DI Studio to read Teradata table into SAS, then to apply user written code on top of it and then load the SAS work table into Teradata again using Teradata Table Loader. What is the best way to read the large teradata…
Harshad Patil
  • 313
  • 1
  • 3
  • 13
0
votes
2 answers

SAS DI (Data Integration): Inserting a Data in an existing Table

I have a program in SAS 9.3 (please refer below) that I need to do in SAS Data Integration Studio: %macro sqlloop; Proc SQL; Select distinct(DATE) into :raw_date from RAW; Quit; %DO k= %sysevalf("&raw_date"d) %TO …
1 2 3
4