Hi All, we are working on a requirement to generate an excel file in batch mode  and then set the security information classification for that excel file . Although first part is quite an easy task but I am not getting any way out to handle the second stuff i.e. to set the security of information classification via SAS code . WIth classification I mean the internal classification available in Microsoft office , like confidential, internal etc. If any one have an idea about it please share. it will be a great help.  Regards, Manny ... View more

Hi All,    I am trying to do a stand alone installation of SAS AMO 7.1 . While installation reach step of installing SAS/GRAPH ActiveX control it gives an error of No language resource available .  on Deployment screen it struck at SAS/GRAPH ActiveX Control (64-bit, English). I am attaching a screen shot with this post for additional reference.  Additional information. Using Microsoft office(2016)  64 bit version . Please reply if anyone has faced this issue in past or can guide me on this. Regards, Manny ... View more

Hi all,   We are upgrading from SAS 9.4 M3 to M4.     In M3 we have  Latin9 (SAS_en) as encoding . Now when we have upgraded we changed the encoding as UTF-8.    Issues: 1. The Sas codes containing special character are not appearing correctly , whereas the Data in the table (ODBC, pre assigned library ) are appearing proper.   To overcome this if we change the session encoding of Upgraded (M4) version to Latin 9, then the Issue is :   The Sas codes containing special character are  appearing correctly , whereas the Data in the table (ODBC, pre assigned library) are not appearing proper.    Please guide  if any one has faced this issue ...   Regards, Manny ... View more

Hi,  I am willing to create a Dashboard in which I need to capture the Job running status of Batch Jobs?   In our setup we have IBM process Manager to check the flow, but I am not sure if we can read its back end data in a table format. Please guide..   Regards, Manny. ... View more

Hi,  I am trying to make a batch job to download data from DB2.I execute a loop in the job which download the  If using the batch user credential I try to download data in a SAS E.G session, it gives the desired output but  with a warning message as below: During read: [IBM][System i Access ODBC Driver]Column 11: CWB0111 - A buffer passed to a system call is too small to hold return data : [IBM][System i Access ODBC Driver]Column 11: CWB0111 - A buffer passed to a system call is too small to hold return data : [IBM][System i Access ODBC Driver]String data right truncation. : [IBM][System i Access ODBC Driver]Column 11: CWB0111 - A buffer passed to a system call is too small to hold return data : [IBM][System i Access ODBC Driver]Column   If I schedule it through MC and then check the flow Manager , it exit with reason code 127 and without any error, but inside the loop it execute only once and then it create a sas data set with .lck extension.. nothing else   Please help if anyone has faced this issue earlier.   Regards, Manny       ... View more