%macro export_dataset_names(libname, outpath);
proc contents data=&libname.._all_ noprint out=_datasets(keep=memname);
run;
proc export data=_datasets
outfile="&outpath.\DatasetNames.xlsx"
dbms=xlsx
replace;
run;
proc datasets library=work nolist;
delete _datasets;
quit;
%mend;
%export_dataset_names(MDM, C:\Users\alokj\OneDrive\Desktop\MDM);
Whenever you have questions about an ERROR or WARNING, or have other issues with your code, post the complete (all code and messages) log by copy/pasting it into a window opened with this button:
Works for me.
What error do you get?
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
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.
Ready to level-up your skills? Choose your own adventure.