Hello <   I am facing one DB2 libname issue.   My libname getting assign perfectly while running on SAS EG or SAS DI Code editor . but when i scehdule our job and ran on SAS batch server (LSF platform process manager) it is giving issue.   Below is error Msg.   Libname db2_XYZ Datasrc=ABC Schema =XXX Authdomain=XXXXXX; ERROR: Error allocating CLI Environment. ERROR: Error in libname statement.   .. I am surprise that the same libname connecting on EG or DI. just givinng error while running on LSF.   Please help me on this. ... View more

Hello All,   Need your help.   I am facing one issue, I have one excel file with 2 sheets(tabs) in that , I am exporting data in first sheet and second sheet have formulas which is linked to first sheet. Now when i tried to import data from second sheet at that time i am not getting updated data, but when i attached that EXCEL file in mail it is giving correct updated data.   Could you someone please help me to get this resolve.   I tried one shortcut:-  after exporting data in firstsheet, i manually open excel go to second sheet and then data-refresh all   afetr that when i tried i am getting updated data, but this is not good for my code, i can not do refresh every time .     Thanks in advance. Ashwani Gupta ... View more

Hello All,   Some one please help me to get a correct code .   i want to send email with first error message from log if my job get failed , if job success then no email required.   I tried multiple ways but facing different - different issues.some times sends last error message, some time get first line of error but not taking second line if error string is more than one line and so on.   If anyone have clean code please share .   Thanks   ... View more