Hello YHelie1, At the top of the article, just below the title, is a link to download a PDF copy of the slides. Ask the Expert - Can I Deploy SAS Viya On-Premises.pdf ... View more

You will need to “register” for the event so you can access the on-demand version. SAS likes to know how many people watch live vs on demand. Thanks! ... View more

@Otis_, my bad! Just had a look at the tables at my side and you are right, there are no credentials included in the tables with regard to internal accounts.   You can get (some) information by taking for example the information from the PERSON_INFO table for which the ID is not listed in the PERSON_ID from the LOGIN_INFO table but this will give you no credential information. I think then the best way to move forward is to use for example the code as suggested by @Kalind_Patel or make use of the (Metacoda tool) as suggested by @PaulHomes   Good luck ... View more

Yes it's possible. In your example it looks you can make them "look" the same. So lets work on making the columns in Table 2 look like the ones in Table 1. It looks like the ones in table one all start with E and have 6 digits afterwards. Assuming this is consistent across all your data, then we can make the ones from Table 2 similar by 1) Extracting first portion of the email (use Scan() Function) 2) Making the number a  length of 6 by zero padding. (Use Z6. Format in a put statement) 3) Adding an E to the beginning (Concatenate) For EG make a calculated column that implements this and then join on the calculated column. ... View more

The %MDUEXTR macro made it easy to view user information in excel. %MDUEXTR :: SAS(R) 9.3 Intelligence Platform: Security Administration Guide ... View more