This program aims to validate the `%mddl_dc_filtersummary` macro. It attempts to create a structural table in the `WORK` library (named `TEST`), then uses an assertion (`%mp_assert`) combined with an existence check (`%mf_existds`) to confirm that the table has been successfully generated. Test results are stored in `work.test_results`.
Data Analysis
Type : CREATION_INTERNE
The data structure is generated by executing the `%mddl_dc_filtersummary` macro.
1 Code Block
MACRO Data
Explanation : Calling the DDL (Data Definition Language) macro to generate the `filtersummary` table in the `WORK.TEST` destination.
Copied!
%mddl_dc_filtersummary(libds=WORK.TEST)
1
%mddl_dc_filtersummary(libds=WORK.TEST)
2 Code Block
MACRO Data
Explanation : Executing an assertion to validate the success of the previous step. The `%mf_existds` macro checks for the physical existence of the `WORK.TEST` table. If it exists (returns 1), the test is considered successful. The result is logged in `work.test_results`.
Copied!
%mp_assert(
iftrue=(%mf_existds(WORK.TEST)=1),
desc=Checking table was created,
outds=work.test_results
)
1
%mp_assert(
2
iftrue=(%mf_existds(WORK.TEST)=1),
3
desc=Checking TABLE was created,
4
outds=work.test_results
5
)
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.
SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration. WeAreCAS is an independent community site and is not affiliated with SAS Institute Inc.
This site uses technical and analytical cookies to improve your experience.
Read more.