Last year I took a bite of the newly SAS Proc Groovy to read JSON data since there was no direct “proc import” or “infile” or “libname” way to play with JSON. Here is an nice example from SAS official blog, by Falko Schulz where Proc Groovy is used to parse Twitter JSON file: How […]
Tag: XML
What’s New
I didn’t blog for a while in this first half March and there are bunches of new stuff to catch up: I had a new baby! He was delivered on time (and on budget!), lions tigers and bears, oh my… His brother is Tiger so I named him, Leo. And I got the latest SAS […]
Best of SAS: A Personal Nomination 2012
There SAS applications/procedures/features were not necessarily available since 2012. This year I paid special attention to them when began to use SAS 9.3. The following notes are totally my personal endorsement purely based my own experience as a user: XML File Reading: SAS XML Mapper SAS XML Mapper itself is not an elegant tool from […]
Blogging is Awesome: CDISC Bloggers
I remember when blogging was cool. Before the specializing and monetizing and Twitter-izing. —Peter Dewolf Well I think blogging is still cool (and awesome and awesome …). The most appealing personal reason is, blog posts are Google searchable and suitable for archive while Tweets NOT. Admittedly I hold some sort of Existentialism 2.0: if […]
OpenCDISC Validator V1.3: An Unboxing Review (1): counting issue
The lasted OpenCDISC Validator version 1.3 was released at 29 March, 2012 (btw, there is a typo in the Line 1 of CHANGELOG.txt within the package: “2012” not “2011”). As usual, you can submit the following SAS scripts to get some basic information(remember to customize your directory): filename CDISC url "https://raw.github.com/Jiangtang/Programming-SAS/master/Rules_Count_OpenCDISC_XML.sas"; %include CDISC; %Rules_Count_OpenCDISC_XML(dir=C:\OpenCDISC1.3\compare\opencdisc-validator_1.3\config) and […]
Face Off: Review OpenCDISC XML files
OpenCDISC, the first open source CDISC validator, is already in the toolbox of FDA reviewers (CDER/CBER, see CDISC Standards in the Regulatory Submission Process, 26 January 2012, P.33). The key features in OpenCDISC is a dichotomy of validation rules (XML based) and application logic. Currently OpenCDISC Validator (Version 1.2.1) officially supports the four following CDISC […]
Dive into CDISC Express (1): Introductory
Recently I did for my personal project some research on Clinovo’s open source application, CDISC Express, a SAS application based on Excel framework designed to map clinical data to CDISC SDTM domains automatically. Not perfect yet, but it is easily understandable and practically usable after few hours’ of exploration of user guide. And most important, […]
Making SOAP calls from SAS! Integrating with web services
One of the issues with SAS for many IT departments is the lack of integration with service oriented architecture (SOA). The good news is with many new features coming online with versions 9.X+ are service oriented. Lets look quickly at the Proc SOAP procedure now available. For those SAS programmers out there that aren’t familiar with […]