Hey,

I am fairly new to mySQL and I am looking for some help in how to best turn fairly large SAS datasets into SQL databases. Ideally, reading directly the sas7bdat file would be great, but if that's not possible somehow writing the SAS database into a format that can easily be processed by mySQL would be ok as well–just would like to avoid having SAS directly involved as mySQL database is going to be on MAC. The datasets are rather large, talking of about 20 sas7bdat files in compressed format of each of each 7.5GB, i.e. writting those out as a csv is possible but together will take up to around 1TB. Unfortunately, I have not found any help for this on the web, which is why I am turning to this forum. If anyone has experience with this or could point me into the right direction/helpful sites, would be great.


Thanks!