Get all dataset variables in your SAS library

Below is a useful SAS program to query and retrieve all datasets, dataset variables, and variable details in a SAS library.

libname MYREP "C:\my_SAS_repository";
proc sql noprint;
create table ds as
select * from dictionary.tables
where libname="MYREP";
quit;
/*get variable information*/;
proc sql noprint;
create table cont as
select * from dictionary.columns
where libname="MYREP";
quit;