We need below information by using SAS Code. and also extarct below information in Excel.
User ID, User Name, User Created Date, Last Login Date, Groups, Roles and capabilities
First you need to read the data into SAS. Try using PROC IMPORT. If there are still problems, show us a portion of the SAS data set (we do not want to see Excel) by following these examples and instructions.
Please read this: How to get fast, helpful answers
If you need to import from an Excel file, see PROC IMPORT or LIBNAME XLSX.
If you have trouble with this post the complete log of the step(s) you tried.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.