Differential Snapshot of WORK Datasets

This macro allows for an incremental 'snapshot' of the WORK library's content. Using a sequential identifier (`id`), it aggregates the list of tables detected in previous steps (1 to id-1), retrieves the current list of tables in WORK via the `%AHGdsnInLib` call, and isolates new tables by subtracting the history via `%AHGremoveWords`. The result is stored in a dynamic global variable constructed from the prefix and the ID.

Data Analysis

Type : CREATION_INTERNE

The script does not use external data sources; it inspects and manipulates the metadata of the current session's temporary WORK library.

1 Code Block

MACRO

Explanation :
Macro definition. It consolidates table lists from previous iterations, queries the current content of WORK, and calculates the delta to keep only new tables created at this `id` step. It depends on several external utility macros (AHGdsnInLib, AHGpm, AHGnonblank, AHGremoveWords).

Copied!

1	%macro AHGsnaplib(id,pre=ahgworkdsns);
2	%local i all alist;
3	%global &pre&id;
4	%DO i=1 %to %eval(&id-1);
5	%let all=&all &&&pre&i;
6	%END;
7	%let alist=;
8	%AHGdsnInLib(lib=work,list=alist);
9	%AHGpm(alist);
10	%IF %AHGnonblank(&all) %THEN %let &pre&id=%AHGremoveWords(&alist,&all,dlm=%str( ));
11	%ELSE %let &pre&id=&alist;
12
13	%mend;

This material is provided "as is" by We Are Cas. There are no warranties, expressed or implied, as to merchantability or fitness for a particular purpose regarding the materials or code contained herein. We Are Cas is not responsible for errors in this material as it now exists or will exist, nor does We Are Cas provide technical support for it.

Retour à la liste