I appreciate your statement, but I'm SAS Administrator and I found some example online so I tried. Please accept the apology!! ... View more

I want Table_Name column should have full table name instead of some portion Expected result _[ 0680 ] تقرير عدد البلاغات بناء على الشخص Current result _[ ... View more

Is SAS services configured with Linux? ... View more

Hi Lenvdb,   Here are few pre-requisites to get connected with DB through ODBC connection. For Linux platform :- 1. UnixODBC driver 2. SQL driver 3.odbc.ini 4. Operating system must be able to get connected with database.   1. Install the UnixODBC driver by following below url. in RHEL/CentOS/Fedora :- yum install unixODBC* -y (It will install default driver as per o/s releases) then you need to update it with letest versions.    https://linuxsasadmin.wordpress.com/2015/09/17/how-to-install-unixodbc-driver-in-linux-rhelcentosfedora/   2. Define odbc.ini file (Perform only 1st step) https://linuxsasadmin.wordpress.com/2015/09/21/how-to-connect-with-mysql-database-using-sas-enterprise-guide/   3. Operating system access:- isql -v dsn username password if you are get connected with database then you can test the same with base sas (in foundation by ./sas -nodms) or sas Enterprise guide.   Now open SAS Enterprise Guide & write this statement to validate the connection. libname Test odbc dsn=DSN user=sa pwd=xxxxxxx connection=global schema=dbo;   If it’s run without any error then you have made a connection successfully between SQL & SAS.   Final step is you need to create a odbc library from the sas management console as per your set enviornment. ... View more

Hi Ankit,   You can run or schedule the SAS jobs as per your requirements.   If you are using the Linux o/s then you can perform the same task by using crontab.   OR    if you are using the windows o/s then you can do the same by using windows task scheduler.   Best Regards Suraj ... View more

Hi Rean,   Setting the UMask value is the best way to get the solution with such issues but as much i knows UMask value should be 0022 for SAS.   Accoording to your statement it seems that you have configured the samba to share the location with windows operating system. you can set the permisson on that particular shared directory by using following command.   chmod -R 770 direcory name or mount point   For example :-  chmod -R 770 winshare (Where winshare is the mount point which can be access from windows operating system.)   All user should be in a group because others don't have the permission     Best regards Suraj ... View more