About SurajChand

Ksharp

data have; Table_Names="cas-shared-default datascientst _[ 0680 ] تقرير عدد البلاغات بناء على الشخص unloaded"; Server_Name=scan(Table_Names, 1, ' '); CASLIB_Name=scan(Table_Names, 2, ' '); call scan(Table_Names,3,p1,l1,' '); call scan(Table_Names,-1,p2,l2,' '); Table_Name=substr(Table_Names,p1,p2-p1); Table_State=scan(Table_Names,-1, ' '); drop p1 p2 l1 l2; run;

Patrick · ‎10-17-2019

I've used more recent EG versions on Citrix so it's not an EG limitation.

rkbright · ‎09-29-2017

Hi Rean - I have the same setup and I set the permissions in the directory structure, the smb.conf file and in the sasenv_local file. I configured it so everyone within an active directory group can read and write to a directory/sub directory or file without a permissions error. I support a user-base where they primarily work in teams and this configuration has generally worked well. 1. create physical folder structure and add permission bits (this is the folder people will use to share/read/write data) # sudo mkdir /mnt/shareFolder # chown -R owner.primaryGroup /mnt/ShareFolder # chmod -R 2775 /mnt/ShareFolder * this adds the permission bits to all sub-directories and folders --> drwxrwsr-x 2. create share folder and add permissions to /etc/samba/smb.conf file [Folder Name] comment = Folder Name path = /path/to/physical/folder/location browseable = yes write = yes read only = no valid users = @group1, @group2, etc... write list = @group1, @group2, etc... create mask = 0775 force create mode = 775 create directory mask = 0775 force directory mode = 775 force group = @group * this sets the permissions when a user creates and interacts with files via a Windows Explorer window 3. update /opt/sas/SASHome/SASFoundation/9.4/bin/sasenv_local add umask 002 * this sets the permissions for when a user writes to a shared folder location from SAS All Done!! Let me know how it goes if you have not already found a solution. Richard

Anand_V · ‎05-03-2017

Any entity that is not defined in Metadata when trying to connect is treated as PUBLIC and by default PUBLIC Access is denied to Metadata. Could you manually add the user identity of the host to Metadata and try? Thanks, Anand!

SurajChand · ‎02-24-2017

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.

SurajChand · ‎02-21-2017

Hi MG18, it seems that client machine is unable to validate the apptest (domain name) with the IP address of the SAS server. make sure you have configured the DNS to resolve the domain name to IP address and vice-versa OR place the hosts entries to redirect the request directly. In windows:- open hosts file with editor with administrative rights. Host Entries path : C:\Windows\System32\drivers\etc\hosts 127.0.0.1 localhost xxx.xxx.xxx.xx apptest. save and exit. then try to connect the same once again. ** if you have multiple tier SAS server then place all 3 (Meta, Compute, Mid-tier) host entries to resolve the issue. make sure all SAS services/server must be validated through SAS management console.

Kurt_Bremser · ‎01-26-2017

@sewa_bal_gmail_com wrote: I will not share these confidentials details. Please let me know the steps so that I can fix this issue. In that case, SAS technical support is your only option.

SurajChand · ‎01-25-2017

Hi Doriana, I would suggest you login with your sasmc and right click on your desire folder the click on export sas package and do the same process with different location or sasmc by clicking on import sas packages.

SurajChand · ‎01-25-2017

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

SurajChand · ‎06-06-2016

Hi, Could you please share the status of below command from sas or sas installaer user. /configuration-directory/Lev1 ./sas.servers status Which user you are tying to connect with SAS Management console? If you are able to login with sasadm@saspw user then there are some other problems. If not then you didn't configured the application successfully.

SurajChand · ‎10-06-2015

If you want to use your active directory authentication with SAS server you need to do these things on your Linux platform. 1. Firstly you have to join your domain (service provider) example.com visit this URL to join your linux machine into active directory https://www.youtube.com/watch?v=qwxinaUZycY See after doing all these things are you able to login with your domain user. 2. check LDAP, Kerbrose & 389 port is enable with filewall on AD server. 3. Open & terminal & edit the sasv9_usermod.cfg file with your domain information. cd Lev1/SASMeta/MetadataServer vim sasv9_usermod.cfg /* Set environment variables for binding to Active Directory. */ -set AD_HOST example.com -set AD_PORT 389 /* Specify the authentication provider. */ -AUTHPD (ADIR: example.com) /* OPTIONAL: Specify the domain name of the primary authentication provider. */ -PRIMPD example.com save & exit the file. restart your metadata & object spawner services. Open SAS Enterprise Guide & Run macros code for check authentication are readble or not. If your are able to see your domain user it's mean your authentication is working perfectly. 4. Now you need to resgistered this code with SAS store process. open SAS Management console use sasadm@saspw user. go to folder tab select SAS folder right click on folder then select new & new store process define any name (Active Directory Users) then Next select SASAPP at application server then click on store code in metadata and edit the source code Paste here AD-1 code then select stream then Next & finish. do same thing for AD-2 as previous (AD-1) 5. open your broswer & login with localhost:7980/SASStoredProcess/do login with sasadm@saspw & select list avilable option now expand the folder you will see here AD-1 option select it & try to import the users in SASMC. 6. If successfully imported then see in SASMC & try to login with domain credential.

Online Status	Offline
Date Last Visited	‎06-05-2024 08:26 AM

Re: Scan statement

Re: Scan statement

Scan statement

Re: Not able to login to SAS EG for OS Users

Re: SAS ODBC to SQL Server issues

Re: The application could not log on to the server. SAS 9.3

Re: How to start Environment Manager

Re: How to start Environment Manager

Re: How to start Environment Manager

Re: How to copy project from a folder to the other one in SAS MC

Re: Downgrade the saved EG project from 7.1 to 4.3

Re: Downgrade the saved EG project from 7.1 to 4.3

Re: SAS VA Importing Data Doubts

How to integrate the Active Directory with SAS server

Re: How to integrate the Active Directory with SAS server

Re: Scan statement

Re: Downgrade the saved EG project from 7.1 to 4.3

Re: SAS Permissions with Windows and Unix

Re: Not able to login to SAS EG for OS Users

Re: SAS ODBC to SQL Server issues

Re: The application could not log on to the server. SAS 9.3

Re: How to start Environment Manager

Re: How to copy project from a folder to the other one in SAS MC

Re: Scheduling a SAS job to execute after every 5 min

Re: 9.4 server not running - How to start?

Re: How to integrate the Active Directory with SAS server