sas_compare

Compares SDTM/ADaM, TLF datasets, etc. Assume a double program in the pharmaceutical industry to compare main and sub

%ads_compare

Main Functions :

• Iteratively compares a list of target datasets between two libraries.
• Creates a unique output folder using date and time.
• Generates PROC COMPARE reports as PDF files.
• Automatically renames the result files to indicate "OK" or "NG" compare-match status.
• Aggregates comparison results into a summary dataset.
• Exports the summary as an Excel file.

Parameters :

  output_folder : Full path to the folder where output files will be saved.
  main_lib_path : Path to the main library containing the original ADaM datasets.
  sub_lib_path  : Path to the sub library containing the comparison ADaM datasets.
  target_list   : Space-delimited list of dataset names to compare.

Usage Example :

  %ads_compare(
    output_folder = D:/project/output,
    main_lib_path = D:/project/main,
    sub_lib_path  = D:/project/sub,
    target_list   = A
                    B
                    C
                    D
                    E
  );

What is SAS Packages?

The package is built on top of SAS Packages framework(SPF) developed by Bartosz Jablonski.
For more information about SAS Packages framework, see SAS_PACKAGES.
You can also find more SAS Packages(SASPACs) in SASPAC.

How to use SAS Packages? (quick start)

1. Set-up SPF(SAS Packages Framework)

Firstly, create directory for your packages and assign a fileref to it.

filename packages "\path\to\your\packages";

Secondly, enable the SAS Packages Framework.
(If you don't have SAS Packages Framework installed, follow the instruction in SPF documentation to install SAS Packages Framework.)

%include packages(SPFinit.sas)

2. Install SAS package

Install SAS package you want to use using %installPackage() in SPFinit.sas.

%installPackage(packagename, sourcePath=\github\path\for\packagename)

(e.g. %installPackage(ABC, sourcePath=https://github.com/XXXXX/ABC/raw/main/))

3. Load SAS package

Load SAS package you want to use using %loadPackage() in SPFinit.sas.

%loadPackage(packagename)

Enjoy😁