wrdssas

Contact owners and managers

1–30 of 222

hi everybody,

Welcome to this forum on WRDS and SAS.

Please set your email settings such that you receive some notifications of new posts as to facilitate (active) discussions and quicker response times for helping each other out.

Currently, there are very few messages and if #messages would pick up, you can always switch to a setting where you receive no email.

Thanks and happy wrdssassing :)

Joost

0 selected

9/6/23

Merging Compustat Database with BoardEX

Greetings for you all, I hope this email finds you well. I am currently seeking to merge the

unread,

Merging Compustat Database with BoardEX

Greetings for you all, I hope this email finds you well. I am currently seeking to merge the

9/6/23

Dara, … Simone Carter (Simone)4

8/15/23

How to calculate dividend change in WRDS?

hello everyone. I am having the same issues. Were you all able to replicate the descriptive

unread,

How to calculate dividend change in WRDS?

hello everyone. I am having the same issues. Were you all able to replicate the descriptive

8/15/23

Hajar El Mouttaqui

5/28/23

Internal Capital Markets Efficiency - Rajan et al. (2000)

Hi all, I am a Masters student at the American University of Sharjah and I am currently working on my

unread,

Internal Capital Markets Efficiency - Rajan et al. (2000)

Hi all, I am a Masters student at the American University of Sharjah and I am currently working on my

5/28/23

5/13/23

SAS code crash risk NCSKEW method and DUVOL method

Hello, Can you please help me to compute crash risk variable by using the NCSKEW method and DUVOL

unread,

SAS code crash risk NCSKEW method and DUVOL method

Hello, Can you please help me to compute crash risk variable by using the NCSKEW method and DUVOL

5/13/23

MERYEM EL ASSAD

9/20/22

Event Study Code Princeton

Hello all! I am looking for the stata code for the event study. Did anyone save the princeton code,

unread,

Event Study Code Princeton

Hello all! I am looking for the stata code for the event study. Did anyone save the princeton code,

9/20/22

6/27/22

How to get/calculate the float shares of a stock using data in WRDS?

there was a variable related to float shares ( SPFLOAT ) provided by COMPUSTAT. but wrds removed it

unread,

How to get/calculate the float shares of a stock using data in WRDS?

there was a variable related to float shares ( SPFLOAT ) provided by COMPUSTAT. but wrds removed it

6/27/22

Isabella B., wanrong hou2

11/10/21

How to get M&A data based on Compustat Footnotes

Hi Isabella, I am not sure if this can help you. If you go to WRDS, COMPUSTAT, Fundamentals Annual.

unread,

How to get M&A data based on Compustat Footnotes

Hi Isabella, I am not sure if this can help you. If you go to WRDS, COMPUSTAT, Fundamentals Annual.

11/10/21

11/2/21

Issue regarding Crsp-Compustat-Merged Data: gvkey-fyear do not unique identify obs

Hi Joost and WRDSSAS group, I have an Issue regarding Crsp-Compustat-Merged Data: gvkey and fyear do

unread,

Issue regarding Crsp-Compustat-Merged Data: gvkey-fyear do not unique identify obs

Hi Joost and WRDSSAS group, I have an Issue regarding Crsp-Compustat-Merged Data: gvkey and fyear do

11/2/21

Bo Li, wanrong hou3

10/30/21

BLKSHVAL -- Value (Black-Scholes) (BLKSHVAL) in Executive Comp 1992 Format

Hi Wanrong Hou, Thank you so much! Yes, the BLKSHVAL is in thousands of dollar. The document is very

unread,

BLKSHVAL -- Value (Black-Scholes) (BLKSHVAL) in Executive Comp 1992 Format

Hi Wanrong Hou, Thank you so much! Yes, the BLKSHVAL is in thousands of dollar. The document is very

10/30/21

J Smith, … Bo Li16

10/15/21

compustat segments data

Hi Joost, Thank you very much! I really appreciate that you help answer this question, which is very

unread,

compustat segments data

Hi Joost, Thank you very much! I really appreciate that you help answer this question, which is very

10/15/21

7/19/21

How to identify foreign securities in CRSP mutual fund database?

I'm working on CRSP mutual fund database. How can we identify all securities which are from

unread,

How to identify foreign securities in CRSP mutual fund database?

I'm working on CRSP mutual fund database. How can we identify all securities which are from

7/19/21

6/1/21

crash risk sas code

Hello, I am trynig to run a sas code to calculate stock price crash risk. i use daily data to

unread,

crash risk sas code

Hello, I am trynig to run a sas code to calculate stock price crash risk. i use daily data to

6/1/21

3/10/21

how to merge crsp monthly and compustat quarterly in sas

I am trying to merge CRSP monthly with COMPUSTAT quaterly in SAS. Does anyone have any code that I

unread,

how to merge crsp monthly and compustat quarterly in sas

I am trying to merge CRSP monthly with COMPUSTAT quaterly in SAS. Does anyone have any code that I

3/10/21

3/4/21

Compustat CRSP IBES Merge

Hi everyone, for my project I need to combine the data from all Compustat CRSP and IBES datasets. I

unread,

Compustat CRSP IBES Merge

Hi everyone, for my project I need to combine the data from all Compustat CRSP and IBES datasets. I

