Hello everyone.
I have a problem working on my dataset. I am trying to prepare the data for analysis and my dataset includes variables such as procedure1, procedure2, procedure3, etc., and each "procedure" contains different ICD10PCS codes for each patient. I have created a separate variable that includes only those ICD10PCS codes that refer to PCI procedures.
icd10pcs generate insamplePCI1 = procedure1 , range(0270346 02703D6 027034Z 02703DZ 02703Z6 02703ZZ 0270446 027044Z 02704D6 )
icd10pcs generate PCIprocedure1 = procedure1 if insamplePCI1 ==1, description addcode(begin)
Now I have variables PCIprocedure1-20 that extracted data (only PCI procedures of interest) from every procedure1-20
And here is the problem. I need to combine all the data from PCIprocedure1-20 that have similar ICD10PCS codes into one variable like PCIprocedureOverall for further analysis.
I want this new variable PCIprocedureOverall to include all the ICD10PCS procedures that were extracted (0270346 02703D6 027034Z 02703DZ 02703Z6 02703ZZ 0270446 027044Z 02704D6), and I need to combine similar procedures into one.
icd10pcs lookup 0270346 02703D6 027034Z 02703DZ 02703Z6 02703ZZ 0270446 027044Z 02704D6
027.0346 Dilate 1 Cor Art, Bifurc, w Drug-elut Intra, Perc
027.034Z Dilation of 1 Cor Art with Drug-elut Intra, Perc Approach
027.03D6 Dilate 1 Cor Art, Bifurc, w Intralum Dev, Perc
027.03DZ Dilation of 1 Cor Art with Intralum Dev, Perc Approach
027.03Z6 Dilation of 1 Cor Art, Bifurc, Perc Approach
027.03ZZ Dilation of Coronary Artery, One Artery, Perc Approach
027.0446 Dilate 1 Cor Art, Bifurc, w Drug-elut Intra, Perc Endo
027.044Z Dilate of 1 Cor Art with Drug-elut Intra, Perc Endo Approach
027.04D6 Dilate 1 Cor Art, Bifurc, w Intralum Dev, Perc Endo
So, as you can see there are several types of PCI procedures and they are the same for each PCIprocedure1-20. I need to combine similar types of PCI from every group.
Which command can I use?
Thank you in advance.
I have a problem working on my dataset. I am trying to prepare the data for analysis and my dataset includes variables such as procedure1, procedure2, procedure3, etc., and each "procedure" contains different ICD10PCS codes for each patient. I have created a separate variable that includes only those ICD10PCS codes that refer to PCI procedures.
icd10pcs generate insamplePCI1 = procedure1 , range(0270346 02703D6 027034Z 02703DZ 02703Z6 02703ZZ 0270446 027044Z 02704D6 )
icd10pcs generate PCIprocedure1 = procedure1 if insamplePCI1 ==1, description addcode(begin)
Now I have variables PCIprocedure1-20 that extracted data (only PCI procedures of interest) from every procedure1-20
And here is the problem. I need to combine all the data from PCIprocedure1-20 that have similar ICD10PCS codes into one variable like PCIprocedureOverall for further analysis.
I want this new variable PCIprocedureOverall to include all the ICD10PCS procedures that were extracted (0270346 02703D6 027034Z 02703DZ 02703Z6 02703ZZ 0270446 027044Z 02704D6), and I need to combine similar procedures into one.
icd10pcs lookup 0270346 02703D6 027034Z 02703DZ 02703Z6 02703ZZ 0270446 027044Z 02704D6
027.0346 Dilate 1 Cor Art, Bifurc, w Drug-elut Intra, Perc
027.034Z Dilation of 1 Cor Art with Drug-elut Intra, Perc Approach
027.03D6 Dilate 1 Cor Art, Bifurc, w Intralum Dev, Perc
027.03DZ Dilation of 1 Cor Art with Intralum Dev, Perc Approach
027.03Z6 Dilation of 1 Cor Art, Bifurc, Perc Approach
027.03ZZ Dilation of Coronary Artery, One Artery, Perc Approach
027.0446 Dilate 1 Cor Art, Bifurc, w Drug-elut Intra, Perc Endo
027.044Z Dilate of 1 Cor Art with Drug-elut Intra, Perc Endo Approach
027.04D6 Dilate 1 Cor Art, Bifurc, w Intralum Dev, Perc Endo
So, as you can see there are several types of PCI procedures and they are the same for each PCIprocedure1-20. I need to combine similar types of PCI from every group.
Which command can I use?
Thank you in advance.
