proc contents for multiple datasets containing similar string in name

kb011235 — Tue, 20 Jul 2021 23:51:55 GMT

Hi,

Using https://www.lexjansen.com/sesug/2015/76_Final_PDF.pdf as a starting point, I have

ods output variables = proc_vars;
proc contents data=par_dat._all_;
run;
proc sort data=proc_vars;
 by member num;
run;
options nobyline;
ODS EXCEL FILE="&xpt.par_dat_contents.xlsx"
 options(sheet_name="#BYVAL(member)"
 embedded_titles='yes');
proc print data=proc_vars noobs;
 by member;
 pageby member;
 title "Variables in #BYVAL(member) table";
run;
ODS EXCEL CLOSE;

I don't actually want the proc contents of all of the datasets, but only the ones that end in 20210720 (where=(memname like '%20210720')). How can the code be updated to limit the output? Thanks in advance.

Re: proc contents for multiple datasets containing similar string in name

ChrisNZ — Wed, 21 Jul 2021 01:57:26 GMT

Why not just use this?

proc print data=PROC_VARS(where=(MEMNAME like '%20210720')) noobs;

Re: proc contents for multiple datasets containing similar string in name

kb011235 — Wed, 21 Jul 2021 15:28:32 GMT

Thanks, update memname to member and it works.

topic Re: proc contents for multiple datasets containing similar string in name in SAS Programming

proc contents for multiple datasets containing similar string in name

Re: proc contents for multiple datasets containing similar string in name

Re: proc contents for multiple datasets containing similar string in name