-
hcup-us.ahrq.gov/reports/methods/MS2003-02%20Addendum.pdf
December 10, 2022 - SAS Example 1
/* Create test file with three new data elements. */
data test;
set nis2019.NIS … sums, means, and standard errors for three data elements defined above. */
proc surveymeans data=test … sums, means, and standard errors for three data elements defined above. */
proc surveymeans data=test
-
hcup-us.ahrq.gov/tech_assist/standarderrors/508/508course_2016.jsp
January 01, 2016 - Subsets: Alternate Method Results
Verification of Results
Significance Testing
Using the Z-Test … Calculator
Z-Test Calculator LOS
Z-Test Calculator Trend
Wrap-Up
Key Points
Resources … The Z-Test calculator is a convenient way to do just that. … The Z-test calculator allows you to test the significance of the difference between two weighted counts … Return to Contents
Z-Test Calculator LOS
To test if the length of stay of a discharge with a principal
-
hcup-us.ahrq.gov/datainnovations/clinicaldata/FL20LOINCIntroductionHammond.jsp
December 20, 2010 - Observation Identifiers Names and Codes (LOINC®)
Has two sections
Laboratory portion
Standard test … Format is nnnnn-n where the last n is a mod 10 check digit
Each LOINC record corresponds to a single test … CAP
ACLA
Most clinical laboratories
Most major medical centers
US government (for laboratory test … do a single mapping
Normal Limits
A challenging problem when the normal limits for the same test … HL7 has endorsed the use of certain terminologies for specific purposes
LOINC for laboratory test
-
hcup-us.ahrq.gov/datainnovations/clinicalcontentenhancementtoolkit/mn4.jsp
August 01, 2014 - Platelet count
Prothrombin time
White blood count
Slide 7
Examples of LOINC Coding
Test … principal diagnosis
procedure
age group
Each row will contain information about a single lab
test … assistance as needed
Slide 12
Transmission & Analysis of Lab Data
Hospitals will submit a test … samples of lab data to the
project team
Project team will analyze test data and work with individual
-
hcup-us.ahrq.gov/datainnovations/clinicaldata/AHRQHCUP11182009CSullivanFinal.pdf
November 01, 2009 - Chloride Platelets Date of specimen Run
CPK MB PO2.sat Time of Specimen Run
Creatinine Potassium Type of test … performed
Gamma glutamyl
transferase
Prothrombin time Reference range of test
Agency for Health … Florida Center for Health Information and Policy Analysis
Lab Result Interface Code Comparisons
Lab Test … Florida Center for Health Information and Policy Analysis
Lab Result Interface Code Comparisons
Lab Test … for Health Information and Policy Analysis
Blood Culture Laboratory Data
LOINC Name
LOINC
Code
Test
-
hcup-us.ahrq.gov/db/nation/kid/tools/stats/KID_2019_MaskedStats_Hospital_V2.PDF
January 01, 2019 - 5949738851.98
Mode 16,617.00 Range 326,200.00
Interquartile Range 66,824.00
Tests for Location: Mu0=0
Test … Variance 4,754.44
Mode 280.00 Range 278.00
Interquartile Range 88.00
Tests for Location: Mu0=0
Test … 1017653355.12
Mode 5,672.00 Range 137,907.00
Interquartile Range 26,343.00
Tests for Location: Mu0=0
Test … Variance 2,013.90
Mode 106.00 Range 193.00
Interquartile Range 65.00
Tests for Location: Mu0=0
Test … 17,557,185.23
Mode 1,032.00 Range 17,091.00
Interquartile Range 4,077.00
Tests for Location: Mu0=0
Test
-
hcup-us.ahrq.gov/datainnovations/clinicalcontentenhancementtoolkit/hi31.pdf
March 23, 2010 - Application
*Account Number Create Date/Time
*Medical Record Number Patient Class
*DOB Hospital Test … (Order)
Gender Hospital Test Result (LOINC)
*SSN Observation Date/Time
*Patient First Name Results … CY2008-2011
9,450,293
Excluded
Not one of the 32;
Outside study period
Missing identifiers; test
-
hcup-us.ahrq.gov/datainnovations/clinicaldata/AppendixK_2LOINCCodesMap.jsp
October 02, 2010 - Site:
Date Completed:
Completed by:
Template
TO BE COMPLETED BY LABORATORY
Test … #
Laboratory Test Name
Specimen Type
Units
LOINC Code
LOINC Name
Comments
Specimen Type …
Additional Tests
Site:
Date Completed:
Completed by:
Additional Tests
Test … #
Laboratory Test Name
Specimen Type
Units
Normal Range
Method
Comments
… #
Laboratory Test Name
LOINC Code
Specimen Type
Units
Normal Range
Method
Comments
-
hcup-us.ahrq.gov/db/nation/neds/stats/NEDS_2019_Hospital_MaskedStats.PDF
January 01, 2019 - Variance 2.29329
Mode 6.026003 Range 14.13347
Interquartile Range 1.47548
Tests for Location: Mu0=0
Test … Variance 0.57520
Mode 5.000000 Range 4.00000
Interquartile Range 0.30481
Tests for Location: Mu0=0
Test … Variance 2.38405E12
Mode 1384450 Range 7007223
Interquartile Range 1651096
Tests for Location: Mu0=0
Test … Variance 4032
Mode 244.0000 Range 242.00000
Interquartile Range 86.00000
Tests for Location: Mu0=0
Test … Tests for Location: Mu0=0
Test Statistic p Value
Student's t t 30.56502 Pr > |t| <.0001
Sign M 494.5
-
hcup-us.ahrq.gov/db/nation/neds/stats/NEDS_2018_Hospital_MaskedStats.PDF
January 01, 2018 - Variance 1.78273
Mode 6.225576 Range 9.60770
Interquartile Range 1.49968
Tests for Location: Mu0=0
Test … Variance 0.46335
Mode 5.000000 Range 4.00000
Interquartile Range 0.25225
Tests for Location: Mu0=0
Test … Variance 2.10233E12
Mode 1327741 Range 6778351
Interquartile Range 1546898
Tests for Location: Mu0=0
Test … Tests for Location: Mu0=0
Test Statistic p Value
Student's t t 39.23995 Pr > |t| <.0001
Sign M 495 … Tests for Location: Mu0=0
Test Statistic p Value
Student's t t 26.7266 Pr > |t| <.0001
Sign M 495
-
hcup-us.ahrq.gov/datainnovations/clinicalcontentenhancementtoolkit/ny8.pdf
April 29, 2014 - data with an extra column
for the MRN formatted for your
system.
2 DOH will send a list of 30 lab test … Send all test results for the
patients; NYSDOH will delete
those not needed for the study.
3
Hospital … If selection by lab test is a
problem, we will accept ALL
results for the patients on the
list.
-
hcup-us.ahrq.gov/datainnovations/clinicaldata/AHRQHCUP11182009CSullivanFinal.jsp
April 01, 2011 - laboratory data with the administrative data, to assess the quality of patient care within hospitals and to test … blood cell count
Additional Data Elements
Date of Specimen Run
Time of Specimen Run
Type of test … performed
Reference range of test
Lab Result Interface Code Comparisons
Lab Test Name … the sample
QN is the scale
EIA is the method
Lab Result Interface Code Comparisons
Lab Test … 7-18
2007-04-14
07:05
Blood Culture Laboratory Data
LOINC Name
LOINC Code
Test
-
hcup-us.ahrq.gov/db/nation/nrd/stats/MaskedStats_NRD_2019_Hospital_V2.PDF
January 01, 2019 - Variance 4.37065E11
Mode 194565.0 Range 3360059
Interquartile Range 542046
Tests for Location: Mu0=0
Test … Variance 6456
Mode 164.0000 Range 346.00000
Interquartile Range 64.00000
Tests for Location: Mu0=0
Test … Variance 9.77728E10
Mode 67189.0 Range 1422294
Interquartile Range 317163
Tests for Location: Mu0=0
Test … Variance 1074
Mode 41.00000 Range 131.00000
Interquartile Range 32.00000
Tests for Location: Mu0=0
Test
-
hcup-us.ahrq.gov/datainnovations/clinicalcontentenhancementtoolkit/hi9.jsp
August 01, 2014 - of the three above, specify lab or vendor)
Hospital/Vendor Completing Report:_____
Lab Test … Lab Test Name
LOINC
Units
Vendor
Chemistry
Albumin
Albumin
1751-7
g/dL
-
hcup-us.ahrq.gov/datainnovations/clinicalcontentenhancementtoolkit/ny14.pdf
March 20, 2012 - The following laboratory test results will be requested from participating hospitals:
1. … Inhaled oxygen (percent)(rate)
Data elements that will be requested for each test are: … A LOINC code to identify the type of test performed
The observation value (i.e., test result … )
The observation units
The normal range for the patient on whom the test was performed
The … Hospital-specific codes identifying laboratory test
results requested for this project will be mapped
-
hcup-us.ahrq.gov/datainnovations/clinicalcontentenhancementtoolkit/mn5.pdf
June 21, 2014 - to submit data from
electronic repositories using established data
specifications and formats
• Test … data submissions to validate protocols• Test data submissions to validate protocols
• Transmit data … assistance as needed
9
Future Collection and Use of Drug Datag
• A principal goal of this project is to test
-
hcup-us.ahrq.gov/datainnovations/clinicalcontentenhancementtoolkit/about_grants_cd.jsp
July 01, 2016 - , 550 KB; HTML )
Document that details the grantee's experience linking 32 specific laboratory test … user identify the vendor or internal hospital operation responsible for reporting the results of each test … common lab tests and asks the hospital to provide specimen type, units, normal range, etc. for each test … Lab Tests Desired for AHRQ Project ( XLS file, 33 KB; HTML )
Spreadsheet that lists lab test … Another goal of the project was to determine whether laboratory test results will enhance the ability
-
hcup-us.ahrq.gov/datainnovations/clinicalcontentenhancementtoolkit/mn13.jsp
September 01, 2014 - Lab TESTS Desired for AHRQ PROJECT
Lab TESTS Desired for AHRQ PROJECT
Test … #
Laboratory Test Name
Specimen Type
Units
LOINC Code*
LOINC Name
1
Albumin
Serum
-
hcup-us.ahrq.gov/datainnovations/clinicalcontentenhancementtoolkit/ny14.jsp
September 01, 2014 - The following laboratory test results will be requested from participating hospitals:
Albumin
… Urea Nitrogen Blood (BUN)
White Blood Count
Data elements that will be requested for each test … are:
A LOINC code to identify the type of test performed
The observation value (i.e., test result … )
The observation units
The normal range for the patient on whom the test was performed
The date … Hospital-specific codes identifying laboratory test results requested for this project will be mapped
-
hcup-us.ahrq.gov/db/vars/i10_dxn/nedsnote.jsp
May 10, 2015 - EAGE05, EDX03
Top
State Specific Notes
California (SID)
HIV Test … Result Diagnoses
California law prohibits the release of HIV test results in patient-identifiable … Therefore, records that include certain ICD-10-CM codes that indicate HIV test results were not included … have been due to a practice in California that actively discourages the reporting of codes for HIV test