Hi All,    I am using SAS IDP for vieving the report which are created using SAS WRS and when i am trying to open it it showing by default value . How to restore the default value in SAS IDP for particular report.   ... View more

HI all,   I have table in Oracle whihc is haiving 120 crore records and i want to create Full extract in DB2 table and In our SAS job it takes 4/4.5 hours to load 4-5 crore records when it is running in LSF/schedular. Kindly suggest the fastest mode by which the data can be imported to DB2. we have SAS DI studio, datafluxstudio, SAS EG amd using SAS 9.3 .     ... View more

HI All,   One of our job is failing due to communication error,please guide how to reslove it.   [sas@computeprod Logs]$ grep "ERROR:" ccc_FLOW_NEW_02_07_xx_2017.07.28_09.56.34.log ERROR: CLI execute error: [IBM][CLI Driver] CLI0106E  Connection is closed. SQLSTATE=08003 ERROR: CLI close cursor error: [IBM][CLI Driver] CLI0108E  Communication link failure. SQLSTATE=40003 ERROR: CLI close cursor error: [IBM][CLI Driver] SQL30081N  A communication error has been detected. Communication protocol being ERROR: Errors printed on page 4.   we are connecting DB2 using cataloguing DB2 from appliction server and job code is shown in below :-   LIBNAME TAGTLIB DB2  Datasrc=database  SCHEMA=schema_name  AUTHDOMAIN="Xyz-auth" ; PROC SQL; CONNECT TO DB2 ( Datasrc=database AUTHDOMAIN="xyz_auth" ); EXECUTE ( DELETE FROM schema_name.DEPOSITSTABLE WHERE START_EOD_DATE=(SELECT MIN(START_EOD_DATE) FROM schema_name.DEPOSITSTABLE_INTER); )by DB2; disconnect from DB2; QUIT; LIBNAME TAGTLIB DB2  Datasrc=database  SCHEMA=schema_name  AUTHDOMAIN="xyz_auth" ; %MACRO DEPOSIT_ADHOC_RUN(); PROC SQL; INSERT INTO TAGTLIB.DEPOSITSTABLE (DBCOMMIT=4000000) SELECT * FROM TAGTLIB.DEPOSITSTABLE_INTER ; QUIT; %MEND; %DEPOSIT_ADHOC_RUN;   Please suggest soemthing what all possible reasons for failure and what all code are needed ? Many thanks in adavnce. ... 🙂     ... View more

Hi All ,   I have been working in SAS from last 1.5 year and i have workied in SAS DI, BI (EG , WRS,INFOMAP) and some part of SAS SMC also.   which certification I should do ? Please some guide on this . Thank you much in  Advance... 🙂    ... View more

We have scheduled One flow which run through LSF and one job in that flow which is running from last 8 hours. Usually it took only 1 hour but today it is taking more than 10 hours and this same job/flow has been running successfully from last 2 years and no changes has been made also.     i want to know where this job is runnig ? this there any to find out where sas di job is running  ?   SAS DI job consist only user wrriten code and in that it is taking data from source and updating it through sas code only.   O/s -LINUX    ... View more

Hi All,     I wnat to create report which will following functionality :-   if user A has logged in the all current filter should show A in value.  Currenlt i am taking filter value for one table and it is showing all distance vales along with A.   Is this possible in Stored process? How can i acheive this ??   ... View more

Hi All,   I have made some changes in SAS DI job but when i am running through BAtch server the old code is getting executed. How can i reslove this problem ?   ... View more

HI All,   I am trying to reploy one job but it is asking for userid and password. How do i resolve this problem.   Many thanks in advance. ... View more