Alvaro Soto on Installing PostgreSQL 9.6 usin… Alvaro Soto on Installing PostgreSQL 9.6 usin… iangow on Getting SEC filing index … George Mount on Getting SEC filing index … vahid on RStudio Server on Mac OS …
Author Archives: iangow
See here for an illustration using Python to access the data.
Here is a snippet of code showing how one can include SQL in Stata code (I assume that the ODBC connection has been set up). #delimit ; local sql ” SELECT * FROM director_bio.directorship_results WHERE non_match AND start_date < date_filed … Continue reading
from datetime import datetime from pytz import timezone, utc pacific = timezone(‘US/Pacific’) gemma_bd = datetime(2007, 8, 27, 7, 45) gemma_bd = pacific.localize(gemma_bd, is_dst=True) print(utc.localize(datetime.utcnow()) – gemma_bd)
In another post, I describe how to install PostgreSQL with PL/R. The purpose of this post is to provide a streamlined version without PL/R. 1. Install PostgreSQL using MacPorts.. Of course, I assume you’ve got MacPorts up and running on … Continue reading
I recently discovered that Stata has good support for OBDC. While the built-in functionality includes odbc sqlfile, a “batch job alternative to odbc exec,” there seems to be no equivalent alternative for odbc load (even though odbc load is surely … Continue reading
In an earlier post, I discussed a way of accessing PostgreSQL from Stata. One downside is that this approach would not work for Windows users without significant modification. I asked a question on StackOverflow to see if anyone could identify … Continue reading