I'm trying to convert the data from this database to a format like csv or sql database. The goal is to analyze this data with R later. I would like to store them in a local database to be able to analyze all the values. How can I implement this the easiest? I have already made a few attempts but without success.
-
asdfree.com/fda-adverse-event-reporting-system-faers.html ?– Anthony DamicoJun 29, 2018 at 13:24
-
I think this question is only tangentially appropriate on this site, but feel free to contact me (contact info in profile) for free help in doing this. I suspect it's not difficult.– user3856Jul 1, 2018 at 15:19
1 Answer
Download the raw json data, convert to CSV, and put it into a postgres db. Then you can use RODBC to analyze in R.