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 */
25 proc sql noprint;
26 create 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;
31 select 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)