• Vendor will convert (re-develop) existing SAS code-based Backend processinto an optimized Oracle PL/SQL codebase. • This backend process integrates multiple data-sources, massages data, implements business logic & business rules, and prepares data for final reporting. • Vendor will ensure the converted code maintains the functional equivalence or better and performance efficiency of the original SAS code. • Overall, the script does not perform complex conversions using SAS statistical functions, it is an ETL process written in SAS that can be transitioned to PL/SQL. ACS was able to convert 15% of the code and did not encounter any technical issue, ACS needs vendor assistance due to resource constraints with internal staff. • There are about 120 SAS code snippets – couple of sample snippets are as below. • Sample SAS code 1. Sample 1 data facspell; set facspell; by vid ; if not last.vid then do ; p = _n_ + 1 ; set facspell (keep=start_dt rename=(start_dt=end_dt)) point = p ; end ; else end_dt ='01jan2111'd ; /*future date*/ if first.vid then f_act='F000';run; data fac; set fac(drop=end_dt); by vid start_dt; if not last.vid then do ; p = _n_ + 1 ; set fac (keep=start_dt rename=(start_dt=end_dt )) point = p ; end ; else do; end_dt ='01jan2111'd; end; /*future date*/ ;run; 2. Sample 2 data FO (drop= moda rename=N=P); set FO ;by recipid; N = _n_ + 1; if act not in ("M981" "M982") then facid=moda; else facid=modb; if not last.recipid then do ; p = _n_ + 1 ; set FO (keep=actdate act rename=(actdate=actend act=nextact )) point = p ; end ; else do; actend ='01jan2111'd ;nextact=''; end; /*future date*/ *TEMPORARY actend for M983 purposes; if act in ("M999", "M990", "M970", "M950") then actend= actdate; ;run;
