A SAS package to place miscellaneous macros, functions, etc.
The repo will be collaborative work.
Purpose: This macro converts xpt files in the folder into sas7bdat files.
Sample code:
%xpt2sas(
indir=C:\place\for\xpt, /* Directory with xpt files */
outdir=C:\place\for\sas7bdat /* Directory for sas7bdat files */
)Author: Ryo Nakaya
Date: 2025-06-28
Version: 0.1
Purpose: The macro analyzes all character variables in the dataset, determines the maximum length actually used, and alters the table to adjust each variable's length accordingly.
Sample code:
%minimize_charlen(dm)%minimize_charlen(class, inlib=sashelp, outlib=work)Author: Yutaka Morioka
Date: 2025-07-02
Version: 0.1
Purpose: roundsig:This macro performs rounding based on the specified number of significant digits.. rounddec:Rounds a numeric variable to the specified number of decimal places and converts it to a character variable.
%roundSig(trgVal=RES,Sig=3);
/*Only integer values can be assigned to the "Sig" parameter.
For example, if set to "3",
"1.234" becomes "1.23",
"12.34" becomes "12.3",
"12.34" becomes "12.3",
"123.4" becomes "123",
"1234" becomes "1230".*/%roundDec(trgVal=RES,dec=1);Author: Hiroki Yamanobe
Date: 2025-07-03
Version: 0.3
Description: This macro retrieves SAS color definitions from the system registry (COLORNAMES section) and generates a visual color swatch table using PROC REPORT. Each row displays the color name, its hexadecimal code, and a cell shaded with the corresponding color.
Purpose: - Extract color name and hex values from SAS registry - Display each color with its background for visual reference - Useful for selecting and verifying colors for reports and graphics
Note: The color sample will not be displayed unless ODS HTML is turned on.
Sample code:
%color_swatch()
Author: Yutaka Morioka
Date: 2025-07-23
Version: 0.1
Swap numeric scalars
data _null_;
a = 1; b = 2;
put 'Before: ' a= b=;
call swapn(a, b);
put 'After : ' a= b=;
run;
Swap character scalars
data _null_;
length s t $10;
s = 'foo'; t = 'bar';
put 'Before: ' s= t=;
call swapc(s, t);
put 'After : ' s= t=;
run;
Author: Yutaka Morioka
Date: 2025-08-26
Version: 0.1
Swap numeric arrays (must have the same dimension)
data _null_;
array x[3] x1-x3 (1 2 3);
array y[3] y1-y3 (10 20 30);
put 'Before X: ' x1= x2= x3= / 'Before Y: ' y1= y2= y3=;
call swapn_vec(x, y);
put 'After X: ' x1= x2= x3= / 'After Y: ' y1= y2= y3=;
run;
Author: Yutaka Morioka
Date: 2025-08-26
Version: 0.1
Swap character arrays (must have the same dimension)
data _null_;
length a1-a3 b1-b3 $10;
array a[3] a1-a3 ('AAA' 'BBB' 'CCC');
array b[3] b1-b3 ('XXX' 'YYY' 'ZZZ');
put 'Before A: ' a1= a2= a3= / 'Before B: ' b1= b2= b3=;
call swapc_vec(a, b);
put 'After A: ' a1= a2= a3= / 'After B: ' b1= b2= b3=;
run;
Author: Yutaka Morioka
Date: 2025-08-26
Version: 0.1
Purpose:
Display a comprehensive list of SAS DICTIONARY tables and corresponding SASHELP views, along with short descriptions for each.
This macro serves as a quick reference or lookup guide to understand the relationship between SQL-accessible DICTIONARY tables and their SASHELP counterparts.
Usage Example:
%view_swatch();
Author: Yutaka Morioka
Date: 2025-10-27
Version: 0.1
Purpose:
Generate a visual swatch of line patterns available in SAS (pattern numbers 1 - 46).
Usage Example:
%line_swatch();
Author: Yutaka Morioka
Date: 2025-10-27
Version: 0.1
Purpose:
Generate a visual swatch of marker symbol patterns available in SAS
Usage Example:
%symbol_swatch();
Author: Yutaka Morioka
Date: 2025-10-27
Version: 0.1
This macro is based on the SAS macros referenced from Saikrishnareddy Yengannagari’s sdtm-epoch repository
(https://github.com/kusy2009/sdtm-epoch).
The original repository provides SDTM EPOCH derivation implementations in three languages: SAS, R, and Python.
For full details and the complete implementations, please refer to the original repository.
Purpose: This macro derives the EPOCH variable for SDTM datasets by analyzing subject event records from the SE (Subject Elements) domain.
It handles ISO 8601 date/datetime formats with varying precision and supports edge case handling for dates falling outside the SE date ranges.
Parameters:
-- param[in] sdtm_in Input SDTM dataset (required)
-- param[out] sdtm_out Output dataset name (required)
-- param[in] ref_var Reference date/datetime variable in sdtm_in (required).
Should be ISO 8601 format (e.g., RFSTDTC, AESTDTC)
-- param[in] handle_edge Handle dates outside SE range (default: N)
- Y: assign first/last epoch for out-of-range dates
(Use with caution - SDTM IG recommends null for pre-study records)
- N: leave EPOCH missing for out-of-range dates (SDTM IG compliant)
Notes:
-- This macro expects the SE (Subject Elements) dataset to be present
in the SDTM library as sdtm.se before calling this macro.
-- SE domain must contain: USUBJID, SESTDY, SEENDY, SESTDTC, SEENDTC,
EPOCH, TAETORD
-- Missing SEENDTC on non-terminal records is imputed from next SESTDTC
-- Datetime comparison uses full precision when time component exists
-- Boundary overlap handling: When a date falls on the boundary between two epochs
(e.g., SEENDTC of one epoch equals SESTDTC of next), the later epoch is assigned based on the tightest SESTDTC match)
-- Per SDTM IG: For Findings, use --DTC as ref_var; for Interventions/Events, use --STDTC
-- Per SDTM IG: Pre-study records (before subject participation) should have null EPOCH.
Use handle_edge=N (default) to comply with this guidance.
Usage Example:
// Derive EPOCH for AE domain using AESTDTC (Interventions/Events use --STDTC)
%derive_epoch(
sdtm_in = sdtm.ae,
sdtm_out = ae_with_epoch,
ref_var = aestdtc
);
// Derive EPOCH for VS domain using VSDTC (Findings use --DTC)
%derive_epoch(
sdtm_in = sdtm.vs,
sdtm_out = vs_with_epoch,
ref_var = vsdtc
);
// With edge case handling enabled (use with caution)
%derive_epoch(
sdtm_in = sdtm.lb,
sdtm_out = lb_with_epoch,
ref_var = lbdtc,
handle_edge = Y
);Author: Saikrishnareddy Yengannagari
Date: 2025-12-23
Version: 1.0
0.0.7(23December2025) : Add derive_epoch
0.0.6(27October2025) : Add view_swatch, line_swatch, symbol_swatch
0.0.5(26August2025) : Add swapn routine, swapc routine, swapn_vec routine, swapc_vec routine
0.0.4(23July2025) : Add %color_swatch
0.0.3(03July2025) : Add %rounddec, roundsig
0.0.2(02July2025) : Add %minimize_charlen
0.0.1(28June2025) : Initial version
The package is built on top of SAS Packages Framework(SPF) developed by Bartosz Jablonski.
For more information about the framework, see SAS Packages Framework.
You can also find more SAS Packages (SASPacs) in the SAS Packages Archive(SASPAC).
First, create a directory for your packages and assign a packages 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)Install SAS package you want to use with the SPF's %installPackage() macro.
-
For packages located in SAS Packages Archive(SASPAC) run:
%installPackage(packageName)
-
For packages located in PharmaForest run:
%installPackage(packageName, mirror=PharmaForest)
-
For packages located at some network location run:
%installPackage(packageName, sourcePath=https://some/internet/location/for/packages)
(e.g.
%installPackage(ABC, sourcePath=https://github.com/SomeRepo/ABC/raw/main/))
Load SAS package you want to use with the SPF's %loadPackage() macro.
%loadPackage(packageName)