CRSP

From ISOR
(Difference between revisions)
Jump to: navigation, search
(download the results onto your desktop / laptop)
 
(30 intermediate revisions by one user not shown)
Line 1: Line 1:
==CRSP, COMPUSTAT, CCM ==
+
Chicago Booth is going to retire the desktop tool [[CRSPSift]] by end of 2024 and all the other tools based on fileformat 1.0.
=== access ===
+
==== require credentials ====
+
email the VDC sysadmin to provide credentials and prepare your remote terminal
+
      <ul>
+
        <li>
+
            host: crsp.vdc.univie.ac.at
+
        </li>
+
          <li>
+
            user: your username
+
        </li>
+
        <li>
+
            password: your password
+
        </li> 
+
      </ul>
+
+
==== VPN ====
+
If working from home or elsewhere but from the institute's PC lab (room #6.644) you have to establish a Virtual Private Network (VPN) to Uni first ([https://zid.univie.ac.at/en/vpn/ see ZID/VPN]).
+
  
==== SSH ====
+
Fileformat 2.0 has been recently released and (re)programming on our side has already started accordingly.
If working from Windows, you might need to install an SSH-client ([https://www.putty.org/ like PUTTY]) to use Secure Shell (SSH) to connect to your terminal. Accept the server key.
+
[[File:3_accept_key.png|left|frameless|200px|caption]]
+
<br clear=all>
+
 
+
==== usage of a terminal ==== 
+
Now you work remotely and use the remote host's command line (which is the bash shell, don't type the beginning "$", which is the prompt):   
+
[[File:4_terminal_session.gif|left|]]
+
<br clear=all>
+
the midnight-commander (mc) provides a built-in editor mcedit (exit it with Alt+0)
+
<pre>$ mc </pre>
+
<pre>$ mcedit ts_samp7.rqt </pre>
+
e.g. use  "ts_print" to process a requirementfile "ts_samp7.rqt" and get the output "ts_samp7.out":
+
        <pre>$ ts_print ts_samp7.rqt</pre>
+
<!--
+
[[File:7_ts_print.png|left|frameless|500px|caption]]
+
<br clear=all>
+
-->
+
   
+
use mc/mcedit to look into ts_samp7.out with:
+
<pre>$ mcedit ts_samp7.out </pre>
+
[[File:8_ts_samp6_out.png||frameless|400px|caption]]
+
<br clear=all>
+
<br/>
+
use e.g. this command to get the switches for the command crsp_print:
+
<pre>$ crsp_print /d1  /var/crsp/2019-07/crspdata/cmz201807</pre>
+
==== download the results onto your desktop / laptop ====
+
use an SFTP client like [https://cyberduck.io/download/ CyberDuck] to download the results (e.g. ts_samp7.out) onto your desktop for further processing. Provide your SSH credentials:
+
 
+
[[File:10_cyberduck_credentials.png|400px]]
+
<br clear=all>
+
 
+
=== documentation===
+
Please read some manuals to gain experience with the ts_sampleX.rqt files in your home directory
+
[http://www.crsp.com/products/documentation/cupl-386-guide CRSP Utilities and Program Libraries (CUPL)]
+
and maybe the [https://w3.loibl.com/uni/xf_understanding_the_data.pdf xf-understanding_the_data guide].
+

Latest revision as of 14:16, 27 September 2023

Chicago Booth is going to retire the desktop tool CRSPSift by end of 2024 and all the other tools based on fileformat 1.0.

Fileformat 2.0 has been recently released and (re)programming on our side has already started accordingly.

Personal tools
Namespaces

Variants
Actions
Navigation
Tools