Thanks for all the links.  However, any PPT slides if you have them will be great. ... View more

well, it's working in PC SAS but in SAS Studio its giving numbers.  Tried other solutions as well but no luck yet. ... View more

Columns should be read as dates and populate them exactly as they are but not get translated into numbers.  The options that I use in PC SAS with the below syntax works: PROC IMPORT OUT= WORK.zz DATAFILE= "Y:\folder1\sdm\customs2.xlsx" DBMS=EXCEL REPLACE; RANGE="'Scheduling Table$'"; GETNAMES=YES; MIXED=NO; SCANTEXT=YES; USEDATE=YES; SCANTIME=YES; RUN;   However, when I ran the same syntax in SAS Studio in Linux, it's not working with the following error:   69 PROC IMPORT OUT= WORK.zz 70 DATAFILE= "/home/mnt/dts-04.xls" 71 DBMS=EXCEL REPLACE; ERROR: DBMS type EXCEL not valid for import. NOTE: The SAS System stopped processing this step because of errors. ... View more

Certainly, will try this option. Thx. ... View more

This is a Linux Env. The sas installation is standalone on a single linux node, no grid setup. ... View more

well, this link is also not helpful as it's suggesting to look into registry.xml file but no instructions about changing it.  Question is: can I change with the new user in the registry.xml file? /<SASHome>/deploymntreg/registry.xml   ... View more

Yes, while launching sasdm.sh script. Error: The current user 'sasnew' is not the same user that last installed to this SAS Home location. The user that last installed was 'sasold'. It is important to perform all SAS deployment tasks using the same user in order to retain appropriate ownership and permissions of files. ... View more

well, I need to update the license with the new USER and is not letting me to do the task, asking me to log in as an original installer account to implement the license.  However, old IDs have been purged due to AD integration.  So, I need to change internal installer account from 'sasold' to 'sasnew'.  Let's know if anyone has done this. ... View more

Thank you !  Will try it and go from there ! ... View more

Thanks for the response. I had to mess up with lots of macro to accomplish the task but in vain.  Someone has recommended to use proc metadata syntax with the prepared dataset in the format that sas expects.  Any idea about proc metadata to load uses from excel to SAS MC under User Manager ? ... View more

The information provided is not much helpful.  Looking for full solution, who has already implemented.  For ex: I need to add the following user into SASMC from EG, which is stored in excel file named sasusers.   ID,         Name mike20  Mike Hadley   This user should become the part of SAS EG group in MC.   Thanks ! ... View more