Is there any good way to load SAS formatted data into KDB?
My data is 20GB in SAS .sas7bdat format.
Thanks.
Is there any good way to load SAS formatted data into KDB?
My data is 20GB in SAS .sas7bdat format.
Thanks.
If you still have SAS running, go through SAS ODBC driver might be a possibility, as q can easily query ODBC data sources.
As suggested in this post on SO:
Download/pip install the sas7bdat python package, and then run:
$ sas7bdat_to_csv in.sas7bdat out.csv
which you can then load into kdb with 0: per the reference page.
Thanks. This may work. I will have a try.