<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Event Study Window daily data in Statistical Procedures</title>
    <link>https://communities.sas.com/t5/Statistical-Procedures/Event-Study-Window-daily-data/m-p/733243#M35581</link>
    <description>&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Hello,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I am carrying out an event study application. At the moment, I have some troubles in setting the Event Window. Differently from other questions asked in the community, my events are endogenous. I am using a dummy variable named jumps_pa to detect such events. I should require to set an event window going from t-30 to t+30, where t is the event date. For each event, I need to set such an event window, keeping the data in the columns exc_retadj retidio below for the preceding and following dates.&amp;nbsp;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;my data are daily data, sorted by permno, and&amp;nbsp; arise after several steps from crsp datbase. in particular, they look like this&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;permno&amp;nbsp; date&amp;nbsp; &amp;nbsp; &amp;nbsp;exc_retadj&amp;nbsp; &amp;nbsp;retidio&amp;nbsp; &amp;nbsp; jumps_pa&lt;/P&gt;&lt;P&gt;10000&amp;nbsp; &amp;nbsp; 1/01/x&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; 1 if jump, 0 if no jump.&lt;/P&gt;&lt;P&gt;....&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;....&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; .....&lt;/P&gt;&lt;P&gt;Could anybody help&amp;nbsp; create a table to sort data according to my needs?&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thanks&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Riccardo&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Tue, 13 Apr 2021 09:51:55 GMT</pubDate>
    <dc:creator>RDellaVilla</dc:creator>
    <dc:date>2021-04-13T09:51:55Z</dc:date>
    <item>
      <title>Event Study Window daily data</title>
      <link>https://communities.sas.com/t5/Statistical-Procedures/Event-Study-Window-daily-data/m-p/733243#M35581</link>
      <description>&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Hello,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I am carrying out an event study application. At the moment, I have some troubles in setting the Event Window. Differently from other questions asked in the community, my events are endogenous. I am using a dummy variable named jumps_pa to detect such events. I should require to set an event window going from t-30 to t+30, where t is the event date. For each event, I need to set such an event window, keeping the data in the columns exc_retadj retidio below for the preceding and following dates.&amp;nbsp;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;my data are daily data, sorted by permno, and&amp;nbsp; arise after several steps from crsp datbase. in particular, they look like this&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;permno&amp;nbsp; date&amp;nbsp; &amp;nbsp; &amp;nbsp;exc_retadj&amp;nbsp; &amp;nbsp;retidio&amp;nbsp; &amp;nbsp; jumps_pa&lt;/P&gt;&lt;P&gt;10000&amp;nbsp; &amp;nbsp; 1/01/x&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; 1 if jump, 0 if no jump.&lt;/P&gt;&lt;P&gt;....&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;....&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; .....&lt;/P&gt;&lt;P&gt;Could anybody help&amp;nbsp; create a table to sort data according to my needs?&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thanks&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Riccardo&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Tue, 13 Apr 2021 09:51:55 GMT</pubDate>
      <guid>https://communities.sas.com/t5/Statistical-Procedures/Event-Study-Window-daily-data/m-p/733243#M35581</guid>
      <dc:creator>RDellaVilla</dc:creator>
      <dc:date>2021-04-13T09:51:55Z</dc:date>
    </item>
    <item>
      <title>Re: Event Study Window daily data</title>
      <link>https://communities.sas.com/t5/Statistical-Procedures/Event-Study-Window-daily-data/m-p/733249#M35582</link>
      <description>&lt;P&gt;Hello,&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;I'm really not sure what you're after. Your question is not very clear to me. I'm also wondering why you put in in the "statistical procedures" board.&lt;/P&gt;
&lt;P&gt;Maybe you can clarify your question by using the below code:&lt;/P&gt;
&lt;PRE&gt;&lt;CODE class=" language-sas"&gt;data have;
input permno date jumps_pa;
informat date ddmmyy10.;
format date exc_retadj retidio ddmmyy10.;
exc_retadj = INTNX('DAY',date,-30,'SAME');
retidio    = INTNX('DAY',date,+30,'SAME');
cards;
10000 21/01/2021 1
;
run;
/* end of program */&lt;/CODE&gt;&lt;/PRE&gt;
&lt;P&gt;Cheers,&lt;/P&gt;
&lt;P&gt;Koen&lt;/P&gt;</description>
      <pubDate>Tue, 13 Apr 2021 10:14:21 GMT</pubDate>
      <guid>https://communities.sas.com/t5/Statistical-Procedures/Event-Study-Window-daily-data/m-p/733249#M35582</guid>
      <dc:creator>sbxkoenk</dc:creator>
      <dc:date>2021-04-13T10:14:21Z</dc:date>
    </item>
  </channel>
</rss>

