Hi all ,   We have been facing the following connection errors for more than a month now. Every day the errors pop up regularly during working hours hampering the execution of SAS jobs and some job are also failing due to this.     How to fix this kind of issues? please guide .many thanks in advances . ... View more

hi all,    i need to add report in SAS IDP portal what all step i need to follow ? in addition to this i need to remove the existing report also from the same portal how to do it ? screenshot attached.     But in existing structure is shown above and there is no option as edit content . ... View more

LIBNAME TAGETLIB DB2 Datasrc=ABDlive SCHEMA=SASDB  AUTHDOMAIN="SASDB_AUTH" ;   data source_rep_data; set tagetlib.src_cons_cibil_table_postval; /*if datepart(report_date) = '30APR2015'd;*/ run; PROC SORT data=source_rep_data out=src_temp; BY account_id int_account_id ownership_indicator; RUN; PROC SORT data=sascibil.cibil_consumer_name_add out=modif_temp; BY account_id int_account_id ownership_indicator; RUN;     DATA whole_dat_after_format1; MERGE src_temp (in=a) modif_temp(in=b); BY account_id int_account_id ownership_indicator; IF a=1 ; RUN;     I am running above mentioned code and in log it is written below message :- WARNING: Multiple lengths were specified for the BY variable ACCOUNT_ID by input data sets. This may cause unexpected results. WARNING: Multiple lengths were specified for the BY variable INT_ACCOUNT_ID by input data sets. This may cause unexpected results. NOTE: MERGE statement has more than one data set with repeats of BY values. NOTE: There were 1308561 observations read from the data set WORK.SRC_TEMP. NOTE: There were 2907358 observations read from the data set WORK.MODIF_TEMP. NOTE: The data set WORK.WHOLE_DAT_AFTER_FORMAT1 has 2907358 observations and 166 variables. even though i have written  if and in statement why it is showing "NOTE: MERGE statement has more than one data set with repeats of BY values." ?   and SRC_TEMP has 13 lakh record with above code should return the same but in actual it is returning 29 lakhs record why it is so ? it is due to warning ?? Please help in above code to understand and tell me y it is returning 29 lakhs record not the 13 lakhs records.        ... View more

  hi all,    I want to know how many user are logged in to SAS IDP portal ? is there any way to find out same using SAS SMC ? O/s env:- Linux  SAS version :- 9.3   ... View more

Hi All,     we have Two different environment in our system and one is production and another is test env (it is not having most of SAS object ). Case is test environment is not synced with production env. i want to sync up the same and what is the best way to do it? Please suggest all possible ways to do it and i have tried do it using  Export and import activity but it is not exporting in one go.   ... View more

Hi all,   i have one requirement in which i have created 4 stored process and mapped all 4 stored process in single report. but problem is  first stored process has a filter prompt and same value should be coming to other 3 stored process and should filter data on same prompt value. How to achieve this  ?   Many thanks in advance.  ... View more