Dear friends,
I have data split into 4 columns: diagnosis1, diagnosis2, diagnosis3,
diagnosis4. Each column may have a unique value upto code 15 and a
code cannot be repeated in any of the four columns. Unique records are
defined by date of diagnosis and a unique patient code. Thus a patient
can have 3 conditions in one visit. I then want a simple crosstab to
summarise the data in, say 2 columns (Diagnosis and Date) such that if
one record has 3 codes in one date, access should split the 3 record
into 3 rows. From there I can have a crosstab of Diagnosis by Date. If
I were using SPSS, it would be easy for me to just create a multiple-
response group out of diag1, diag2, diag3, diag4 and crosstabulate it
with date. Anyone out there kind enough to assist?
Will be most grateful.
|
Similar Threads
