-
Notifications
You must be signed in to change notification settings - Fork 3
Expand file tree
/
Copy path0.0_inputs.sas
More file actions
25 lines (21 loc) · 1009 Bytes
/
0.0_inputs.sas
File metadata and controls
25 lines (21 loc) · 1009 Bytes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
* User inputs;
%let capIQ_path = G:\My Drive\Research\FLP_Analyst_Soft_Skills\FLP_Analyst_Skill_Shared\Data; /*define path to location of data*/
* Path to Capital IQ data;
/*
ciq library has capital IQ transcript data, wrds_gvkey, and wrds_professional if you do not have
access to wrds_professional, you may be able to perform a similar merge using only the transcript
data to populate missing companyofperson values
*/
libname ciq "&capIQ_path\capital IQ"; /* Can also modify to run this on WRDS */
libname adj "&capIQ_path\capital IQ\Adjusted";
/*
library with ptgdet, recddet, and IBES-PERMNO link files from IBES
*/
libname ibes "G:\My Drive\Research\SAS\Data Files\IBES";
%let iclink = iclink_20210121;
%let ciqfile = "&capIQ_path\capital IQ\Adjusted\ciqAFY_FmtdNms_20240330.csv";
%let ibesfile = "&capIQ_path\capital IQ\Adjusted\ibesAFY_new_vint_FmtdNms_20240330.csv";
/*
Put today's date to use at the end of main output files
*/
%let date = %sysfunc(today(), yymmddn8.);