Data exraction
I am extracting data on the operative procedure (specifically, amputation). How can I extract the corresponding specific date of operation? There are several arrays on the date of operation; which array can I select
I am extracting data on the operative procedure (specifically, amputation). How can I extract the corresponding specific date of operation? There are several arrays on the date of operation; which array can I select
Comments
1 comment
Hi George,
Thank you for your query. Data field 41282 is a summary field that provides the date of operative procedure. Within the ‘notes’ tab, you will see that this can be linked to field 41272 using the array column. I would suggest the easiest way to combine these would be to extract all data for both of these fields, then perform a full join between them, using the eid, instance, and array column. From here you will then be able to filter for the OPCS4 codes of interest.
I hope this helps.
Kind regards,
Anna
Please sign in to leave a comment.