%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?
Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!
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.