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

Conditionally skip transformations in SAS DIS

I am wondering if it is possible to use a Conditional Start transformation in SAS DIS to conditionally bypass another transformation based on whether a given table is empty (no rows). This link seems to indicate that the condition must be based on…
Rookatu
  • 1,487
  • 3
  • 21
  • 50
3
votes
1 answer

Does SAS have a macro to format output of user writen DI transformation?

When developing ETL programs with SAS Data Integration (DI) Studio, each transformation you specify has a neath user interface to specify the columns of the datasets(=tables) you create and their type, length and format. When the existing…
Dirk Horsten
  • 3,753
  • 4
  • 20
  • 37
3
votes
1 answer

What are ways to export data from tables in SAS DI?

I am very new to SAS and I have some tables in SAS DI under inventory which I need to export to text file, what are the easy to do this? Can I somehow create a program in SAS EG to display the data in there then export?
Mixer
  • 183
  • 2
  • 7
  • 15
2
votes
1 answer

How to change the data in a column in SAS Data Integration?

I have an existing ETL solution built-in SAS Data Integration, where one of the columns in initially set to have all null values. I want to populate that column with actual data. The original column in that table was set to receive numeric values…
Eyal Marom
  • 281
  • 4
  • 18
2
votes
1 answer

Which version of SAS is compatible with SAS Stored process version 2.0? Is it compatible from version 9?

SAS Stored process 2.0 is compatible with SAS 9.3, but wanted to know if it is compatible with all versions starting from SAS 9 to SAS 9.4?
Kary231
  • 21
  • 1
  • 2
2
votes
1 answer

In SAS Data Intergration, Create a user written transformation to skip further job execution without giving an error when certain condition is true

I want to create a user written transformation to skip further job execution when certain condition is true. I have tried the code %abort; %abort cancel; but these statements gives error, something like Stopped processing because…
mac_21
  • 113
  • 9
2
votes
2 answers

How to get the source code of Job

Sorry for the English language skills! SAS version 9.3 It is necessary to automate the process of obtaining the source code of Job. I know the way through deploy/redeploy, but it is not suitable for the creation of deploy metadata. Through…
Олег С
  • 123
  • 3
2
votes
2 answers

Dynamically register tables in SAS (DI)

Tables with transaction data are generated daily, with the date in the name e.g. data_01_12_2014. It is clear why this method would be undesirable, but presumably the reason is that the daily tables are enormous and this is a space management…
Rookatu
  • 1,487
  • 3
  • 21
  • 50
2
votes
1 answer

Warning at SAS Data Integration about length

I have a proc sql code, creating table as below: proc sql; create table aa as select distinct id, question, answers;from stg.bag ; quit; proc print data=work.aa; var id question answers; run; I have warning when I run this…
joys
  • 21
  • 5
2
votes
1 answer

How to publish a (csv, xlsx, etc) file from SAS DIS via email

So I have some SAS DIS jobs which create "kickout" data when run - by this I mean that if things run smoothly, none of the "kickout" data is generated, but it is known that there will be exceptions and I would like to have those exceptions put into…
Rookatu
  • 1,487
  • 3
  • 21
  • 50
2
votes
1 answer

Referencing job path and name in SAS DIS

In SAS DIS, I want to reference the job name in code. I know that the global variable etls_jobName contains this information, but when I assign this value to a field and view the output, I get '.'. Ultimately, I'd also like to be able to get the…
Rookatu
  • 1,487
  • 3
  • 21
  • 50
1
vote
2 answers

Why return string format for FINFO function in SAS EG and SAS DI is different

I am trying to get file "modeified" datetime with datetimeString = finfo(fid,'Last Modified');`` In SAS EG the return string looks like 12Jan2023:11:03:53 But in SAS DI the return string looks like 12 January 2023 11:03:28 I am trying to convert a…
Dvlpr
  • 13
  • 2
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
1 answer

Upsert into SQL Server from SAS

I've got several datasets which need to be upserted into a SQL server database from SAS (my environment uses SAS DI 4.9). The default table loader transformation that comes packaged with SAS DI offers an Update/Insert load style, with options to…
Rookatu
  • 1,487
  • 3
  • 21
  • 50
1
vote
0 answers

How do I create new transformation categories in SAS DI Studio?

In SAS DI Studio I create custom transformations from time to time. This is useful, but all custom transformations appear under the "Ungrouped" tab category within the transformation tree. This is unwieldy and it would be helpful if I could create…
Rookatu
  • 1,487
  • 3
  • 21
  • 50
1
2 3 4