Hi Folks,   We are currently attempting to integrate Microsoft Sharepoint with our SAS 9.4 M6 version. We are seeking guidance on how to initiate this process and ensure that the connection works seamlessly. Could you please provide us with the correct documentation or any steps we need to follow to successfully integrate Microsoft Sharepoint with SAS 9.4 M6 version? Your assistance in this matter would be greatly appreciated. Thank you for your help.     Thanks, Hemanth MG  ... View more

Encryption is a process that transforms the data into an unreadable format using a secret key and is readable only to those who have the key to decrypt it. Encryption provides security to datasets written on disk. The SAS Viya platform supports encryption for data at rest on disk storage. The SAS Viya platform mainly uses two methods to encrypt data at rest. One, programmatically using the CASLIB and SAS data steps. Second, an encrypted disk storage class provided by the cloud vendors is used to define the Persistence Volume and data storage. The CAS server supports encryption for .sashdata data files in a PATH and DNFS CASLIB. The SAS Compute Server supports encryption for .sas7bdat datafiles in a PATH LIBNAME. ... View more

Hi, I am using a linux sas server RHEL 6, there when I check in bash its showing java --version as 1.8 , but in SAS EG proc javainfo; shows 1.7    How to change the Java version of SAS   ... View more

Hello,   I am trying to find min and max of the date per subject from all datasets in a library    I have created I have created DateVariables dataset using proc content to list all date variables from table1 and table2. *Want1; *I would like to list all dates available for the subject in entire library; /*subjID date11 date12 date13 date21 ...(all dates available)*/ subjID date11 date12 date13 date21 --------------------------------------------------------------------------- subj1 01/01/21 01/01/22 01/01/23 02/02/02 subj2 02/01/21 02/01/22 02/01/23 *want2; *find min and max of the date by subjID ; subjID date_min date_max ------------------------------------------------------------ subj1 02/02/02 01/01/23 subj2 02/01/21 02/01/23   data d_test.table1; infile datalines ; input subjID $ ar5 $ var6 $ date11: ddmmyy10. date12: ddmmyy10. date13: ddmmyy10.; format date11 mmddyy10. date12 mmddyy10. date13 mmddyy10.; datalines; subj1 xxx sy 01/01/21 01/01/22 01/01/23 subj2 xttx ry 02/01/21 02/01/22 02/01/23 ; run; data d_test.table2; infile datalines ; input subjID $ var3 $ date21: ddmmyy10.; format date21 mmddyy10.; datalines; subj1 xx 02/02/02 subj2 z . ; run; *list all date variables from table1 and table2; data d_test.DateVariables; infile datalines ; input table $ varname $ ; datalines; table1 date11 table1 date12 table1 date13 table2 date21 table3 date31 table3 date32 table3 date33 table3 date34 ; run;   Thanks for your guidance! ... View more