Ian Gow iangow

More up-to-date material on this topic can be found here.

From WRDS:

The WRDS-created linking dataset (ccmxpf_linktable) has been deprecated. It will continue to be created for a transition period of 1 year. SAS programmers should use the Link History dataset (ccmxpf_lnkhist) from CRSP.

And from here:

Issues

Some issues I see with using the WRDS PostgreSQL server include:

Too many schema and tables

Added complexity for the user.

No ability to create tables.

So there's no way to store results of long-running queries.
No ability to use compute() with dplyr.

Difficult to combine WRDS data with large datasets.

	proc sql;
	connect to odbc as iangow (datasrc=iangow);
	create table mydata as
	select * from connection to iangow (
	SELECT *
	FROM filings.ct_orders);
	quit;

	CREATE TABLE tone_data_temp AS
	SELECT file_name, last_update, category, word_count, litigious,
	positive, uncertainty, negative, modal_strong, modal_weak
	FROM bgt.tone_data;

	DROP TABLE bgt.tone_data;

	ALTER TABLE tone_data_temp RENAME TO tone_data;
	ALTER TABLE tone_data SET SCHEMA bgt;

	<?xml version="1.0" encoding="UTF-8"?>
	<!DOCTYPE plist PUBLIC "-//Apple Computer//DTD PLIST 1.0//EN"
	"http://www.apple.com/DTDs/PropertyList-1.0.dtd">
	<plist version="1.0">
	<dict>
	<key>Label</key>
	<string>com.rstudio.launchd.rstudio</string>
	<key>ProgramArguments</key>
	<array>
	<string>/usr/local/lib/rstudio-server/bin/rserver</string>

	wget https://cran.rstudio.com/bin/macosx/R-3.6.1.pkg
	sudo installer -pkg R-3.6.1.pkg -target /
	rm R-3.6.1.pkg