https://communities.sas.com/t5/SAS-Programming/I-want-to-selectively-add-a-few-data-to-make-a-new-variable/m-p/472190#M121033 thank you so much! But I don't understand some syntax... let me first try it...! Thu, 21 Jun 2018 16:10:20 GMT ESJ 2018-06-21T16:10:20Z https://communities.sas.com/t5/SAS-Programming/I-want-to-selectively-add-a-few-data-to-make-a-new-variable/m-p/472151#M121011 <P>Hi, I'm a poor beginner who's lost in nowhere.</P><P>&nbsp;</P><P>My situation is:</P><P>coname&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; year&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ROA</P><P>company A&nbsp;&nbsp;&nbsp;&nbsp; 2007&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20</P><P>company A&nbsp;&nbsp;&nbsp;&nbsp; 2008&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10</P><P>company A&nbsp;&nbsp;&nbsp;&nbsp; 2009&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15</P><P>compnay A&nbsp;&nbsp;&nbsp;&nbsp; 2010&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9</P><P>company A&nbsp;&nbsp;&nbsp;&nbsp; 2011&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>company A&nbsp;&nbsp;&nbsp;&nbsp; 2012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -4</P><P>company A&nbsp;&nbsp;&nbsp;&nbsp; 2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10</P><P>company B&nbsp;&nbsp;&nbsp;&nbsp; 2007&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</P><P>company B&nbsp;&nbsp;&nbsp;&nbsp; 2008&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8.&nbsp; ... similar for company B too.</P><P>&nbsp;</P><P>like this. I want to make comparison between company-year average of 2007-2010 and 2011-2013.</P><P>desired outcome will look like:</P><P>coname&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; year&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ROA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ROA_pre&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ROA_post</P><P>company A&nbsp;&nbsp;&nbsp; 2007&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 14&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>company A&nbsp;&nbsp;&nbsp;&nbsp; 2008&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 14&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>company A&nbsp;&nbsp;&nbsp;&nbsp; 2009&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 17&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 14&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>compnay A&nbsp;&nbsp;&nbsp;&nbsp; 2010&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 14&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>company A&nbsp;&nbsp;&nbsp;&nbsp; 2011&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3</P><P>company A&nbsp;&nbsp;&nbsp;&nbsp; 2012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -2 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3</P><P>company A&nbsp;&nbsp;&nbsp;&nbsp; 2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3</P><P>company B&nbsp;&nbsp;&nbsp;&nbsp; 2007&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</P><P>company B&nbsp;&nbsp;&nbsp;&nbsp; 2008&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8</P><P>&nbsp;</P><P>Will proc summary be the answer?</P><P>&nbsp;</P><P>Please help me. I know nothing but the fact that I know nothing...</P> Thu, 21 Jun 2018 15:23:54 GMT https://communities.sas.com/t5/SAS-Programming/I-want-to-selectively-add-a-few-data-to-make-a-new-variable/m-p/472151#M121011 ESJ 2018-06-21T15:23:54Z https://communities.sas.com/t5/SAS-Programming/I-want-to-selectively-add-a-few-data-to-make-a-new-variable/m-p/472155#M121013 <P>How are you calculating Pre/Post?</P> <P>&nbsp;</P> <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/216942">@ESJ</a>&nbsp;wrote:<BR /> <P>Hi, I'm a poor beginner who's lost in nowhere.</P> <P>&nbsp;</P> <P>My situation is:</P> <P>coname&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; year&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ROA</P> <P>company A&nbsp;&nbsp;&nbsp;&nbsp; 2007&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20</P> <P>company A&nbsp;&nbsp;&nbsp;&nbsp; 2008&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10</P> <P>company A&nbsp;&nbsp;&nbsp;&nbsp; 2009&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15</P> <P>compnay A&nbsp;&nbsp;&nbsp;&nbsp; 2010&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9</P> <P>company A&nbsp;&nbsp;&nbsp;&nbsp; 2011&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P> <P>company A&nbsp;&nbsp;&nbsp;&nbsp; 2012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -4</P> <P>company A&nbsp;&nbsp;&nbsp;&nbsp; 2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10</P> <P>company B&nbsp;&nbsp;&nbsp;&nbsp; 2007&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</P> <P>company B&nbsp;&nbsp;&nbsp;&nbsp; 2008&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8.&nbsp; ... similar for company B too.</P> <P>&nbsp;</P> <P>like this. I want to make comparison between company-year average of 2007-2010 and 2011-2013.</P> <P>desired outcome will look like:</P> <P>coname&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; year&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ROA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ROA_pre&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ROA_post</P> <P>company A&nbsp;&nbsp;&nbsp; 2007&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 14&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</P> <P>company A&nbsp;&nbsp;&nbsp;&nbsp; 2008&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 14&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</P> <P>company A&nbsp;&nbsp;&nbsp;&nbsp; 2009&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 17&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 14&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</P> <P>compnay A&nbsp;&nbsp;&nbsp;&nbsp; 2010&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 14&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</P> <P>company A&nbsp;&nbsp;&nbsp;&nbsp; 2011&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3</P> <P>company A&nbsp;&nbsp;&nbsp;&nbsp; 2012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -2 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3</P> <P>company A&nbsp;&nbsp;&nbsp;&nbsp; 2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3</P> <P>company B&nbsp;&nbsp;&nbsp;&nbsp; 2007&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</P> <P>company B&nbsp;&nbsp;&nbsp;&nbsp; 2008&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8</P> <P>&nbsp;</P> <P>Will proc summary be the answer?</P> <P>&nbsp;</P> <P>Please help me. I know nothing but the fact that I know nothing...</P> <HR /></BLOCKQUOTE> <P>&nbsp;</P> Thu, 21 Jun 2018 15:26:05 GMT https://communities.sas.com/t5/SAS-Programming/I-want-to-selectively-add-a-few-data-to-make-a-new-variable/m-p/472155#M121013 Reeza 2018-06-21T15:26:05Z https://communities.sas.com/t5/SAS-Programming/I-want-to-selectively-add-a-few-data-to-make-a-new-variable/m-p/472156#M121014 by averaging desired years' data (2007-2010 vs. 2011-2013) Thu, 21 Jun 2018 15:27:23 GMT https://communities.sas.com/t5/SAS-Programming/I-want-to-selectively-add-a-few-data-to-make-a-new-variable/m-p/472156#M121014 ESJ 2018-06-21T15:27:23Z https://communities.sas.com/t5/SAS-Programming/I-want-to-selectively-add-a-few-data-to-make-a-new-variable/m-p/472159#M121016 <P>So first calculate your averages for the respective time periods and then merge them across.&nbsp;</P> <P>&nbsp;</P> <P>Here's a basic example of how that works to get started:</P> <P><A href="https://github.com/statgeek/SAS-Tutorials/blob/master/add_average_value_to_dataset.sas" target="_blank">https://github.com/statgeek/SAS-Tutorials/blob/master/add_average_value_to_dataset.sas</A></P> <P>&nbsp;</P> <P>I would do two passes - one PROC MEANS for the first years of interest and a second for the later period and then merge based on dates.&nbsp;</P> <P>&nbsp;</P> <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/216942">@ESJ</a>&nbsp;wrote:<BR /> <P>Hi, I'm a poor beginner who's lost in nowhere.</P> <P>&nbsp;</P> <P>My situation is:</P> <P>coname&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; year&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ROA</P> <P>company A&nbsp;&nbsp;&nbsp;&nbsp; 2007&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20</P> <P>company A&nbsp;&nbsp;&nbsp;&nbsp; 2008&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10</P> <P>company A&nbsp;&nbsp;&nbsp;&nbsp; 2009&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15</P> <P>compnay A&nbsp;&nbsp;&nbsp;&nbsp; 2010&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9</P> <P>company A&nbsp;&nbsp;&nbsp;&nbsp; 2011&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P> <P>company A&nbsp;&nbsp;&nbsp;&nbsp; 2012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -4</P> <P>company A&nbsp;&nbsp;&nbsp;&nbsp; 2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10</P> <P>company B&nbsp;&nbsp;&nbsp;&nbsp; 2007&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</P> <P>company B&nbsp;&nbsp;&nbsp;&nbsp; 2008&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8.&nbsp; ... similar for company B too.</P> <P>&nbsp;</P> <P>like this. I want to make comparison between company-year average of 2007-2010 and 2011-2013.</P> <P>desired outcome will look like:</P> <P>coname&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; year&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ROA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ROA_pre&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ROA_post</P> <P>company A&nbsp;&nbsp;&nbsp; 2007&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 14&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</P> <P>company A&nbsp;&nbsp;&nbsp;&nbsp; 2008&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 14&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</P> <P>company A&nbsp;&nbsp;&nbsp;&nbsp; 2009&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 17&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 14&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</P> <P>compnay A&nbsp;&nbsp;&nbsp;&nbsp; 2010&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 14&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</P> <P>company A&nbsp;&nbsp;&nbsp;&nbsp; 2011&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3</P> <P>company A&nbsp;&nbsp;&nbsp;&nbsp; 2012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -2 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3</P> <P>company A&nbsp;&nbsp;&nbsp;&nbsp; 2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3</P> <P>company B&nbsp;&nbsp;&nbsp;&nbsp; 2007&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</P> <P>company B&nbsp;&nbsp;&nbsp;&nbsp; 2008&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8</P> <P>&nbsp;</P> <P>Will proc summary be the answer?</P> <P>&nbsp;</P> <P>Please help me. I know nothing but the fact that I know nothing...</P> <HR /></BLOCKQUOTE> <P>&nbsp;</P> Thu, 21 Jun 2018 15:32:39 GMT https://communities.sas.com/t5/SAS-Programming/I-want-to-selectively-add-a-few-data-to-make-a-new-variable/m-p/472159#M121016 Reeza 2018-06-21T15:32:39Z https://communities.sas.com/t5/SAS-Programming/I-want-to-selectively-add-a-few-data-to-make-a-new-variable/m-p/472165#M121018 thanks for the reply... but there're more than one thousand companies in the list, and I have to compute roa_pre and roa_post differently. I don't know if proc means will help me identify all of them... Thu, 21 Jun 2018 15:42:01 GMT https://communities.sas.com/t5/SAS-Programming/I-want-to-selectively-add-a-few-data-to-make-a-new-variable/m-p/472165#M121018 ESJ 2018-06-21T15:42:01Z https://communities.sas.com/t5/SAS-Programming/I-want-to-selectively-add-a-few-data-to-make-a-new-variable/m-p/472168#M121019 <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/216942">@ESJ</a>&nbsp;wrote:<BR />thanks for the reply... but there're more than one thousand companies in the list, and <STRONG>I have to compute roa_pre and roa_post differently</STRONG>. I don't know if proc means will help me identify all of them...<HR /></BLOCKQUOTE> <P>You said the logic was the year groupings? Perhaps it would help if you produced an example that's more reflective of your situation then.&nbsp;</P> <P>&nbsp;</P> <P>You can also use an array method to calculate moving averages and then merging the data.</P> <P><A href="http://support.sas.com/kb/25/027.html" target="_blank">http://support.sas.com/kb/25/027.html</A></P> Thu, 21 Jun 2018 15:44:34 GMT https://communities.sas.com/t5/SAS-Programming/I-want-to-selectively-add-a-few-data-to-make-a-new-variable/m-p/472168#M121019 Reeza 2018-06-21T15:44:34Z https://communities.sas.com/t5/SAS-Programming/I-want-to-selectively-add-a-few-data-to-make-a-new-variable/m-p/472173#M121022 yeah... that's my fault... I'll elaborate more on the example. thanks!! Thu, 21 Jun 2018 15:48:28 GMT https://communities.sas.com/t5/SAS-Programming/I-want-to-selectively-add-a-few-data-to-make-a-new-variable/m-p/472173#M121022 ESJ 2018-06-21T15:48:28Z https://communities.sas.com/t5/SAS-Programming/I-want-to-selectively-add-a-few-data-to-make-a-new-variable/m-p/472177#M121025 <PRE><CODE class=" language-sas">data have; input coname &amp; $20. year ROA; cards; company A 2007 20 company A 2008 10 company A 2009 17 company A 2010 9 company A 2011 1 company A 2012 -2 company A 2013 10 company B 2007 2 company B 2008 8 ; run; proc sql; create table want(drop=f:) as select *, 2007&lt;=year&lt;=2010 as f1, 2011&lt;=year&lt;=2013 as f2, mean(roa)*calculated f1 as ROA_pre, mean(roa)* calculated f2 as ROA_post from have group by coname,f1 order by coname, year; quit;</CODE></PRE> Thu, 21 Jun 2018 15:51:58 GMT https://communities.sas.com/t5/SAS-Programming/I-want-to-selectively-add-a-few-data-to-make-a-new-variable/m-p/472177#M121025 novinosrin 2018-06-21T15:51:58Z https://communities.sas.com/t5/SAS-Programming/I-want-to-selectively-add-a-few-data-to-make-a-new-variable/m-p/472182#M121029 <P>I suspect the years are not consistent across all groups.</P> Thu, 21 Jun 2018 15:58:42 GMT https://communities.sas.com/t5/SAS-Programming/I-want-to-selectively-add-a-few-data-to-make-a-new-variable/m-p/472182#M121029 Reeza 2018-06-21T15:58:42Z https://communities.sas.com/t5/SAS-Programming/I-want-to-selectively-add-a-few-data-to-make-a-new-variable/m-p/472190#M121033 thank you so much! But I don't understand some syntax... let me first try it...! Thu, 21 Jun 2018 16:10:20 GMT https://communities.sas.com/t5/SAS-Programming/I-want-to-selectively-add-a-few-data-to-make-a-new-variable/m-p/472190#M121033 ESJ 2018-06-21T16:10:20Z https://communities.sas.com/t5/SAS-Programming/I-want-to-selectively-add-a-few-data-to-make-a-new-variable/m-p/472193#M121035 <P>Hi&nbsp;<a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/216942">@ESJ</a>&nbsp;,&nbsp;<a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/13879">@Reeza</a>&nbsp;has a point. We trust your sample is a good representative of your real, if not we are gonna go back and forth and thread will keep getting longer. Therefore, if anything at all, we would like you provide us the best representative sample so that the solutions will make sense. Cheers!</P> Thu, 21 Jun 2018 16:18:28 GMT https://communities.sas.com/t5/SAS-Programming/I-want-to-selectively-add-a-few-data-to-make-a-new-variable/m-p/472193#M121035 novinosrin 2018-06-21T16:18:28Z https://communities.sas.com/t5/SAS-Programming/I-want-to-selectively-add-a-few-data-to-make-a-new-variable/m-p/472198#M121036 It perfectly worked! Thank you so much!! Thu, 21 Jun 2018 16:25:06 GMT https://communities.sas.com/t5/SAS-Programming/I-want-to-selectively-add-a-few-data-to-make-a-new-variable/m-p/472198#M121036 ESJ 2018-06-21T16:25:06Z https://communities.sas.com/t5/SAS-Programming/I-want-to-selectively-add-a-few-data-to-make-a-new-variable/m-p/472201#M121037 <P><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/216942">@ESJ</a>&nbsp; You're welcome. If you don't mind, Can you please mark the solution as answered and close the thread. I myself am content that I used a boolean group by expression which my professor often says I am <U>poor</U> at. I would like take a print of this thread and show it to him <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span>&nbsp; Thank you!</P> Thu, 21 Jun 2018 16:28:31 GMT https://communities.sas.com/t5/SAS-Programming/I-want-to-selectively-add-a-few-data-to-make-a-new-variable/m-p/472201#M121037 novinosrin 2018-06-21T16:28:31Z https://communities.sas.com/t5/SAS-Programming/I-want-to-selectively-add-a-few-data-to-make-a-new-variable/m-p/472204#M121039 that's true... but that probably is enough for my problem. Big thanks! Thu, 21 Jun 2018 16:32:15 GMT https://communities.sas.com/t5/SAS-Programming/I-want-to-selectively-add-a-few-data-to-make-a-new-variable/m-p/472204#M121039 ESJ 2018-06-21T16:32:15Z