This script executes the Data Definition Language (DDL) macro '%mddl_dc_maxkeytable' to create the 'WORK.TEST' table. It then validates the success of this operation using the assertion macro '%mp_assert' combined with the verification function '%mf_existds', storing the test result in 'work.test_results'.
Data Analysis
Type : CREATION_INTERNE
The data (table structure) is generated by the execution of the internal DDL macro. No external source is required.
1 Code Block
MACRO Data
Explanation : Call to the DDL macro to generate the 'Maxkeytable' table structure in the temporary WORK library.
Copied!
%mddl_dc_maxkeytable(libds=WORK.TEST)
1
%mddl_dc_maxkeytable(libds=WORK.TEST)
2 Code Block
MACRO
Explanation : Unit test assertion: checks if the 'WORK.TEST' table exists (via %mf_existds) and records the result (success/failure) in the 'work.test_results' table.
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.