Transcript Slide 1

MDR Training
June 4, 2012
Keith Hofmann
Purpose and Objective
•
Purpose
•
•
To provide a detailed training on the use of the MHS Data
Repository
Objectives: Attendees will be able to:
•
•
•
•
•
Access the BEA website, and use the MDR Data Dictionary
and MDR Functional Specifications to inform programming
Sign on to the MDR
Navigate the MDR using UNIX commands
Use the PICO editor to write SAS programs
Run SAS programs, debug syntactical and logical errors, and
perform Quality Control checks
FOR OFFICIAL USE ONLY
2
What is the MDR?
•
•
•
MDR: Military Health System Data
Repository
“Home Grown” Data Warehouse initially
intended for internal use
Data from throughout the enterprise
(CHCS, DEERS, PDTS, Claims, etc.)
available to analysts via SAS
FOR OFFICIAL USE ONLY
3
BEA Website
•
http://www.tricare.mil/ocfo/BEA/functional_specs.cfm
•
Home to:
•
•
•
•
•
MDR Data Dictionary
MDR Functional Specifications
Interface Control Documents
MDR Users Guide
MDR Functional Guide
FOR OFFICIAL USE ONLY
4
BEA Website Screenshot
<-Specs
FOR OFFICIAL USE ONLY
5
M2 Tables and Their MDR
Equivalents
M2 Class
Eligibility
MDR Equivalent
Population Summary (DEERS)
DEERS Person Detail
Longitudinal Eligibility
MCFAS
/mdr/pub/deers/summary/vm6agg/fyXX/fmZZ/popagg.sas7bdat
/mdr/pub/deers/detail/vm6ben/fyXX/fmZZ.txt.Z
/mdr/pub/deers/lelg/vm6lelg/fyXX.sas7bdat
/mdr/pub/mcfas/fyXX/mcfaspop.sas7bdat
Reservists
/mdr/pub/reservist/reservist.sas7bdat and
/mdr/pub/reservist/legacyreservist.sas7bdat
TRICARE Relationships (DEERS)
Relationship Detail
Health Care Services
Case Management
Dental
Direct Care Dental
/mdr/pub/deers/enr/vm6enr/fyXX/fmZZ.sas7bdat
/mdr/pub/casemgmt/cm.sas7bdat
/mdr/pub/dental/ded/fyXX/fyXX.sas7bdat
Purchased Care Dental
/mdr/pub/dental/tdp/claims/fyXX.sas7bdat and
/mdr/pub/dental/addp/claims/fyXX/fyXX.sas7bdat
Direct Care
Ancillary Services
Laboratory Detail and
Radiology Detail
Appointment Detail
Inpatient Admissions (SIDR)
Inpatient Admissions Detail
Professional Encounters (CAPER)
CAPER Detail
Professional Encounters (SADR)
Professional Encounters Detail
Purchased Care
Institutional (HCSR/TED)
Institutional Detail
Non-institutional (HCSR/TED)
Non-institutional Detail
Pharmacy (PDTS)
PDTS Detail
Referrals
System Production (MEPRS/WWR)
MEPRS
MEPRS Personnel Detail
WWR
Reference Tables
DMIS ID Table
/mdr/pub/ancillary/fyXX/ancillary.fyXX/fyXX.sas7bdat
/mdr/pub/appt/detail/fyXX/fyXX.sas7bdat
/mdr/pub/sidr/fyXX/sidr.fyXX/fyXX.sas7bdat
/mdr/pub/caper/enhanced/fyXX.sas7bdat
/mdr/pub/sadr/fyXX.sas7bdat
/mdr/pub/tedi/fyXX/header.sas7bdat
/mdr/pub/tedni/fyXX/champus.sas7bdat and
/mdr/pub/tedni/fyXX/tdefic.sas7bdat
/mdr/pub/pdts/detail/fyXX/pdts.detail.fyXX.txt.Z
/mdr/pub/referral/referral.sas7bdat
/mdr/pub/eas4/fyXX/eas4.fyXX/fyXX.sas7bdat
/mdr/pub/eas4/personnel/fyXX/eas4.personnel.fyXX/fyXX.sas7bdat
/mdr/pub/wwr/fyXX/wwr.fyXX/fyXX.sas7bdat
/mdr/ref/dmisid.index/fyXX.sas7bdat or
/mdr/ref/dmisid.index.fyXX.txt
FOR OFFICIAL USE ONLY
6
Other Useful MDR Files
DEERS Longitudinal Enrollment
SIDR Completion Factors
TEDI Completion Factors
TEDN Completion Factors
TED Provider
CDR Vitals
CDR Immunizations
CDR Historical Procedures
CDR Medications Fills and Results
CDR Lab Chemistry Results
MEPRS Ancillary
MEPRS Expense Detail
MEPRS Workload Detail
Designated Provider
Active Duty Dental (ADDP)
Direct Care Dental (DED)
TRICARE Dental Program (TDP)
/mdr/pub/deers/lenr/vm6lenr/fyXX.sas7bdat
/mdr/pub/sidr/compfac/fyXX/sidr.compfac.fyXX.txt.Z
/hpae2/kennell/ref/ibnrinst.fmt
/hpae2/kennell/ref/ibnrnon.fmt
/mdr/pub/tedpr/tedpr.sas7bdat
/mdr/pub/cdr/vitals/fyXX.sas7bdat
/mdr/pub/cdr/imm/immunizations.sas7bdat
/mdr/pub/cdr/procedures/histproc.sas7bdat
/mdr/pub/cdr/med/fyXX/fills.sas7bdat
/mdr/pub/cdr/med/fyXX/orders.sas7bdat
/mdr/pub/cdr/chem/fyXX.sas7bdat
/mdr/pub/eas4/ancillary/fyXX/eas4.ancillary.fyXX/fyXX.sas7bdat
/mdr/pub/eas4/exp_detail/fyXX/eas4.exp_detail.fyXX/fyXX.sas7bdat
/mdr/pub/eas4/wk_detail/fyXX/eas4.wk_detail.fyXX/fyXX.sas7bdat
/mdr/pub/desprov/fyXX/clin.sas7bdat
/mdr/pub/dental/addp/claims/fyXX/fyXX.sas7bdat
/mdr/pub/dental/ded/fyXX.sas7bdat
/mdr/pub/dental/tdp/claims/fyXX.sas7bdat
FOR OFFICIAL USE ONLY
7
OOB
•
OOB: Out of Band
Users not behind a *.mil network will have to use this
to access the MDR
Requires CAC
•
https://vpn.csd.disa.mil/dana-na/auth/url_default/welcome.cgi
•
•
FOR OFFICIAL USE ONLY
8
OOB Screenshot
The yellow lock means you are connected
FOR OFFICIAL USE ONLY
9
WinSCP
•
•
•
Used for transferring
files between your
computer and the
MDR
Some prefer to use this
for editing programs
Cannot submit
programs
FOR OFFICIAL USE ONLY
10
PuTTY
•
•
•
Used for submitting programs
UNIX based (must be
navigated using keyboard
commands)
Mouse can be used for copy
and paste (highlight to copy,
right click to paste)
FOR OFFICIAL USE ONLY
11
UNIX Commands
cd – Change Directories. Used to navigate among directories (like folders)
pwd – Print Working Directory. Shows what directory you are in (where am I?)
ls – LiSt. Shows contents of the working directory
mkdir – MaKe DIRectory. Creates a new directory
chmod – CHange MODe. Change the permissions on a directory or file
cp – CoPy. Copy files or directories within or across directories
mv – MoVe. Move or rename files or directories within or across directories
rm – ReMove. Delete files.
•
•
•
•
•
•
•
•
•
•
•
•
•
rmdir – ReMove DIRectories. Delete directories (directory must be empty)
pico – PICO. Open PICO text editor
more – Open one page of a file at a time. Use Enter to navigate one line at a time and
Space to navigate one page at a time. Useful for examining large files
tail – View last 10 lines of a file. Useful for examining large files. Can be used in
tandem with more to look at sections of a file besides the beginning and end.
gzip/gunzip – Use GZip to compress or uncompress files
FOR OFFICIAL USE ONLY
12
Using UNIX Commands
FOR OFFICIAL USE ONLY
13
PICO Editor
Use Control Key + a letter
to use the commands at
the bottom
•
•
•
•
•
•
FOR OFFICIAL USE ONLY
ctrl+x = “Exit”. Leave
PICO editor
ctrl+o = “WriteOut”. Works
like “Save As” in Windows
ctrl+k and ctrl+u = “Cut
Text” and “UnCut Text”.
Can be used to cut and paste
text, one or more lines at a
time
ctrl+w = “Where is”. Works
like “Find” (ctrl+f) in
Windows
ctrl+a and ctrl+e: Goes to
the beginning or the end of
the line
14
SAS
•
•
SAS (formerly Statistical Analysis Software) is the
programming language used to access the data on the
MDR
SAS programs have three basic sections
1.
2.
3.
UNIX Housekeeping. This contains libname and filename
statements, detailing where files are to be read from or written to.
The Data Step(s). This is the meat of a SAS program. Files are
read in one record at a time, and the data can be manipulated
using math, functions, formulas and other techniques. Multiple
data sets can be read in or written out simultaneously
Procedures. These are canned processes available in SAS that can
produce reports and summaries or manage data files
FOR OFFICIAL USE ONLY
15
Proc Examples
proc contents – lists the contents of libraries and data sets, and provides
general information about their size and other characteristics
proc datasets – provides library management functions (e.g. deleting data
sets)
proc sort – sorts observations in a SAS data set by one or more variables
proc print – prints the observations in a SAS data set, using all or some of
the variables
proc freq – produces one-way or many-way frequency and cross-tabulation
tables. Very useful for QC purposes.
proc summary – computes descriptive statistics on numeric variables and/or
aggregates data across one or more stratifications
•
•
•
•
•
•
•
•
•
proc means – same purpose as “proc summary”, but slightly different syntax
proc format – allows creation of formats for character or numeric variables.
Can be used like VLOOKUP in Excel
proc append – adds data sets together
FOR OFFICIAL USE ONLY
16
Submitting a Program
To stop a running program:
FOR OFFICIAL USE ONLY
17
Hands On

Powerpoint Presentations are boring, so let’s get our
hands dirty and get on the MDR!
FOR OFFICIAL USE ONLY
18