topic I want to export all the dataset name and corresponding variable name into excel but getting anerror in SAS Programming

I want to export all the dataset name and corresponding variable name into excel but getting anerror

animesh123 — Thu, 23 Nov 2023 09:45:20 GMT

%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);

Re: I want to export all the dataset name and corresponding variable name into excel but getting ane

Kurt_Bremser — Thu, 23 Nov 2023 10:14:33 GMT

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:

Re: I want to export all the dataset name and corresponding variable name into excel but getting ane

rudfaden — Thu, 23 Nov 2023 10:18:46 GMT

Works for me.

What error do you get?