Transcript CRNnet SAS Modification Kick-off Meeting

CRNnet PopMedNet Experience
7/27/2015
David Tabano
Institute for Health Research
Kaiser Permanente Colorado
Objectives
• Overview of CRNnet functionality
• What we’ve done
• Where we’re headed
2
Goal of CRNnet
• Provide network infrastructure to conduct
rapid QA, prep-to-research (PTR) analyses
across multiple research institutions within
the CRN
3
Goal of CRNnet
• SAS Distribution- Establish quasi-automation
of SAS queries through CRN
– Enable users to manage CRN queries through
PopMedNet (PMN) Datamart Client (DMC)
4
The DMC in CRNnet
The DMC is a software application that communicates
with CRNnet through a secure IP address
– Essentially a secure file transfer software specifically
calibrated for PMN networks
• Data, files are transferred over a secure https connection
• Requires user credentials
• Tested by KP IT under the SPAN grant for cross-site scripting,
SQL injection, etc, and has since been improved further with
additional Microsoft security applications
5
CRNnet Query Volume, Jan-Jul 2015
CRNnet Query Volume, Jan-Jul 2015
Number of Sites responding
12
10
8
6
N of Sites Queried
4
N of Sites Responding
2
0
PTR PTR PTR PTR PTR QA QA QA PTR PTR PTR PTR PTR
Query Type
6
PTR/QA requests,
1/2015 – 7/2015
Type
PTR
PTR
PTR
PTR
PTR
QA
QA
QA
PTR
PTR
PTR
PTR
PTR
TOTAL
Descriptor
1019
1020
1025
1028
1029
RADIOTHERAPY
SMOKING
TUMOR STAGE
CRN Descriptive Paper
CRC CRN Poster
1033
1036
1037
Site
Queried
Responding
KPNC
KPNC
GHC
GHC
KPNC
GHC
GHC
GHC
GHC
GHC
GHC
GHC
KPNC
9
5
11
11
4
9
4
10
7
11
11
10
11
8.69
8
4
9
10
3
9
3
10
6
11
9
6
9
7.46
(Business
Days)
1.375
0.5
1.444
3.4
1.333
3.5
1
4.778
13.7
6.2
0.8
4.3
3
3.72
7
SAS Query Functionality
• Automated processing of SAS programs
submitted through CRNnet
• AutomateSASbatch.bat
– Command File (DOS executable)
– Communicates between DMC and programs at
local site; drives the entire query
• SAS
• WinZip/7Zip (where available)
8
Supporting Files
•
•
•
•
•
SAS.exe
EditSection.sas
CRNnet Standard Vars.sas
Current Query Folder.sas
WinZip.exe
– OPTIONAL- WinZip CommandLine, 7Zip can
automate compression
9
SAS Distribution Query Processing
Local DMC receives
query
Site programmer
uploads results back to
CRNnet through DMC
Site programmer
manually reviews query
results
DMC identifies output
.bat initiates local
programs
• Supporting files (SAS, WinZip,
etc.)
SAS runs query
WinZip compresses,
encrypts query
10
Query through the DMC
Pros
– More contained, streamlined
– More secure
– More efficient
Cons
– Onboarding sites
– Learning curve
– SAS Distribution requires programs need to be
correct on first run
11
CRNnet “Wish List”
• Summary query functionality underutilized
• Automated alerts (e.g. screen pop-ups) for
notifications of queries
• More efficient tracking of requests related to
the same project; link query “history”
• IT Support for site-specific issues
12
Websites and References
• https://healthdatacollaboration.net/
– CRNnet
– HMORNnet
– SPAN (archived)
– Others
• http://crn.cancer.gov/
– Cancer Research Network
13
Contact Info
• CRN - [email protected]
• Technical Lead for SAS Distribution update
– David Tabano, KPCO Institute for Health Research
• [email protected]
• 303-614-1348
• Program Lead
– Heather Clancy, KPNC Division of Research
• [email protected]
• 510-891-3663
14