exportconfig.sas

Go to the documentation of this file.

/**
  @file
  @brief Downloads zip file of DC customer configurations
  @details Zip contains several excel files, containing the customer specific
    (non-DC) configurations.  Useful when migrating to a new instance of
    Data Controller.
 
 
  <h4> SAS Macros </h4>
  @li mf_getuser.sas
  @li mf_nobs.sas
  @li mp_abort.sas
  @li mp_binarycopy.sas
  @li mp_ds2cards.sas
  @li mp_ds2csv.sas
  @li mp_streamfile.sas
  @li mp_validatecol.sas
  @li mpe_getgroups.sas
 
  @author 4GL Apps Ltd
  @copyright 4GL Apps Ltd.  This code may only be used within Data Controller
    and may not be re-distributed or re-sold without the express permission of
    4GL Apps Ltd.
 
**/
 
%global dclib islib newlib;
%mpeinit()
 
/* check user is in admin group */
%let cnt=0;
%mpe_getgroups(user=%mf_getuser(),outds=work.usergroups)
proc sql noprint;
select count(*) into:cnt
  from usergroups
  where groupname="&mpeadmins";
%mp_abort(iftrue= (&cnt=0)
  ,mac=&_program
  ,msg=%str(The DC configuration can only be exported by &mpeadmins members)
)
 
data _null_;
  newlib=coalescec(symget('dclib'),"&mpelib");
  %mp_validatecol(newlib,ISLIB,islib)
  call symputx('islib',islib);
  call symputx('newlib',upcase(newlib));
  putlog (_all_)(=);
run;
 
%mp_abort(iftrue= (&islib ne 1)
  ,mac=&_program
  ,msg=%nrstr(&newlib is not a valid libref)
)
 
%let work=%sysfunc(pathname(work));
%let mime=application/csv;
%let dbms=CSV;
%let ext=csv;
 
%macro conditional_export(ds);
%if %mf_nobs(&ds)>0 %then %do;
  /* cannot use PROC EXPORT as we need to wrap all csv char values in quotes */
  /* cannot use excel as it does not work consistently in all SAS envs */
  %mp_ds2csv(&ds,outfile="&work/&newlib..&ds..csv",headerformat=NAME)
  ods package(ProdOutput) add file="&work/&newlib..&ds..&ext" mimetype="&mime";
%end;
%mp_abort(iftrue= (&syscc ne 0)
  ,mac=&_program
  ,msg=%nrstr(syscc=&syscc after &ds prep)
)
%mend conditional_export;
 
 
ods package(ProdOutput) open nopf;
 
data MPE_ALERTS;
  set &mpelib..MPE_ALERTS;
  where &dc_dttmtfmt. le tx_to;
  drop tx_: ;
  if alert_lib="&mpelib" then alert_lib="&newlib";
run;
%conditional_export(MPE_ALERTS)
 
 
data MPE_COLUMN_LEVEL_SECURITY;
  set &mpelib..MPE_COLUMN_LEVEL_SECURITY;
  where &dc_dttmtfmt. le tx_to;
  where also CLS_LIBREF ne "&mpelib";
  drop tx_: ;
  CLS_LIBREF="&newlib";
run;
%conditional_export(MPE_COLUMN_LEVEL_SECURITY)
 
data MPE_CONFIG;
  set &mpelib..MPE_CONFIG;
  where &dc_dttmtfmt. le tx_to;
  drop tx_: ;
  if var_name='DC_MACROS' then var_value=tranwrd(var_value,"&mpelib","&newlib");
run;
%conditional_export(MPE_CONFIG)
 
data MPE_DATADICTIONARY;
  set &mpelib..MPE_DATADICTIONARY;
  where &dc_dttmtfmt. le tx_to;
  drop tx_: ;
  if DD_SOURCE=:"&mpelib" then do;
    /* nothing */
  end;
  else output;
run;
%conditional_export(MPE_DATADICTIONARY)
 
data MPE_EMAILS;
  set &mpelib..MPE_EMAILS;
  where &dc_dttmtfmt. le tx_to;
  drop tx_: ;
run;
%conditional_export(MPE_EMAILS)
 
data MPE_EXCEL_CONFIG;
  set &mpelib..MPE_EXCEL_CONFIG;
  where &dc_dttmtfmt. le tx_to;
  drop tx_: ;
  if xl_libref="&mpelib" then xl_libref="&newlib";
run;
%conditional_export(MPE_EXCEL_CONFIG)
 
data MPE_GROUPS;
  set &mpelib..MPE_GROUPS;
  where &dc_dttmtfmt. le tx_to;
  drop tx_: ;
run;
%conditional_export(MPE_GROUPS)
 
data MPE_ROW_LEVEL_SECURITY;
  set &mpelib..MPE_ROW_LEVEL_SECURITY;
  where &dc_dttmtfmt. le tx_to;
  drop tx_: ;
  if rls_libref="&mpelib" then rls_libref="&newlib";
run;
%conditional_export(MPE_ROW_LEVEL_SECURITY)
 
 
data MPE_SECURITY;
  set &mpelib..MPE_SECURITY;
  where &dc_dttmtfmt. le TX_TO;
  drop tx_: ;
  if libref="&mpelib" then libref="&newlib";
run;
%conditional_export(MPE_SECURITY)
 
data MPE_SELECTBOX;
  set &mpelib..MPE_SELECTBOX;
  where &dc_dttmtfmt. le ver_to_dttm;
  where also select_lib ne "&mpelib";
  drop ver_: selectbox_rk;
run;
%conditional_export(MPE_SELECTBOX)
 
data MPE_TABLES;
  set &mpelib..MPE_TABLES;
  where &dc_dttmtfmt. le TX_TO;
  where also LIBREF ne "&mpelib";
  drop tx_: ;
run;
%conditional_export(MPE_TABLES)
 
data MPE_VALIDATIONS;
  set &mpelib..MPE_VALIDATIONS;
  where &dc_dttmtfmt. le TX_TO;
  where also BASE_LIB ne "&mpelib";
  drop tx_: ;
run;
%conditional_export(MPE_VALIDATIONS)
 
data MPE_XLMAP_INFO;
  set &mpelib..MPE_XLMAP_INFO;
  where &dc_dttmtfmt. le TX_TO;
  drop tx_: ;
  if XLMAP_TARGETLIBDS=:"&mpelib.." then
    XLMAP_TARGETLIBDS=tranwrd(XLMAP_TARGETLIBDS,"&mpelib..","&newlib..");
run;
%conditional_export(MPE_XLMAP_INFO)
 
data MPE_XLMAP_RULES;
  set &mpelib..MPE_XLMAP_RULES;
  where &dc_dttmtfmt. le TX_TO;
  drop tx_: ;
run;
%conditional_export(MPE_XLMAP_RULES)
 
 
/* finish up zip file */
ods package(ProdOutput) publish archive properties
        (archive_name="DCBACKUP.zip" archive_path="&work");
ods package(ProdOutput) close;
 
%mp_abort(iftrue= (&syscc ne 0)
  ,mac=&_program..sas
  ,msg=%nrstr(syscc=&syscc after zip prep)
)
 
/* now serve zip file to client */
%mp_streamfile(contenttype=ZIP
  ,inloc=%str(&work/DCBACKUP.zip)
  ,outname=DCBACKUP.zip
)