Skip to content
Branch: master
Find file Copy path
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
77 lines (59 sloc) 2.83 KB
/*** Access PhUSE CS test data, XPT containers
See explaination in the PhUSE Wiki of this FILENAME/LIBNAME access to XPORT files
Some users are not able to access these xport archives directly, but are still able to
download data sets to a local folder. These users can specify a local folder, to override
the default, remote access method. See LOCAL parameter, below.
This utility macro isolates access to PhUSE CS test data xport archives. Any future change
to this interface can be implemented in one place, here, without requiring changes to
remaining PhUSE CS template programs.
See the PhUSE Repository in Github for available PhUSE CS test data sets
DS name of PhUSE CS test data set
REQUIRED positional
Syntax: One-level name
Example: ADVS
XPORT name of XPORT archive, if different from DS
optional keyword
Syntax: Filename of XPORT archive that includes DS. If missing, set to DS
FOLDER name of data/adam subfolder in github from which to retrieve data
optional keyword
Syntax: Folder name, case-sensitive, as it appears in
Default "cdisc" contains single-study data
Example: cdisc-split
LOCAL path to a local folder that contains the PhUSE CS test data sets, to override remote access
optional keyword
Syntax: Local path to folder with test data, quoted as needed
Example: C:\CSS\phuse-scripts\data\adam\cdisc
WORK data set with name &DS
* Implement some way of warning the user that a specified PhUSE CS data set does not exist.
%macro util_access_test_data(ds, xport=, folder=cdisc, local=);
%if %length(&xport) = 0 %then %let xport = &ds;
%if %length(&local) > 0 %then %do;
%* WARN user in case the path does NOT end with a separator, \ or / *;
%local lastchar;
%let lastchar = %qsubstr(%sysfunc(reverse(&local)),1,1);
%if &lastchar NE %quote(\) and
&lastchar NE %quote(/) %then
%put ERROR: (UTIL_ACCESS_TEST_DATA) Local test data override path must end in a separator (/ or \).;
filename source "&local.&xport..xpt";
%else %do;
filename source url "";
libname source xport access=READONLY;
data work.&ds;
set source.&ds;
%if &SYSERR ne 0 %then %do;
%put ERROR: (UTIL_ACCESS_TEST_DATA) Please confirm that data set %upcase(&DS) exists in transport file %upcase(&XPORT).;
filename source clear;
libname source clear;
%mend util_access_test_data;
You can’t perform that action at this time.