The repo has notebooks and scripts that demonstrate how to connect with the WRDS server. Here are instructions for using the notebooks and scripts on KLC.
# Connect to KLC
# https://www.kellogg.northwestern.edu/academics-research/research-support/computing/kellogg-linux-cluster.aspx
# Or Quest analytic node
# RStudio
# https://rstudio.questanalytics.northwestern.edu
# Jupyter Notebook
# https://jupyter.questanalytics.northwestern.edu
# Clone the repo
git clone https://github.com/rs-kellogg/wrds_KLC
cd wrds_KLC
# Set up .pgpass file at your $HOME directory
# wrds-pgdata.wharton.upenn.edu:9737:wrds:username:your_password
nano ~/.pgpass
# Activate pre-built conda environment
module load mamba
source activate /kellogg/software/envs/wrds_env/
# Add the conda environment kernel locally (only need to run once)
python -m ipykernel install --user --name wrds_env --display-name "Python (wrds_env)"
### IMPORTANT ###
# Modify "username" in .ipynb, .py or .R scripts to your username for WRDS
# Launch the jupyter notebook in FastX
# Select the "Python (wrds_env)" kernel before you run cells
jupyter notebook --browser=firefox
# To run the python script
python ./demo_python.py
# To run the R script
Rscript ./demo_R.R
# Leave the environment
conda deactivate