Hi, I have a table with huge volume of data (approx 500 million records) and I am using SQL Join transformation ( and doing aggregate functions, group by and having in clause). I have also created Index(on the columns that are used in the having clause) on the output table( by right clicking on the temporary output table).  But it is taking ages to exeute. Can someone help me here.    Thanks  ... View more

Hi All, I have about some 9 SAS datasets ( creating new datasets) and loading into a final SAS Dataset. (I know the process for this)  We run this SAS code periodically to load data into final SAS dataset (we do this in SAS DI)  Now, I want to load data by appending into existing final SAS Dataset (not to overwrite on existing records).  All this will be an user written transformation in SAS DI. Please suggest me the best way, TIA. ... View more

Hi, How do I read the data from a damaged SAS dataset. In what instances SAS dataset gets damaged ? Please help me here.  TIA.. ... View more

Hi, Reg. SAS ECM queries, which board is appropriate. Thanks ... View more

Hi all, I am working on SAS ECM. I wanted  to add values in ECM UI page. When I open the SMR, I can see tabs below SMR. (like, SMR details, Part A, PArt B ....SMR History) Now, I want to add a drop down value in the SMR status. and in the Notes tab, I wanted to make some changes. Can anyone help me with this. And also how the ECM feilds are customised and how the value is appeared.   Thanks in advance!!     ... View more

Hi All, I have a SAS Data set with BATCH_NO, SNAPST_DT and TABLE_NM variables and some values. I have a .sas file. Upon executing this .sas file it creates some values to the environment variables. Now, I want to insert those values into the SAS dataset. Please suggest me how can I do that.  I found a way of updating the SAS data set update by using the below code: proc sql;   update Lib1.A_batch_table_met_one     set No_Of_Records=input(sysget('NEW_TABLE_ROW_VAL'),best.)     where Batch_No=input(sysget('BATCH_NO'),best.)     AND Table_Name=sysget('TABLE_NM') ;  quit; ... View more

Hi all, I am using SAS DI user written transformation and I have the following doubts. Please suggest to gain some knowledge. I am using an existing user written transformation.  In that transformation, in the existing Data step block I am manually writing a code and creating one new column X.  That column loads the data into the next level crated table ABC. what all steps I need to run in terms of executing it successfully. 1. In the mapping section, do I need to right click --> and create a new column X.  2. Map it to the ABC column manually as X is an existing column already.   I am very much interested in this topic here. Please help me in understanding if it is correct way of dealing while creating a new column.  ... View more