Monthly Archives: June 2013

Install PL/R on OS X 10.9 using MacPorts

In an earlier post, I detailed how to get PL/R up and running on Mac OS X. Recently, I’ve had reason to want PL/Python on my system too, but I have not been able to get it going using my … Continue reading

Posted in Uncategorized | Leave a comment

Remote WRDS SAS from R via Stata .dta format

This post is a follow-up to an earlier post. PROC EXPORT exports special missing values as text, which causes my database to choke when such values occur in non-text columns (e.g., nameenddt in crsp.ccmxpf_linktable). So this code uses Stata as … Continue reading

Posted in Uncategorized | Leave a comment

Moving all tables to a different tablespace in PostgreSQL

I first created a directory on my computer as If I wanted to move my database into this new tablespace: But if I just want to move the stuff I use and manage: and saved it as move_to_ssd.sql (“ssd” is … Continue reading

Posted in PostgreSQL | Tagged | 3 Comments

Get information on tables in a schema (or two)

Posted in Uncategorized | Leave a comment