Does anyone know how to extract ICD-8 and 10 codes from data using SAS? I want to extract causes of death and categorise them into explained and unexplained.
I'm not sure that I understand your question but we do some similar types of things with ICD-9 codes. It's first necessary to add the full text description to the file and then search for key words using the SAS substr or similar function. Once the list is of manageable size, I might order by frequency, and then evaluate each description to create you categories... but I could be misunderstanding your question.
I'm not sure that I understand your question but we do some similar types of things with ICD-9 codes. It's first necessary to add the full text description to the file and then search for key words using the SAS substr or similar function. Once the list is of manageable size, I might order by frequency, and then evaluate each description to create you categories... but I could be misunderstanding your question.
It shouldn't be too complicated with SAS, but I think that I didn't fully understand your question either, you're trying to see if the cause of death variable(s) have a real ICD10 code as opposed to some other diagnosis and then basically separate the ICD10 codes (explained) from the diagnoses that don't match a real code (unexplained)? If this is the case, I think you would have to follow the approach explained in the answer above.
Hi Mark and Yuri. I think I have since sorted this. I need to catergorise the causes of stillbirth into explained and unexplained to do a competing risks analysis. I will be given one variable (eg. All_Causes) which will consist of the many ICD-8 and ICD-10 codes for each particular cause of stillbirth. I think what I need to do is simply say if All_Causes = XX, or XX or XX then Explained= 1; Else Explained=0 (with XX being the different ICD codes). And then do the same for unexplained causes. Does this make sense?!
Also, the SAS substr function...... is this a way of extracting particular 'words' from within a variable? So could I otherwise use this to extract the ICD codes?
This will be a labor intensive process no matter how you approach it. I would begin by listing the text descriptions in frequency order and see if you identify key words in the text that would allow you to assign explained or unexplained status. Once you have those key words, then search the text in all the codes using the SUBSTR or similar function (if you don't already have it the book "SAS functions by example" describes all the string functions that might be useful for you). Hopefully you won't have any codes that have key words for both categories. Once that's settled it should be a simple matter to make the assignments.
I agree with Mark's method, you can get the list of descriptions for all codes. The problem is that although the code might be I744, sometimes it is I744-, so you normally use SUBSTR(DIAG_1,1,4) ="I744" to play only with the first 4 characters. I have worked with causes of death and sometimes are not so reliable, so you might want to check all causes of death rather the main one. If the patient had AIDS, and he died because of Pneumonia, should they put that he died because of AIDS or Pneumonia as main cause? There are many examples like that and some things that might not be coherent.
For your if statement you can use IN. Something like
IF SUBSTR(COD,1,4) IN ("I711","I722","I734") THEN explained_flg=1;
If you have a whole set of disease under the same codes, for instance I71x, then you could use SUBSTR(COD,1,3) = "I71" to save your time.
your suggestion (IF SUBSTR(COD,1,4) IN ("I711","I722","I734") THEN explained_flg=1) does not work, it only works for numerical codes. I think we need a command that differentiates numerical from alphabets variables.
just wondering if anyone has an idea for identifying ICD 10 codes that start with a letter.
23 may. 2013 - This will be a labor intensive process no matter how you approach it. I would begin by listing the text descriptions in frequency order and see if ...
ICD 10 - ResearchGate
https://www.researchgate.net/topic/icd
Traducir esta página
Using OPCRIT to produce ICD-10 diagnoses is useful for the major psychotic .... How to extract ICD-8 and ICD-10 codes from a large dataset using SAS?
[PDF]Using SAS Software to Aid in the ICD10 Code Set Implementation
Using SAS® Software to Aid in the ICD-10 Code Set Implementation ... Much of this work utilizes the CSMC-wide Data Warehouse (DW), a large relational.
[PDF]Using SAS to Map ICD-8, ICD-9 and ICD-10 Codes
www.lexjansen.com/scsug/2006/ThompsonAngela.pdf
Traducir esta página
Using SAS to Map ICD-8, ICD-9 and ICD-10 Codes to Common Codes ... overcome this problem while analyzing cancer deaths among a large cohort of men with .... Analysis. Dataset. Cohort, n=2,699 men with diabetes. Mortality surveillance.
Assessing Validity of ICD-9-CM and ICD-10 Administrative Data in ...
www.ncbi.nlm.nih.gov › ... › Literature › PubMed Central (PMC)
Traducir esta página
de H Quan - 2008 - Citado por 242 - Artículos relacionados
Each code in ICD-10 starts with a letter (i.e., A–Z), followed by two numeric digits, ... the SAS functional command of “substr” to truncate the length of ICD-10 codes in the ... Of the 32 conditions extracted from these 70 charts, 17 conditions had near .... in both datasets (85.8 percent in ICD-9-CM and 85.3 percent in ICD-10).
Introducing icd9: working with ICD-9 codes and comorbidities in R
14 abr. 2016 - Since some data is provided in SAS source code format, this ... Quan's paper looked at indices using both ICD-10 and ICD-9-CM. .... [7] "Hypertensive heart and chronic kidney disease" #> [8] "Other acute ... Don't want to stress CRAN, so no larger numbers demonstrated, but I do consistently get about 5 ...
[PDF]ICD9 ICD10 comparability file documentation - Centers for Disease ...
Documentation for the Public Use Multiple Cause of Death .... A sample program that converts the resulting ASCII file into a SAS database has been ... verify that their hardware and software can manage the relatively large files included in ... constructed using ICD-10 codes (e.g., the List of 113 selected causes of death).
Implementation of ICD-10 in Canada: how has it impacted coded ...
de RL Walker - 2012 - Citado por 9 - Artículos relacionados
The average number of diagnoses coded per hospital visit for all code types over the ... In conclusion, implementation of ICD-10-CA in Canadian provinces did not ... [6, 7, 8]. However, the use of these data for research purposes (i.e.purposes other than ... The HPOI is a person-level dataset derived from discharge records of ...
[PDF]Using SAS Macros To Flag Claims Based On Medical Codes
Many epidemiological studies use medical claims to identify and describe a ... dataset contains two types of codes, HCPCS codes and ICD-9 procedure .... 0. 0. 005. 99201. 991. 0. 0. 0. Table 8. CLAIMS dataset, before flagging (ex. 3) ... Note that SAS macros can call other macros, so another macro could be used for large ...
[PDF]ICD_CLASS SAS® Software User's Guide Version FY 2016 - National ...
payment calculations using ICD-10-CM/PCS codes, even though they are .... Extract the content of the zip file to the created directory. ... The macro requires one permanent SAS data set with coded data from a health .... WARNING: if you are working with a large dataset, choosing ..... 8 diagnoses were used for classification.