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

Hi PG   I am creating DIS reporting job, in the process I have to select the minimum effective date (month)  group by account ids  (and creating a unique Id with the effective month and  Account ID). So I created this in SAS EG and all worked fine, however when I re created this step in DIS the error was given and couldn't go beyond. Attached a screenshots of  the Extract Mapping hope this will help. Thanks heaps Channa   ... View more