@sasprofile,   For most deployments, you will perform configuration steps in this guide first. A checklist to help you verify your Hadoop environment is included, along with configuration steps for the following technologies: HADOOP procedure, FILENAME statement for Hadoop Access Method, SAS Scalable Performance Data (SPD) Engine, SAS/ACCESS Interface to Hadoop, SAS/ACCESS Interface to HAWQ (9.4M3), and SAS/ACCESS Interface to Impala. Also, information about vendor-specific Hadoop JAR files and SAS environment variables for Hadoop is included.   SAS 9.4 Hadoop Configuration Guide for Base SAS and SAS/ACCESS Fourth Edition (9.4M4)  SAS 9.4 Hadoop Configuration Guide for Base SAS and SAS/ACCESS Third Edition (9.4M3)   https://support.sas.com/en/documentation/third-party-software-reference/9-4/guides-papers-for-hadoop.html ... View more

@Rahul_SAS,   Integrated Windows Authentication (IWA) is a Microsoft technology that is used in an environment where users have Windows domain accounts. With IWA, the credentials (user name and password) are hashed before being sent across the network. The client browser proves its knowledge of the password through a cryptographic exchange with the web application server.   http://support.sas.com/documentation/cdl/en/bimtag/69826/HTML/default/viewer.htm#p1871e69gmwdr0n1o182krslc10p.htm ... View more

The PRESERVE_COL_NAMES= and PRESERVE_TAB_NAMES= LIBNAME options determine how SAS/ACCESS Interface to Oracle handles case sensitivity, spaces, and special characters. Please use both of them in LIBNAME. Also, I do not see that you have specified SCHEMA=. SCHEMA= specifies the name that is assigned to a logical classification of objects in a relational database.  ... View more

On UNIX you can do something like this:   find /path/to/folder/ -regextype posix-egrep -regex ".*\.(sas)$" 2> /dev/null | xargs grep -i 'keyword' ... View more

@MaryPet123,   Please add debug option to your filename ftp and rerun your program. Debug option writes to the SAS log informational messages that are sent to and received from the FTP server.   FILENAME Statement, FTP Access Method ... View more

@rieley,   Make sure the web browser is passing delegated credentials to the SAS Web Server. You should see a message in the SAS Logon log like this: ... INFO com.sas.svcs.security.authentication.gss.GSSCredentialCachingFilter - Received credentials for <USER_NAME>   If not, check the web browser settings. ... View more

@jwhite,   Please run this command and show me an output (do not forget to update the path to your configuration directory):   find /PATH/TO/SAS/CONFIG/ -regextype posix-egrep -regex ".*\.(cfg)$" 2> /dev/null | xargs grep -i 'logconfigloc' ... View more

@chenj,   I've sent you a new tracking number for the problem with SAS Web Server.   ... View more

@chenj,   Like I said on the track, you did everything right. Your middle-tier server might be underestimated, so I will move your track to the middle-tier support. ... View more

Maybe you need to use PROC PRINTTO in your SAS program? ... View more

@jwward65,   Like I said on a track, we had a conversation with Red Hat about your problem and they confirmed that a new IdM functionality in RHEL version 7.4 (which has been released less than two weeks ago) has the ability to authenticate users from multiple Active Directory domains using short names:   SSSD supports user and group lookups and authentication with short names in AD environments   Previously, the System Security Services Daemon (SSSD) supported user names without the domain component, also called short names, for user and group resolution and authentication only when the daemon was joined to a standalone domain. Now, you can use short names for these purposes in all SSSD domains in these environments:   On clients joined to Active Directory (AD) In Identity Management (IdM) deployments with a trust relationship to an AD forest The output format of all commands is always fully-qualified even when using short names. This feature is enabled by default after you set up a domain's resolution order list in one of the following ways (listed in order of preference):   Locally, by configuring the list using the domain_resolution_order option in the [sssd]section of the /etc/sssd/sssd.conf file By using an ID view https://access.redhat.com/documentation/en-US/Red_Hat_Enterprise_Linux/7/html/7.4_Release_Notes/new_features_authentication_and_interoperability.html ... View more