Converting HCUP NIS Files from .ASC into SPSS

[@HaimanotAssefa-fw8wn]

Thank you so much for this tutorial! I'm an undergraduate research student and trying to figure all this out has been a little stressful. This was extremely helpful!

[@heatherbriere5549]

Oh my gosh, you have no idea how much this video helped me! Thank you!

[@MURADBOW]

Glad to hear that!

[@justindza]

This was extremely helpful. The path location is where I was messing up 🤦. Thanks you very much!

[@MURADBOW]

I am glad that you found it helpful!

[@justindza]

@@MURADBOW are you aware of anyway to identify state codes? I need to reduce the data to Georgia alone. I am using the NRD too. But I'm sure it is similar to NIS

[@MURADBOW]

@@justindza I tried to identify states, but I could not. They only provide regions which is not helpful for what I wanted to study. Please let me know if you found a way to link the data set to states or counties.

[@justindza]

@@MURADBOW same here I've had no luck. There are hospital codes so I think it would require going through and matching all the hospital codes to the specific state. Sounds like a tedious procedure. Thanks for your help. I appreciate you replying

[@accountresidency2234]

@@justindza i think you cant? and need to use the state database instead

[@charlesreed1401]

what SPSS software do you have? where did you get it? how much does it cost?

[@timeattackdreamer989]

Hey, thank you so much for this. I had a follow-up question. How can I add the file location to the editor in SPSS if I was using a Mac?

[@MURADBOW]

I suggest you google it. I have been using a pc as you saw.

[@samuelcohen1141]

@Murad Moqbel I am trying to load my 2012 NIS into SPSS but I keep getting the following error when I run the code: SPSS statistics cannot access a file with the given file specification. I am unsure why this is as it is a standard ASC file. Do you have any recommendations?

[@MURADBOW]

Samuel, I am not sure, but you might see how I did it in this video if it can help.

[@rakahnhaddadin9969]

Hello, do you have more videos explaining how to run the data ? Thank you for this great video !

[@MAnisHaider]

Hi, could you please make a video for mac if possible. I bought data but am struggling to open with SPSS as the intructions you explained on this view are for windows and I have Mac. many thanks if you could help

[@hannahkuhar2939]

Thank you for your very informative presentation. I have a question, I keep receiving: "Error. Command name: get data (2256)," and "Error #100. Command name: VARIABLE LABLES" "RECODE" etc. I have been using a .csv file instead of a .ASC file - could this be the reason? I would appreciate any help! Thank you!

[@MURADBOW]

I am not sure if this will help, but it might be that you need to make sure to highlight the content first, as shown in the video.

[@hannahkuhar2939]

@@MURADBOW Thank you! I figured it out - my syntax was off as I am using a macintosh. One more question, for some reason I only have a portion of the cases in the database in my .CSV file and .SAV file despite using the correct downloaded .zip Core file (N=1 million in my data instead of the N=14 million I should have as shown in the summary statistics reports on the HCUP site). Do you have any recommendations for troubleshooting this?

[@samuelcohen1141]

@@hannahkuhar2939 I am trying on a Mac but I can't get it to work. Did you do anything differently from the video?

[@lavianderm8950]

@@hannahkuhar2939 I'm also working on mac and keep getting an "SPSS statistics cannot access a file with the given file specification..." error. Would really appreciate knowing what you did differently as well.

[@khaledalnahhal9254]

@@lavianderm8950 SPSS only has access for the main folder. so you have to put all your files in there. how to open the main folder. just go to the desktop and click shift +command + h and then put all ur doc there.

[@EnhanceYourLife92]

Any tutorial on how to merge core, dx, severity, and hospital files together? Then how to merge different years together?

[@MURADBOW]

You can use any relational database management system and then merge them using SQL. I retrieved a sample into ms Access and I was able to merge them using query by example as well as SQL select statements.

[@EnhanceYourLife92]

@@MURADBOW I can't just use SPSS to merge them?

[@MURADBOW]

@@EnhanceYourLife92 I do not think so. I have not used SPSS for a while. So, if anyone reading this post knows of how to do so in SPSS, please let us all know.

[@accountresidency2234]

have u had any luck with that? I have been using the core file itself. so i cant assess for severity and hospital details coz i didnt merge them i think something like this might work : kzbin.info/www/bejne/r3KmqaannrJ0h9E

[@EnhanceYourLife92]

@@accountresidency2234 I got the files to merge but never figured out how to use SPSS properly 😅

[@emantoraih7700]

Thank you so much. It was very informative.

[@MURADBOW]

You are welcome!

[@hchaudhryMD]

Thank you. This is very helpful

[@MURADBOW]

You are welcome!

[@kkr8540]

Your video was extremely helpful. I have a doubt. How to use the cost to charge file. They gave me the file as an excel document. I have already calculated the charge for a given condition. But I don't know how to convert it to the cost. Any help would be greatly appreciated sir.

[@americanbee]

Multiply to cost-to-charge ratio, then charges are canceled out.. That’s the only way i think