topic Re: multiple diagnoses in SAS Health and Life Sciences

multiple diagnoses

Marilyn — Wed, 15 Apr 2009 15:35:32 GMT

Does someone already have some generic code that will pull patients with several ranges of diagnoses from a file that records up to 10 diagnoses at a time?
i.e. I want to pull any patient that had dx 345.00-345.99, or 346.0-346.9, or 296.0-296.9 from multiple years...

Re: multiple diagnoses

LinusH — Thu, 16 Apr 2009 07:20:20 GMT

I don't have any generic code, but it will help to give some hints if you could show the record lay-out, and some sample data.

/Linus

Re: multiple diagnoses

Marilyn — Thu, 16 Apr 2009 13:12:53 GMT

There's just generic information like name, ssn, diag1 - diag10, DOV, etc...

Re: multiple diagnoses

Doc_Duke — Thu, 16 Apr 2009 13:50:01 GMT

No code, but some comments. This looks like Medicare billing data since there is a limit of 10 diagnoses. The size of some of these datasets can be huge, so some approaches (like TRANSPOSE) that are effective for smaller datasets run out of computer resources with larger ones.

ICD codes are character strings, not numbers, so trying to specify a range is tricky (e.g. ICD 345.1 is different from ICD 345.10). If you are just interested in the summary at the first three digits, use the SUBSTR function or the =: operator for the comparison, e.g.
IF diag1 =: '345' | diag1=:'346'...
or
SELECT ...
WHERE substr(diag1,1,3) IN ('345', '346', '296') | ...

Re: multiple diagnoses

Marilyn — Thu, 16 Apr 2009 13:55:56 GMT

yes...this works quite well.
Now I am working on trying to make an array of the diagnosis codes...

Re: multiple diagnoses

deleted_user — Wed, 01 Jul 2009 20:33:31 GMT

try the following where clause through an sql query:

where
(Diag_Code___Prin between '001' and '00999'
or Diag_Code___Prin between '033' and '03399'
or Diag_Code___Prin in ('V016','V027','V028')

or Diag_Code___Secondary_1 between '001' and '00999'
or Diag_Code___Secondary_1 between '033' and '03399'
or Diag_Code___Secondary_1 in ('V016','V027','V028')

or Diag_Code___Secondary_2 between '001' and '00999'
or Diag_Code___Secondary_2 between '033' and '03399'
or Diag_Code___Secondary_2 in ('V016','V027','V028'))

Re: multiple diagnoses

shellp55 — Thu, 23 Jul 2009 23:23:50 GMT

Hi

Actually I have a similar type format for diagnoses (except it goes to 25) and I create the array of:

array diagcde[25] $ diagcde1-diagcde25;

Then when searching for specific codes I indicate:

do i=1 to 25 until (diagcde = ' ');
if diagcde in substr(diagcde,1,3) in ("C00","C01") then .