You can create new, temporary files with the values for each ‘diag’ as a new variable like this: * EpiData Analysis V2.2 syntax! * adiag will hold all diagnoses eventually define adiag #### * get all first diagnoses adiag = diag * save all records with non-missing diag1 select adiag <> . savedata diag1.rec /replace select * save all records with non-missing diag2 adiag = diag2 select adiag <> . savedata diag2.rec /replace … savedata diag6.rec /replace close * read / append all temporary files read "diag1.rec” append /file="diag2.rec” … append /file="diag6.rec” * get overall frequencies freq adiag
Jamie
On Nov 25, 2017, at 07:18, EpiData development and support epidata-list@lists.umanitoba.ca wrote:
Dear Epidata Team, We have a patients database. A patient can have multiple diagnosis. Hence these are the numerically coded variables defined for dataentry of Diag, Diag2, Diag3, Diag4, Diag5, Diag6. Of course one can FREQ the Individual 'diag'; and see the individual diagnosis pattern. However if one wants to see the pattern of common diagnostic combinations observed in all the patients, is there any way out? Dr. Shavinder Singh _______________________________________________ EpiData-list mailing list EpiData-list@lists.umanitoba.ca http://lists.umanitoba.ca/mailman/listinfo/epidata-list