Please see the image, what does it mean.  These table and its variable load w/o an issue.  Any suggestions to check/verify Red dot in all registered tables in a sas library (BASE) ... View more

Some time ago, I saw an article by perhaps SAS person, the topic was give n take on why it is better to keep the sas administration using installer ID etc although any person who is an administrator technically could do it.  The gist was that over time their will be permission issue seepage.   I have spent different combinations to search but no luck and yes, I am not hallucinating 🙂   Anyone has it book marked? (I did too but not finding it)   -TIA S ... View more

Hello all, looking for guidance how to setup connection to MS Synapse SQL DB (Azure AD) that has MFA.   SAS 9.4 TS1 M6 on WIN x64 2016 datacenter.   Pre-dominantly SAS ACCESS/OLE DB is used. We do have ACCESS/ODBC but 0% usage.   TIA -S   ... View more

SAS 9.4 WIN 1 machine win 2022 server, SAS EM 9.4 M8 Migrating SAS EM project from win 2012 machine M6 (Since win 2012 to win 2022 server, OS is considered different regardless if encoding, locale, bitness, & topology remains same, enter EM_MigrateProject Macro.)   Questions about EM Macro user guide   I have few follow up questions  The guide talks about project and gives example but it is unclear if it is one project or multiple? It fleetingly touches on 'multiple projects' but no detail or example of how does one prepare multiple projects all under a root directory such F:\Data\EM_Projects ? Have I understood correctly that the steps are: Run macro to prepare project or multiple projects (how?) In preparation if F:\Data\EM_Projects\baloons --> will it create F:\Data_EM_Projects\baloon (prepared copy?) So an original and migration ready copy? Shared filesystem or SFTP move the prepared project to new server Restore projects In SMC open EM plugin, assign new project and point to project which will create metadata (no creating SPKs to export then import)? Does that mean this needs to get done for all individual 200 projects in SMC or it just mean point the work space server to the project location in SMC such as F:\Data\EM_Projects (we plan to move the physical files same names, attributes, paths, hierarchy, permissions and attributes.)    I have read the guide and will do again, but anyone with some experience just explain a bit? Perhaps I am over thinking.    I will provide further details if needed.   Ref: https://documentation.sas.com/doc/en/emag/15.3/n0njhjomq595tdn1da3x0bj4ndn1.htm   User guide and readme is attached too.     ... View more

Has anyone configured MFA for their SAS 9.4 M7/M8 successfully?  Which documents were followed?  There is a document with Symantec by Mike Roda et al in 2018 but missing some details (the article mentions details not provided).  Any insight is appreciated.   -S ... View more

SAS 9.4 M8 WIN 2022 server ACCESS/Hadoop   There is an article by the Guru Stuart Rogers RE. Hadoop Deployment - Kerberos and I am looking for some further clarifications: 1. For WIN environment, if separate MIT KDC setup is not an option, will WIN registry update still work "REG_DWORD key AllowTgtSessionKey registry key" ? 2. There is a script SAS provides (SAS TS) for Linux that could be placed in WorkspaceServer_usermods.sh where TGT is searched for the user that started the session, should that be done for SAS WIN based work space server too? 3. There is a requirement for Java Unlimited strength policy files, with SAS using Zulu (Azul) JRE, does anyone know the download URL or is it now packaged automatically with new SAS bundled JREs?   Thank you in advance,   S   ... View more