Dear Team, I am unable to unpublish the alert in SAS VI. Please guide me on how to unpublish the alert.   Thanks & Regards Shakti Sourav Mohapatra ... View more

Dear Team, We are unable to filter the data in SAS Data integration studio. It's showing SQLPLAN Internal ERROR.  I have attached a screenshot for your reference.    Thanks & Regards Shakti   ... View more

Dear Team, I am unable to create a network diagram as per my Alert and I want to see Licensee ID as a Licensee Code but I am getting '1234566774315mar2020'.  Please suggest, 1.  how to create a network Diagram ? 2. How to create a unique Licensee ID as a Licensee Code ? 3. How to Enable the Aggregation Scenario in flows ?   Please find the issues Screenshots.   Network Diagram Issues and  Licensee ID as a Licensee Code Screenshots : In this Image, I ma getting Licensee Code Like this but i want to see only code, and there is no network diagram showing. how to create it.   How to Enable the Aggregation Scenario in flows     Aggregation Scenario is disable, how to enable it .   Let ma know, If required any further details, Please suggest us urgently.   Thank You,  Shakti   ... View more

Dear Team,   I am getting 0 value in the target value if there is any job failed.  Is there any condition used that if the Source table is missing or not maximum year then it can't b truncate and loaded into the Target table? is there any Precode or Postcode available in Table Loader? ... View more

Dear Team, We are unable to open a particular job in SAS DI studio Production or live Environment, tried it to restore the job by back up file but it's not working in Production Env. also we had tried to export the job package and Import again for restore the ETL Job but we failed. Please suggest, what's the issue and how to resolve it asap. We are getting the job opening in few seconds and then after immediately closed automatics. If possible, can you share us the logs query or any path to find the issue ?   Thanks  Shakti ... View more

Dear Team,   I have created one di  job having data is 541 rows and used extracting and table_loader transformation for storing the data into target table which is in SQL Server. But now it's hanging in table loader and we are unable to find the error and solution. I have attached a screenshot for your reference.   Thank You Shakti Sourav ... View more

Dear Team,   How to change the language English to Odia in SAS VA. all the Labels, tooltip and Headings should in odia Language. I have preferred Global Preferences in Settings but I am unable to find the Odia Language in Region and language Options. Please suggest me to solve this problem.   Thanks Shakti ... View more

Hello team,   Please Suggest is there any Phonetic group node for Match codes in Data Management Studio?? ... View more

Dear Team, I have created a data job which is under process job to identifying duplicate records. I want to validate the data rows flag wise means which batch rows matched with Golden Flag.   I have attached screenshots for your references.   My data is like this,     Note:  I have tried by Cluster Number, I want it like if cluster number count is repeated or having count >1.   Ex: Want data: ID          Name    Marks     Flag              Matchcode     Cluster Number  Cond_1 10 SHAKTI 68 GOLDEN 423~$$$$$$$$$$$$$$$$ 2 True 3 SHAKTI 33 BATCH 423~$$$$$$$$$$$$$$$$ 2 True 9 RAJESH 43 GOLDEN YF42$$$$$$$$$$$$$$$$ 4 True 5 RAJESH 6 BATCH YF42$$$$$$$$$$$$$$$$ 4 True 6 AMIT 77 GOLDEN &B~$$$$$$$$$$$$$$$$$ 5 True 7 AMIT 45 BATCH &B~$$$$$$$$$$$$$$$$$ 5 True   want only Batch flag which is False, and if batch flag is true then will come similar duplicate data from Golden Flag.   Please let me know if required any further details     Thank You  Shakti   ... View more

Hi Team,   Cluster Node taking lots of time to merging the output. I have attached screenshot for your references and please suggest how to develop the performance in Cluster node ??     Let me know if required any further details.   Thank You Shakti   ... View more

Dear Team, I want to compare two dataset. I have mentioned below by Example, Data 1: (Age_1 = Age - 5, Age_2= Age +5 ) NAME. AGE. Age_1. Age_2 ABC 25. 20. 30 Xyz. 20. 15. 25 Data 2: Name. Age. ABC. 27 XYZ. 22 Problem: If data2.Age value is between the data1.age_1 and data1.age_2. then one flag will create. Otherwise flag 0. Like this condition I am unable to do. Please suggest how to do this type of problem ? ... View more

Dear Team,  I am facing one challenge that I have to find out duplicate records based on Age variable. Age variable should be in one particular range.   Sample:  If beneficiaries's age is 29 and he/she trying to apply further by the different age like 25 or 34. I just want to de duplicate the data in Data Management Studio by the Age +5 largest and -5 smallest.  My Question is : How to Declare de duplication based on Age ? 2. Is it possible to take Age in Match codes ?if yes, then which definition and sensitivity  suitable ? 3. how to define Age like +5 and -5 ? 3.  ... View more