Ian Gow iangow

The material by Matthew Gentzkow and Jesse Shapiro is found here. This uses Stata, but the principles are general. Course material on "reproducible research" can be found here. An introduction to Git and GitHub for social scientists is here.

I briefly mentioned ShareLaTeX at the beginning. I also discussed a paper with David Larcker and Peter Reiss. The GitHub repository for this can be found here. The GUI software I was using was SourceTree.

With regard to a more recent JAR paper (I did not discuss this one today), the code and data that I was responsible for can be fo

crsp=# SELECT pid, user, substr(query, 1, 30) FROM pg_stat_activity;
  pid  | current_user |             substr             
-------+--------------+--------------------------------
 30152 | igow         | SELECT c.oid, a.attnum, a.attn
 30153 | igow         | SELECT i.*,c.relnamespace FROM
 31603 | igow         | CREATE TEMPORARY TABLE "lkvabv
 31958 | igow         | SELECT pid, user, substr(query
(4 rows)

1. Install new PostgreSQL:

sudo port install postgresql11 +perl+python+python27 postgresql11-server
sudo port unload postgresql96-server

	SET work_mem='3GB';

	BEGIN;

	CREATE TEMPORARY TABLE temp AS
	SELECT DISTINCT * FROM bgt.fog;

	DROP TABLE bgt.fog;

	CREATE TABLE bgt.fog AS

	wget https://distfiles.macports.org/MacPorts/MacPorts-2.5.4.tar.gz
	tar xzvf MacPorts-2.5.4.tar.gz
	cd MacPorts-2.5.4
	./configure
	make
	sudo make install
	sudo port -v selfupdate
	sudo port upgrade outdated

Ian Gow iangow

1. Install new PostgreSQL:

2. Install PL/R.