extract User ID, User Name, email,group, Roles , user created date and last login info using SAS cod

[ShammiKalsi]

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 

[PaigeMiller]

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.

[Kurt_Bremser]

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.