This week's SAS tip is from Implementing CDISC Using SAS: An End-to-End Guide by Chris Holland and Jack Shostak. If you'd like to learn more about what CDISC offers, look no further. As SAS user Greg Nelson said, "Combined with useful advice and working examples, this treatise on CDISC implementation will serve you well."

If you're interested in this week's excerpt, be sure to take a look at this previously featured tip from Chris and Jack's book - Converting from native SAS to version 5.0 transport files.

The following excerpt is from SAS Press authors Chris Holland and Jack Shostak's book "Implementing CDISC Using SAS: An End-to-End Guide" Copyright © 2012, SAS Institute Inc., Cary, North Carolina, USA. ALL RIGHTS RESERVED. (please note that results may vary depending on your version of SAS software).

Converting from Version 5.0 Transport Files to Native SAS

Regulatory reviewers and, perhaps, anyone else who prefers to deal with native SAS datasets rather than transport files, might be more interested in the %FROMEXP macro. As the name suggests, this macro converts a directory of transport files to native SAS datasets. Coupling this macro with the %MERGSUPP macro, reviewers can quickly convert their submission data to native SAS datasets and all supplemental qualifiers merged in with their parent domains, which can make review work much easier.

Following is a sample demonstration:

%let indir=&path\data\sdtm\xpt2;
%let outdir=&path\data\sdtm\mergsupp;
%fromexp(&indir, &outdir);
libname sdtm "&outdir";
%mergsupp(sourcelib=sdtm, outlib=sdtm);

Running these macros on the SDTM data that were created in earlier chapters creates a version of the DM domain (in the MERGSUPP subdirectory) that has columns for RANDDTC and RACEOTH, the two supplemental qualifiers in SUPPDM.