@Nipun22  if you want to understand the capabilities of the DOW Loop @Tom used, check out these additional papers after reading his responce https://support.sas.com/resources/papers/proceedings09/038-2009.pdf https://www.lexjansen.com/pharmasug/2014/BB/PharmaSUG-2014-BB02.pdf    ... View more

Hi @_el_doredo  Libraries based on SAS/ACCESS Interface to <RDBMS> (Oracle, Hive, Teradata, Snowflake,....etc) will not have all the table's characteristics/properties in the SAS dictionary tables/views, nor in the Data Set header portion.   So to get Row/Observation count for external <RDBMS> table, your two options are: Query the <RDBMS> internal dictionary/system tables (Efficient). For Teradata, check these links  https://dbmstutorials.com/teradata/teradata_data_dictionary_queries.html https://dataedo.com/kb/query/teradata/list-of-tables-by-the-number-of-rows   Issue Select count(*) query for every table in your list (can be Inefficient)! Not desired for large tables, if the database does not save this info !  Hope this helps, Ahmed ... View more

Hi @andreas_lds  if you are able to get a new Software depot -- place it on a Network drive (windows), or a Linux Filesystem that you can setup Samba File Share on, in order for your windows users see it as just another Network Drive.   Once you have Network access point, you should be able to execute the SAS Software Deployment Wizard (SDW) to upgrade your Windows Client Apps    Hope this helps ... View more

One of the issues we are facing right now, has to do with SAS 9.4 SAS/Connect & SAS/Share modules in SAS Foundation deployment! These two modules were designed and developed way before the concept of MFA was thought off, therefore it may cause a challenge, to get them properly integrated for MFA .   Just as an FYI ... View more

@ballardw  MFA: Multi Factor Authentication This is a requirements for Zero Trust environment, and a mandate for government agencies ... View more

why not use this  data DB(KEEP=ID index); input ID :$20. City :$20. School :$20. Parents :$20.; index = max(city,school,parents); cards; 0001 0 0 0 0001 1 1 1 0004 1 0 0 0004 0 0 1 0004 0 0 0 0005 0 1 1 0006 1 0 0 0006 1 1 1 0006 1 1 0 .... ; run; ... View more

Hi @phopkinson    Check out these articles , and the articles they reference https://communities.sas.com/t5/SAS-Communities-Library/Use-the-latest-date-in-your-VA-report/ta-p/536536 https://communities.sas.com/t5/SAS-Communities-Library/Build-a-date-in-SAS-Visual-Analytics-reports/ta-p/760983   Hope this helps, Ahmed   ... View more

Hi @hollandnumerics  Check this community article  How to use VS Code with SAS OnDemand for Academics It lists the North America Servers you could try to connect to when trying to login into SODA.   Hope this helps, Ahmed ... View more

@JB1_DK  From reading the docs link you included, it sounded to me, Personal CAS server is defined/enabled by a setting the Viya installer would enable. It will live within the same Docker/Kubernetes infrastructure and not on-prime/personal machine/server. This is my personal understanding. but I think you can get the definitive answer from SAS Tech support.   ... View more

@JB1_DK @Quentin  I forgot this additional option - Experience SAS® Viya® for yourself (You register for free 14-day trial) ... View more

@JB1_DK  SAS Viya is cloud based deployment, and there is no way for "set up a Personal CAS Server" per-say,  and as far as I know, your only options for "personal" access might be - SAS Viya for Learners If you have academic email address - SAS® Viya® (Pay-As-You-Go)   Hope this helps, Ahmed ... View more

Hi @sasjradmin    Have a look at this link https://sas.service-now.com/csm?id=kb_article_view&sysparm_article=KB0036628 for possible papers that could help with your issue or at least investigate/monitor server performance.   Hope this helps, Ahmed ... View more

Sorry, I don't have any! ... View more

Hi @SAS_1001  Check out these links  https://support.sas.com/resources/papers/proceedings19/3363-2019.pdf https://docs.aws.amazon.com/whitepapers/latest/best-practices-for-deploying-sas-server/sas-architecture.html https://support.sas.com/resources/papers/proceedings15/2883-2015.pdf https://support.sas.com/resources/papers/proceedings16/SAS5501-2016.pdf Despite being outdated links, some of the info contained should give you a high level of what to expect.   Note: AWS has introduced several new services and capabilities/features since these papers and links were published/created, therefore I would highly recommend you approach/contact your SAS sales/customer success  representative and work with their Technical Architects Team to ensure and successful and perfromant deployment.   For alternative options and consideration check this link: https://www.sas.com/en_us/solutions/cloud.html   Hope this helps. Ahmed ... View more

Where can we get more information about SAML Authentication in SAS 9.4 M8? Thanks, Ahmed ... View more