Loading...
Searching...
No Matches
mpe_refreshcatalogs.test.sas
Go to the documentation of this file.
1/**
2 @file
3 @brief Testing mpe_refreshcatalogs macro
4
5 <h4> SAS Macros </h4>
6 @li mpe_refreshcatalogs.sas
7 @li mp_assert.sas
8 @li mp_assertscope.sas
9 @li mp_ds2md.sas
10
11 @author 4GL Apps Ltd
12 @copyright 4GL Apps Ltd. This code may only be used within Data Controller
13 and may not be re-distributed or re-sold without the express permission of
14 4GL Apps Ltd.
15
16**/
17
18%mp_assertscope(SNAPSHOT)
19%mpe_refreshcatalogs(FMTONLY)
20%mp_assertscope(COMPARE,
21 desc=Checking macro variables against previous snapshot
22)
23
24/* make sure that the process picks up the catalog */
25proc sql noprint;
26create table work.test1 as
27 select *
28 from &mpelib..mpe_datacatalog_cats(where=(&dc_dttmtfmt. lt tx_to))
29 where libref="FMTONLY";
30%let test1=0;
31select count(*) into: test1 from work.test1;
32
33%mp_assert(
34 iftrue=(&test1>0),
35 desc=Checking fmtonly.dcfmts was picked up
36)
37
38%mp_ds2md(work.test1)