Hi The DIS Code is given below , I am creating an ID with minimum date and Account id, so unable to execute the minimum date expression in DIS in a extract transformation, however the code works in SAS EG. Thanks heaps Channa proc sql; create table work.Subsequent_Quotes_0 as select Account_ID, (intnx('Month',(Datepart(_Period_Create_Time)),0,'E')) as Period_Created_Month length = 8 format = DATETIME22.3 informat = DATETIME22.3 label = 'Period Created Month', (catx("_",(min(intnx('Month',(Datepart(Period_Create_Time)),0,'E')) ),Account_Number)) as Account_Policy_ID length = 8 label = 'Account Policy ID', Period_Create_Time, Job_Type from &SYSLAST group by Account_ID, ; quit;
... View more