Applying HCUP software on NIS data through STATA

[Ratib Mahfouz]

Hello everyone,
I'm using NIS data for research, which is a dataset that uses ICD-10 codes to generate variables and diseases.
There are additional softwares including:
https://www.hcup-us.ahrq.gov/toolsso...onic_icd10.jsp
https://www.hcup-us.ahrq.gov/toolsso...cs_refined.jsp
https://www.hcup-us.ahrq.gov/toolsso...dity_icd10.jsp
https://www.hcup-us.ahrq.gov/toolsso...dure_icd10.jsp

These can be applied to NIS dataset to generate premade variables to make studies easier.
The only problem is that I have to convert the dataset to SAS using the SAS program (which is very huge in size), then apply the mapping program after modifying the file and converting back the data to .dta (stata).

Unfortunately, the process was neither convenient nor successful, and till this moment I don't know why there is no STATA plugin (through ssc install) or .do file that does the same job with fewer steps and a more straightforward way.

If anyone with experience can convert this .sas code to .do or STATA plugin, it would be very helpful.
The files contain .csv that .sas file rely on, so there might be a way to take the data from the .csv and apply it on stata easily.

Appreciated.

[Leonardo Guizzetti]

To my knowledge, Elixhauser comorbiidty scores may be calculated using -elixhauser- or similar (-search elixhauser-) with a program on the SSC deposited by Dr. Stagg. I do not know, though would trust, that the conversion applied by the AHRQ is that same as that based on the originating paper. You may also use -search- for the other commands, though to the degree they exist, I doubt they will be as up-to-date as those published by the AHRQ.

Unfortunately, the process was neither convenient nor successful, and till this moment I don't know why there is no STATA plugin (through ssc install) or .do file that does the same job with fewer steps and a more straightforward way.

The AHRQ develops these tools and they state on the linked pages that SAS programs are only available at this time. For the time being, you will either need to use SAS (or beg a a friend to use it for you) or else create your own adaptation to Stata. Beware: whatever you develop should be validated against the source tool if you are to have any confidence the tool is adapted correctly.