(no subject)

[Suh-Ing Amy Hsieh]

Hi listers:



I am so sorry for
the prior posted information. I do my best to explain it.



The original big
claims data (hospitalization) are “dd2001, dd2002, dd2003, dd2004,
dd2005, and dd2006.” They are monthly claims data and have same
variables. If patients were hospitalized longer than the monthly reporting
date, the claims data had ³ 1 record for the patients
at the same admission and discharge dates. I saw one patient (identified
by id, birthday, in_date, and out_date) who was hospitalized for
³ 1 year, the claims data had around 12 records (or lines or
rows) at the same date of admission (e.g., 20010101) and discharge (e.g.,
20020202). In_date is the admission date and the out_date is discharge
date.







My target population
is adults (³ 18 years) with
hematological cancers receiving bone marrow transplant (BMT) from 2001 to
2005. First, I have selected hematological cancers from dd2001 to dd2006
using ICD-9-CM diagnostic codes (from icd9cd to icd9cd4) and added annual
data set as DATA1. Second, I have limited the target population to
patients undergoing BMT using 10 ICD-9-CM procedure codes (from icdopcd to
icdopcd4). 10 ICD-9-CM procedure codes for BMT are from 4100 to 4109. Third, I
converted birthday and admission dates and calculated ages. Fourth, I
recoded age into 2 groups and selected age ³ 18 years old.  Fifth, I have created an index
dd2001_2006 using aggregating (selecting the first record and last record
and summing different fees) and merging functions (adding cases
again).  Thus, DATA1 is an
index dd2001_2006 and only 1 record per patient. If patients had received
2nd, 3rd, 4th, or subsequent BMT, those
variables will be added to the DATA1 using different names of
variables.  It is occasionally
hard to judge the admission date only for BMT due to coding problems so
that I need pre-BMT chemotherapy records for checking and making decisions
(exclude or not exclude patients).







2 outcomes are
overall survival (from Jan 1, 2001 to Dec 31, 2005) and 30 day readmission
of discharge. The variables of death and date of death have existed in the
DATA1 for several patients because patients have died during BMT. Thus,
the variables of overall survival for remaining patients, who survive
during BMT, will be obtained from dd2001 to dd2006. Also, the variable of
with readmission or without readmission will be obtained from dd2001 to
dd2006 again. Hence, I have created syntax for selecting those adult
patients undergoing BMT using their unique ID (32 length) and saved as
“DATA2.” However, data2 include all records (rows) with
respect to pre-, during, and post-BMT records.  I am thinking how to create syntax for keeping pre-BMT
chemotherapy records as one dataset and post-BMT records as one dataset or
dropping BMT records from DATA2.
The key variables for identifying pre-, during, or post-BMT are
each admission date and discharge date from dd2001 to dd2006, although
patients have same id and birthday. The in_date and out_date of pre-BMT
records occur before in_date and out_date of BMT procedures, whereas the
in_date and out_date of post-BMT occur after in_date and out_date of BMT
procedures. Please see below examples:










DATA1 (Index
dd2001_2006 à only BMT records):



id
id_sex
birthday
in_date

1122ab33c5..   F       19580210
20011215




1134ac34c6..   M       19751122
20050719



2456b578ef..   F       19690516
20030113



ab2457cdg3..   M       19501030
20050413








out_date
e_bedd   tran_cd   icd9cd    icd9cd1  icdopcd



20020208
48
1       20500   6822    4103



20051130
134
4       20153   99685   4105



20030204
22
3       20021   2880    8607



20050720
98
3       20500   2880    9925







icdopcd1
dx_am
room_am
drug_am
med_am…
9925
11664
44160
315227
473461



8607
69120   904218
722973         2579172



4101
11897   137262
138717         378661



4105
40099 358053
831632
1482244





Please show me how to create syntax for keeping pre-BMT
and post-BMT records as two separated files. Thank you so much.
Amy Hsieh

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD