topic Re: PROC DOCUMENT : wildcards? in ODS and Base Reporting

PROC DOCUMENT : wildcards?

RichardP — Fri, 18 Sep 2020 17:47:09 GMT

Hello,

is it possible to use wildcards in PROC DOCUMENT. For example I would like to perform the same action on all objects within a document directory.


proc document name=test;
 dir \listings;
 obpage \LISTING#1\Report#1\Report#1\Report#1 / after delete;
 obpage \LISTING#1\Report#2\Report#1\Report#1 / after delete;
 obpage \LISTING#1\Report#3\Report#1\Report#1 / after delete;
run;
quit;

replace with


proc document name=test;
 dir \listings;
 obpage \LISTING#1\* / after delete;
run;
quit;

anyone know if this is possible?

kind regards,
Richard

Re: PROC DOCUMENT : wildcards?

pink_poodle — Fri, 18 Sep 2020 20:33:58 GMT

You can do this with a macro:
%macro cookie;
proc document name=test;
dir \listings;
%do i = 1 %to 3;
obpage \LISTING#1\Report#&i.\Report#1\Report#1 / after delete;
%end;
run;
quit;
%mend;
%cookie;

Re: PROC DOCUMENT : wildcards?

RichardP — Thu, 24 Sep 2020 07:42:06 GMT

thanks, yes this would be an acceptable solution. I have not checked yet but is it possible to extract the number of reports for the %do loop value?

Re: PROC DOCUMENT : wildcards?

pink_poodle — Thu, 24 Sep 2020 14:31:05 GMT

You can supply that parameter into a macro:
* nrep is number of reports;
%cookie(nrep);
...
%do i %to &nrep;
...
%end;
%mend;
%cookie(&nrep);

Re: PROC DOCUMENT : wildcards?

RichardP — Fri, 25 Sep 2020 09:02:06 GMT

The thing is I will not always know how many reports are in my catalog. I need this to be dynamic.

Re: PROC DOCUMENT : wildcards?

pink_poodle — Fri, 25 Sep 2020 12:50:25 GMT

Ok, you can do this using proc sql and Dictionary tables:
(https://documentation.sas.com/?docsetId=lrcon&docsetTarget=p00cato8pe46ein1bjcimkkx6hzd.htm&docsetVersion=9.4&locale=en )

proc sql;
select count(distinct memname) /* not sure it’s memname, view table to verify */
:into &nrep
from dictionary.tables /* not sure it's .tables, check above website to verify */
where libname = “YOUR_CATALOG”
;
quit;

%put &nrep; *check in log that there is something there;

Please make sure that name of library is in capital letters.