Dear Madam/Sir,   I downloaded CRSP daily return data from 1998 to 2021 (44,603,238 observations, 11.3 GB) and data form is as follows:   Firm_ID     date               returns(ret)         market_returns (vwretd)             calender year(cyear) 11           01/01/2013                 7                           1.5                           2014 11            01/02/2013                9                           -10                            2014   And I dropped observations that number of cases in a firm-year is below 200 and then run market model regressions to get predicted parameter (beta) and standard deviation of residual (rmse). However, sas window is closed without producing outputs repeately while running yearly regressions. data c3; count = 0; do until (last.cyear); set c2; by cusip cyear; count + 1; end; do until (last.cyear); set c2; by cusip cyear; if count ge 200 then output; end; drop count; run;   proc reg data=c3 outest=c4 plots=none; by cusip cyear; model ret=vwretd; run;   It will be highly appreciated if you can advise me as to how to prevent SAS window closing while running regressions.   Sincerely, Joon1   ... View more

Dear Madam/Sir,   For each IO industry, I want to multiply numbers in each row for each IO industry with "comp" variable except its own industry (data attached). For instance, for IO 111CA (farms), comp 0.638957866 x 0.0688737( IO 113FF) + comp 0.761841026 x 0.091003( IO 211) + comp 0.914848186 x 0.0096249 (IO 212) + comp 0.825890645 x  0.000328 (IO 213) + comp 1.0078 x 0.026865 (IO 22)  (except IO 111CA, farm). And then repeat the same process for every other industry. I do not find useful commands. Any help will be highly appreciated to perform this calculation.   Thank you so much. Joon1   data format  IO Industry_Description cyear Farms Forestry__fishing__and_related_a Oil_and_gas_extraction Mining__except_oil_and_gas Support_activities_for_mining Utilities comp 111CA Farms 1997 1.18142 0.0590518 0.0007557 0.0026902 0.0012788 0.0006635 0.727964454 113FF Forestry, fishing, and related activities 1997 0.0688737 1.23167 0.0003183 0.0024397 0.0006637 0.0003304 0.638957866 211 Oil and gas extraction 1997 0.0091003 0.006632 1.08566 0.0158068 0.0070102 0.0970558 0.761841026 212 Mining, except oil and gas 1997 0.0096249 0.002073 0.0028516 1.07108 0.0024438 0.03242 0.914848186 213 Support activities for mining 1997 0.000328 0.0001729 0.0237757 0.0141272 1.0078 0.002556 0.825890645 22 Utilities 1997 0.026865 0.0099835 0.0194369 0.0413922 0.0051409 1.04719 0.961662704 ... View more

Dear Madam/Sir,   ... View more

Dear Madam/Sir, I created a character variable as below. if naics in (5412,5413,5417,5418,5414,54161,54162,54169,54191,54193,54199,54192,54194) then IO='5412OP'; However, variable name is truncated at the 5-digit after SAS operation as below. IO Frequency Percent CumulativeFrequency CumulativePercent 5412O 126 0.24 46240 89.60 It will be highly appreciated if you can advise me how to avoid this variable truncation problem.   Thanks Joon1   ... View more

Dear Madam/Sir, I would like to construct quarterly earnings stream, but fail to locate related codes. The data structure is below. How can I capture instances where 'qearning' is increased for four consecutive quarters (FQTR)?   Obs GVKEY FYEARQ FQTR qearning1234567891011121314 001004 1994 3 0.120 001004 1994 4 0.147 001004 1995 1 0.133 001004 1995 2 0.153 001004 1995 3 0.173 001004 1995 4 0.207 001004 1996 1 0.200 001004 1996 2 0.213 001004 1996 3 0.240 001004 1996 4 0.260 001004 1997 1 0.267 001004 1997 2 0.307 001004 1997 3 0.340 001004 1997 4 0.380   Any programming advice will be highly appreciated.   Sincerely, Joon   ... View more

Dear Madam/Sir, I would like to get the cumulative sum for five executives by firm and year as below.                                                                                                         firm        year   executive id    shrown_tot_pct                               949596979899100101102103 001004 2009 09249 3.861 001004 2009 09252 0.694 001004 2009 23781 0.458 001004 2009 33979 0.286 001004 2009 36199 0.121 001004 2010 09249 3.833 001004 2010 09252 0.897 001004 2010 33979 0.361 001004 2010 36199 0.177 001004 2010 41787 0.265                    I used the following code, but I did not get the desired results (null).   proc sort data=y1; by gvkey year; run; data y2; set y1; by gvkey year; retain sumown; if first.gvkey then sumown=shrown_tot_pct; else sumown=sumown+shrown_tot_pct; run;   Any advice will be highly appreciated.   Thanks Joon1   ... View more