3/4/21

2/19/21

tdc1 in Execucomp

I've been working with the tdc1 variable in Execucomp and I'm noticing some discrepancies

unread,

tdc1 in Execucomp

I've been working with the tdc1 variable in Execucomp and I'm noticing some discrepancies

2/19/21

sharif10....@gmail.com

2/14/21

How to Convert Worldscope variables into USD ($)

Hi, I got variables from Worldscope of different companies from different countries. I need to

unread,

How to Convert Worldscope variables into USD ($)

Hi, I got variables from Worldscope of different companies from different countries. I need to

2/14/21

1/25/21

Help with merging Compustat and RiskMetrics

Hello everyone, I would like to ask about the issues I faced during my research. I try to merge two

unread,

Help with merging Compustat and RiskMetrics

Hello everyone, I would like to ask about the issues I faced during my research. I try to merge two

1/25/21

Leah Li, qingj...@gmail.com2

1/21/21

Duality, umber of renumeration committee members, number of shares owner by CEO and company total outstanding shares

CEO & Chairman duality variable, and number of shares owner by CEO should be available at

unread,

Duality, umber of renumeration committee members, number of shares owner by CEO and company total outstanding shares

CEO & Chairman duality variable, and number of shares owner by CEO should be available at

1/21/21

1/12/21

Availability of CRSP 2020

Dear Community, I have tried to download CRSP monthly stock for 2020 but it seems that the

unread,

Availability of CRSP 2020

Dear Community, I have tried to download CRSP monthly stock for 2020 but it seems that the

1/12/21

12/9/20

Help with Accounting Conservatism Khan & Watts model (C-score)

Hi everyone, Does anyone have the sas code to construct C-score for Accounting Conservatism? I would

unread,

Help with Accounting Conservatism Khan & Watts model (C-score)

Hi everyone, Does anyone have the sas code to construct C-score for Accounting Conservatism? I would

12/9/20

joost impink, Attila Balogh2

11/22/20

Problems replicating Roychowdhury (2006) on real activities manipulation

Joost, While the original authors say they include “all firms in Compustat", perhaps they remove

unread,

Problems replicating Roychowdhury (2006) on real activities manipulation

Joost, While the original authors say they include “all firms in Compustat", perhaps they remove

11/22/20

Quirine Anbeek, Attila Balogh2

11/22/20

Compustat variables - meaning of 0

Hi Quirine, It's probably useful to understand the universe of firms that are included in

unread,

Compustat variables - meaning of 0

Hi Quirine, It's probably useful to understand the universe of firms that are included in

11/22/20

10/16/20

How to load own csv file into SAS WRDS Cloud

Dear Community, were wondering if someone could help me to understand why I get an error when I try

unread,

How to load own csv file into SAS WRDS Cloud

Dear Community, were wondering if someone could help me to understand why I get an error when I try

10/16/20

Bahaa, joost impink3

9/29/20

Where to find the Financial statement numbers before restatement?

Thank you very much for your reply. I am afraid my university does not have access to Compustat

unread,

Where to find the Financial statement numbers before restatement?

Thank you very much for your reply. I am afraid my university does not have access to Compustat

9/29/20

Andrei Bubutanu, joost impink3

9/20/20

Duplicates in Compustat -> Fundamentals Annual

Thank you so much, Joost! It worked! Have a great week! Thanks, Andrei Pe vineri, 18 septembrie 2020,

unread,

Duplicates in Compustat -> Fundamentals Annual

Thank you so much, Joost! It worked! Have a great week! Thanks, Andrei Pe vineri, 18 septembrie 2020,

9/20/20

K Rockefeller, glen...@gmail.com2

8/31/20

WRDS outage in US mid-south?

I am able to connect (in Texas). Before connecting remotely, I logged into the website and noticed

unread,

WRDS outage in US mid-south?

I am able to connect (in Texas). Before connecting remotely, I logged into the website and noticed

8/31/20

8/21/20

Hi everybody, Does anyone use SPSS or SAS data file in R? When I import data and extract those with

unread,

Hi everybody, Does anyone use SPSS or SAS data file in R? When I import data and extract those with

8/21/20

Elham Daadmehr, … Attila Balogh7

8/13/20

Zeros of AJEXDI

Thanks, Attila!!! On Wed, Aug 12, 2020 at 11:58 PM Attila Balogh <attila...@unsw.edu.au>

unread,

Zeros of AJEXDI

Thanks, Attila!!! On Wed, Aug 12, 2020 at 11:58 PM Attila Balogh <attila...@unsw.edu.au>

8/13/20

7/29/20

Identifiers on SDC

Hi all, I have a question about firm identifiers on SDC. I know there's a 9 digit computer

unread,

Identifiers on SDC

Hi all, I have a question about firm identifiers on SDC. I know there's a 9 digit computer

7/29/20

J C, EVANS BOAMAH2

7/28/20

merge by company name

Try using a name match. Download the fuzzy excel adds in and use excel On Mon, 27 Jul 2020 at 14:46,

unread,

merge by company name

Try using a name match. Download the fuzzy excel adds in and use excel On Mon, 27 Jul 2020 at 14:46,

7/28/20

Search

Clear search

Close search

Google apps

Main menu