topic data manipulation in SAS in New SAS User https://communities.sas.com/t5/New-SAS-User/data-manipulation-in-SAS/m-p/612952#M18334 <P>I have the below table</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Q</TD><TD>X</TD><TD>Y</TD></TR><TR><TD>2005Q1</TD><TD>3.0961169887314500</TD><TD>129.1040486000000000</TD></TR><TR><TD>2005Q2</TD><TD>3.4104085945044000</TD><TD>129.9512334000000000</TD></TR><TR><TD>2005Q3</TD><TD>3.6573427695665400</TD><TD>128.8106877000000000</TD></TR><TR><TD>2005Q4</TD><TD>2.8444518343448300</TD><TD>130.0207229000000000</TD></TR><TR><TD>2006Q1</TD><TD>2.5487945793408100</TD><TD>132.8182149000000000</TD></TR><TR><TD>2006Q2</TD><TD>2.9662275149639800</TD><TD>132.6883096000000000</TD></TR><TR><TD>2006Q3</TD><TD>1.7026102303690900</TD><TD>134.6323000000000000</TD></TR><TR><TD>2006Q4</TD><TD>2.1814444418781900</TD><TD>137.5530985000000000</TD></TR><TR><TD>2007Q1</TD><TD>2.2305773056005900</TD><TD>138.7841262000000000</TD></TR><TR><TD>2007Q2</TD><TD>1.0829475601426700</TD><TD>140.2329980000000000</TD></TR><TR><TD>2007Q3</TD><TD>2.4291482568206800</TD><TD>141.7630128000000000</TD></TR><TR><TD>2007Q4</TD><TD>2.3145689002407200</TD><TD>142.2002388000000000</TD></TR><TR><TD>2008Q1</TD><TD>3.2065052354548800</TD><TD>146.0547948000000000</TD></TR><TR><TD>2008Q2</TD><TD>4.0342500206461100</TD><TD>144.6496579000000000</TD></TR><TR><TD>2008Q3</TD><TD>2.6762028608582600</TD><TD>145.2911509000000000</TD></TR><TR><TD>2008Q4</TD><TD>0.9543692215926040</TD><TD>143.1153248000000000</TD></TR><TR><TD>2009Q1</TD><TD>-1.8238815512256100</TD><TD>146.1963144000000000</TD></TR><TR><TD>2009Q2</TD><TD>-4.6979696255696600</TD><TD>139.5495951000000000</TD></TR><TR><TD>2009Q3</TD><TD>-4.7265634894500900</TD><TD>139.9400998000000000</TD></TR><TR><TD>2009Q4</TD><TD>-5.1490781771431700</TD><TD>138.4258302000000000</TD></TR><TR><TD>2010Q1</TD><TD>-3.2981710949380400</TD><TD>138.7433644000000000</TD></TR><TR><TD>2010Q2</TD><TD>-0.6637109506627640</TD><TD>138.5053422000000000</TD></TR><TR><TD>2010Q3</TD><TD>-1.0106688037190800</TD><TD>136.1648689000000000</TD></TR><TR><TD>2010Q4</TD><TD>1.9894873244202500</TD><TD>136.0056812000000000</TD></TR><TR><TD>2011Q1</TD><TD>1.3946441074851600</TD><TD>136.5675436000000000</TD></TR><TR><TD>2011Q2</TD><TD>0.2637516770337850</TD><TD>135.7307409000000000</TD></TR><TR><TD>2011Q3</TD><TD>0.6349998081571580</TD><TD>135.0126337000000000</TD></TR><TR><TD>2011Q4</TD><TD>-1.8718825520941300</TD><TD>135.5315841000000000</TD></TR><TR><TD>2012Q1</TD><TD>-1.5735730296375100</TD><TD>133.7159334000000000</TD></TR><TR><TD>2012Q2</TD><TD>0.0737474340454649</TD><TD>131.0825881000000000</TD></TR><TR><TD>2012Q3</TD><TD>0.8757649122138130</TD><TD>131.3026443000000000</TD></TR><TR><TD>2012Q4</TD><TD>2.1949776391215500</TD><TD>131.2321800000000000</TD></TR><TR><TD>2013Q1</TD><TD>2.2888295914611700</TD><TD>133.3959875000000000</TD></TR><TR><TD>2013Q2</TD><TD>2.2423211043327000</TD><TD>130.0202857000000000</TD></TR><TR><TD>2013Q3</TD><TD>1.6493941386791200</TD><TD>128.8410652000000000</TD></TR><TR><TD>2013Q4</TD><TD>1.3714852869855500</TD><TD>129.9515952000000000</TD></TR><TR><TD>2014Q1</TD><TD>1.8515603331309400</TD><TD>131.1145455000000000</TD></TR><TR><TD>2014Q2</TD><TD>1.6826610491274600</TD><TD>128.6410867000000000</TD></TR><TR><TD>2014Q3</TD><TD>1.9375636744922800</TD><TD>129.2113542000000000</TD></TR><TR><TD>2014Q4</TD><TD>2.0727867466260200</TD><TD>127.6074090000000000</TD></TR><TR><TD>2015Q1</TD><TD>2.6981475075623200</TD><TD>129.5360682000000000</TD></TR><TR><TD>2015Q2</TD><TD>1.8309303362247200</TD><TD>127.6828525000000000</TD></TR><TR><TD>2015Q3</TD><TD>2.4591748523656200</TD><TD>126.9790237000000000</TD></TR><TR><TD>2015Q4</TD><TD>2.8082375938319800</TD><TD>128.7339383000000000</TD></TR><TR><TD>2016Q1</TD><TD>2.1797086077527800</TD><TD>127.1332319000000000</TD></TR><TR><TD>2016Q2</TD><TD>2.8992059476779400</TD><TD>127.5594986000000000</TD></TR><TR><TD>2016Q3</TD><TD>2.8316227540859900</TD><TD>127.3998496655820000</TD></TR><TR><TD>2016Q4</TD><TD>2.7991376720679900</TD><TD>129.7261627099590000</TD></TR><TR><TD>2017Q1</TD><TD>3.1665559934047400</TD><TD>130.6954598117830000</TD></TR><TR><TD>2017Q2</TD><TD>2.6113366854055600</TD><TD>128.7454621128200000</TD></TR><TR><TD>2017Q3</TD><TD>2.5752992836911800</TD><TD>129.8059871771680000</TD></TR><TR><TD>2017Q4</TD><TD>2.2356650307510500</TD><TD>129.5437067849100000</TD></TR><TR><TD>2018Q1</TD><TD>1.5478877781360700</TD><TD>129.5208997942790000</TD></TR><TR><TD>2018Q2</TD><TD>1.8491368391964500</TD><TD>128.4945852158770000</TD></TR><TR><TD>2018Q3</TD><TD>1.4698034671504900</TD><TD>128.6656376456110000</TD></TR><TR><TD>2018Q4</TD><TD>1.5943184839162900</TD><TD>128.8594970659750000</TD></TR><TR><TD>2019Q1</TD><TD>1.6437568993936300</TD><TD>128.9393215331840000</TD></TR><TR><TD>2019Q2</TD><TD>1.7462279366323500</TD><TD>129.0875669722870000</TD></TR><TR><TD>2019Q3</TD><TD>1.7565476101035200</TD><TD>128.9963390097620000</TD></TR><TR><TD>2019Q4</TD><TD>1.7562091600998800</TD><TD>128.7454621128200000</TD></TR><TR><TD>2020Q1</TD><TD>1.6097357771958900</TD><TD>128.6656376456110000</TD></TR><TR><TD>2020Q2</TD><TD>1.5710761983067100</TD><TD>128.5972166737170000</TD></TR><TR><TD>2020Q3</TD><TD>1.4759303012403900</TD><TD>128.4033572533520000</TD></TR><TR><TD>2020Q4</TD><TD>1.2901993343276700</TD><TD>128.2323048236190000</TD></TR><TR><TD>2021Q1</TD><TD>1.2299042431696100</TD><TD>128.1182698704630000</TD></TR><TR><TD>2021Q2</TD><TD>1.0807736063708800</TD><TD>127.9586209360450000</TD></TR><TR><TD>2021Q3</TD><TD>1.2187224877945900</TD><TD>127.6393230672090000</TD></TR><TR><TD>2021Q4</TD><TD>1.3542822739175500</TD><TD>127.3086217030570000</TD></TR><TR><TD>2022Q1</TD><TD>1.5519685267146900</TD><TD>127.0463413107990000</TD></TR><TR><TD>2022Q2</TD><TD>1.7069968111048300</TD><TD>126.7612539279100000</TD></TR><TR><TD>2022Q3</TD><TD>1.7187342754862500</TD><TD>126.4305525637580000</TD></TR><TR><TD>2022Q4</TD><TD>1.7076277858093500</TD><TD>126.0884477042910000</TD></TR><TR><TD>2023Q1</TD><TD>1.6364957058010700</TD><TD>125.7235358541930000</TD></TR><TR><TD>2023Q2</TD><TD>1.6577760122577200</TD><TD>125.3586240040940000</TD></TR><TR><TD>2023Q3</TD><TD>1.7207872513338600</TD><TD>125.0051156493120000</TD></TR><TR><TD>2023Q4</TD><TD>1.7387694213015000</TD><TD>124.6858177804760000</TD></TR><TR><TD>2024Q1</TD><TD>1.7825112107623100</TD><TD>124.4007303975860000</TD></TR><TR><TD>2024Q2</TD><TD>1.8435687919111800</TD><TD>124.1384500053280000</TD></TR><TR><TD>2024Q3</TD><TD>1.8556342920661300</TD><TD>123.8989766037010000</TD></TR><TR><TD>2024Q4</TD><TD>1.9276125132277100</TD><TD>123.6709066973900000</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I want all values of X and Y from 2015 q1 to be replaced with the values from 2005 q1 to 2014 q4.</P><P>&nbsp;</P><P>The output has to be like below</P><P>&nbsp;</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Q</TD><TD>X</TD><TD>Y</TD></TR><TR><TD>2005Q1</TD><TD>3.0961169887314500</TD><TD>129.1040486000000000</TD></TR><TR><TD>2005Q2</TD><TD>3.4104085945044000</TD><TD>129.9512334000000000</TD></TR><TR><TD>2005Q3</TD><TD>3.6573427695665400</TD><TD>128.8106877000000000</TD></TR><TR><TD>2005Q4</TD><TD>2.8444518343448300</TD><TD>130.0207229000000000</TD></TR><TR><TD>2006Q1</TD><TD>2.5487945793408100</TD><TD>132.8182149000000000</TD></TR><TR><TD>2006Q2</TD><TD>2.9662275149639800</TD><TD>132.6883096000000000</TD></TR><TR><TD>2006Q3</TD><TD>1.7026102303690900</TD><TD>134.6323000000000000</TD></TR><TR><TD>2006Q4</TD><TD>2.1814444418781900</TD><TD>137.5530985000000000</TD></TR><TR><TD>2007Q1</TD><TD>2.2305773056005900</TD><TD>138.7841262000000000</TD></TR><TR><TD>2007Q2</TD><TD>1.0829475601426700</TD><TD>140.2329980000000000</TD></TR><TR><TD>2007Q3</TD><TD>2.4291482568206800</TD><TD>141.7630128000000000</TD></TR><TR><TD>2007Q4</TD><TD>2.3145689002407200</TD><TD>142.2002388000000000</TD></TR><TR><TD>2008Q1</TD><TD>3.2065052354548800</TD><TD>146.0547948000000000</TD></TR><TR><TD>2008Q2</TD><TD>4.0342500206461100</TD><TD>144.6496579000000000</TD></TR><TR><TD>2008Q3</TD><TD>2.6762028608582600</TD><TD>145.2911509000000000</TD></TR><TR><TD>2008Q4</TD><TD>0.9543692215926040</TD><TD>143.1153248000000000</TD></TR><TR><TD>2009Q1</TD><TD>-1.8238815512256100</TD><TD>146.1963144000000000</TD></TR><TR><TD>2009Q2</TD><TD>-4.6979696255696600</TD><TD>139.5495951000000000</TD></TR><TR><TD>2009Q3</TD><TD>-4.7265634894500900</TD><TD>139.9400998000000000</TD></TR><TR><TD>2009Q4</TD><TD>-5.1490781771431700</TD><TD>138.4258302000000000</TD></TR><TR><TD>2010Q1</TD><TD>-3.2981710949380400</TD><TD>138.7433644000000000</TD></TR><TR><TD>2010Q2</TD><TD>-0.6637109506627640</TD><TD>138.5053422000000000</TD></TR><TR><TD>2010Q3</TD><TD>-1.0106688037190800</TD><TD>136.1648689000000000</TD></TR><TR><TD>2010Q4</TD><TD>1.9894873244202500</TD><TD>136.0056812000000000</TD></TR><TR><TD>2011Q1</TD><TD>1.3946441074851600</TD><TD>136.5675436000000000</TD></TR><TR><TD>2011Q2</TD><TD>0.2637516770337850</TD><TD>135.7307409000000000</TD></TR><TR><TD>2011Q3</TD><TD>0.6349998081571580</TD><TD>135.0126337000000000</TD></TR><TR><TD>2011Q4</TD><TD>-1.8718825520941300</TD><TD>135.5315841000000000</TD></TR><TR><TD>2012Q1</TD><TD>-1.5735730296375100</TD><TD>133.7159334000000000</TD></TR><TR><TD>2012Q2</TD><TD>0.0737474340454649</TD><TD>131.0825881000000000</TD></TR><TR><TD>2012Q3</TD><TD>0.8757649122138130</TD><TD>131.3026443000000000</TD></TR><TR><TD>2012Q4</TD><TD>2.1949776391215500</TD><TD>131.2321800000000000</TD></TR><TR><TD>2013Q1</TD><TD>2.2888295914611700</TD><TD>133.3959875000000000</TD></TR><TR><TD>2013Q2</TD><TD>2.2423211043327000</TD><TD>130.0202857000000000</TD></TR><TR><TD>2013Q3</TD><TD>1.6493941386791200</TD><TD>128.8410652000000000</TD></TR><TR><TD>2013Q4</TD><TD>1.3714852869855500</TD><TD>129.9515952000000000</TD></TR><TR><TD>2014Q1</TD><TD>1.8515603331309400</TD><TD>131.1145455000000000</TD></TR><TR><TD>2014Q2</TD><TD>1.6826610491274600</TD><TD>128.6410867000000000</TD></TR><TR><TD>2014Q3</TD><TD>1.9375636744922800</TD><TD>129.2113542000000000</TD></TR><TR><TD>2014Q4</TD><TD>2.0727867466260200</TD><TD>127.6074090000000000</TD></TR><TR><TD><FONT color="#ff0000">2015Q1</FONT></TD><TD><FONT color="#ff0000">3.0961169887314500</FONT></TD><TD><FONT color="#ff0000">129.1040486000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2015Q2</FONT></TD><TD><FONT color="#ff0000">3.4104085945044000</FONT></TD><TD><FONT color="#ff0000">129.9512334000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2015Q3</FONT></TD><TD><FONT color="#ff0000">3.6573427695665400</FONT></TD><TD><FONT color="#ff0000">128.8106877000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2015Q4</FONT></TD><TD><FONT color="#ff0000">2.8444518343448300</FONT></TD><TD><FONT color="#ff0000">130.0207229000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2016Q1</FONT></TD><TD><FONT color="#ff0000">2.5487945793408100</FONT></TD><TD><FONT color="#ff0000">132.8182149000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2016Q2</FONT></TD><TD><FONT color="#ff0000">2.9662275149639800</FONT></TD><TD><FONT color="#ff0000">132.6883096000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2016Q3</FONT></TD><TD><FONT color="#ff0000">1.7026102303690900</FONT></TD><TD><FONT color="#ff0000">134.6323000000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2016Q4</FONT></TD><TD><FONT color="#ff0000">2.1814444418781900</FONT></TD><TD><FONT color="#ff0000">137.5530985000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2017Q1</FONT></TD><TD><FONT color="#ff0000">2.2305773056005900</FONT></TD><TD><FONT color="#ff0000">138.7841262000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2017Q2</FONT></TD><TD><FONT color="#ff0000">1.0829475601426700</FONT></TD><TD><FONT color="#ff0000">140.2329980000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2017Q3</FONT></TD><TD><FONT color="#ff0000">2.4291482568206800</FONT></TD><TD><FONT color="#ff0000">141.7630128000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2017Q4</FONT></TD><TD><FONT color="#ff0000">2.3145689002407200</FONT></TD><TD><FONT color="#ff0000">142.2002388000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2018Q1</FONT></TD><TD><FONT color="#ff0000">3.2065052354548800</FONT></TD><TD><FONT color="#ff0000">146.0547948000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2018Q2</FONT></TD><TD><FONT color="#ff0000">4.0342500206461100</FONT></TD><TD><FONT color="#ff0000">144.6496579000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2018Q3</FONT></TD><TD><FONT color="#ff0000">2.6762028608582600</FONT></TD><TD><FONT color="#ff0000">145.2911509000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2018Q4</FONT></TD><TD><FONT color="#ff0000">0.9543692215926040</FONT></TD><TD><FONT color="#ff0000">143.1153248000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2019Q1</FONT></TD><TD><FONT color="#ff0000">-1.8238815512256100</FONT></TD><TD><FONT color="#ff0000">146.1963144000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2019Q2</FONT></TD><TD><FONT color="#ff0000">-4.6979696255696600</FONT></TD><TD><FONT color="#ff0000">139.5495951000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2019Q3</FONT></TD><TD><FONT color="#ff0000">-4.7265634894500900</FONT></TD><TD><FONT color="#ff0000">139.9400998000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2019Q4</FONT></TD><TD><FONT color="#ff0000">-5.1490781771431700</FONT></TD><TD><FONT color="#ff0000">138.4258302000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2020Q1</FONT></TD><TD><FONT color="#ff0000">-3.2981710949380400</FONT></TD><TD><FONT color="#ff0000">138.7433644000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2020Q2</FONT></TD><TD><FONT color="#ff0000">-0.6637109506627640</FONT></TD><TD><FONT color="#ff0000">138.5053422000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2020Q3</FONT></TD><TD><FONT color="#ff0000">-1.0106688037190800</FONT></TD><TD><FONT color="#ff0000">136.1648689000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2020Q4</FONT></TD><TD><FONT color="#ff0000">1.9894873244202500</FONT></TD><TD><FONT color="#ff0000">136.0056812000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2021Q1</FONT></TD><TD><FONT color="#ff0000">1.3946441074851600</FONT></TD><TD><FONT color="#ff0000">136.5675436000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2021Q2</FONT></TD><TD><FONT color="#ff0000">0.2637516770337850</FONT></TD><TD><FONT color="#ff0000">135.7307409000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2021Q3</FONT></TD><TD><FONT color="#ff0000">0.6349998081571580</FONT></TD><TD><FONT color="#ff0000">135.0126337000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2021Q4</FONT></TD><TD><FONT color="#ff0000">-1.8718825520941300</FONT></TD><TD><FONT color="#ff0000">135.5315841000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2022Q1</FONT></TD><TD><FONT color="#ff0000">-1.5735730296375100</FONT></TD><TD><FONT color="#ff0000">133.7159334000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2022Q2</FONT></TD><TD><FONT color="#ff0000">0.0737474340454649</FONT></TD><TD><FONT color="#ff0000">131.0825881000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2022Q3</FONT></TD><TD><FONT color="#ff0000">0.8757649122138130</FONT></TD><TD><FONT color="#ff0000">131.3026443000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2022Q4</FONT></TD><TD><FONT color="#ff0000">2.1949776391215500</FONT></TD><TD><FONT color="#ff0000">131.2321800000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2023Q1</FONT></TD><TD><FONT color="#ff0000">2.2888295914611700</FONT></TD><TD><FONT color="#ff0000">133.3959875000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2023Q2</FONT></TD><TD><FONT color="#ff0000">2.2423211043327000</FONT></TD><TD><FONT color="#ff0000">130.0202857000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2023Q3</FONT></TD><TD><FONT color="#ff0000">1.6493941386791200</FONT></TD><TD><FONT color="#ff0000">128.8410652000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2023Q4</FONT></TD><TD><FONT color="#ff0000">1.3714852869855500</FONT></TD><TD><FONT color="#ff0000">129.9515952000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2024Q1</FONT></TD><TD><FONT color="#ff0000">1.8515603331309400</FONT></TD><TD><FONT color="#ff0000">131.1145455000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2024Q2</FONT></TD><TD><FONT color="#ff0000">1.6826610491274600</FONT></TD><TD><FONT color="#ff0000">128.6410867000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2024Q3</FONT></TD><TD><FONT color="#ff0000">1.9375636744922800</FONT></TD><TD><FONT color="#ff0000">129.2113542000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2024Q4</FONT></TD><TD><FONT color="#ff0000">2.0727867466260200</FONT></TD><TD><FONT color="#ff0000">127.6074090000000000</FONT></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P><P>any help will be appreciated</P> Thu, 19 Dec 2019 08:56:24 GMT npr 2019-12-19T08:56:24Z data manipulation in SAS https://communities.sas.com/t5/New-SAS-User/data-manipulation-in-SAS/m-p/612952#M18334 <P>I have the below table</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Q</TD><TD>X</TD><TD>Y</TD></TR><TR><TD>2005Q1</TD><TD>3.0961169887314500</TD><TD>129.1040486000000000</TD></TR><TR><TD>2005Q2</TD><TD>3.4104085945044000</TD><TD>129.9512334000000000</TD></TR><TR><TD>2005Q3</TD><TD>3.6573427695665400</TD><TD>128.8106877000000000</TD></TR><TR><TD>2005Q4</TD><TD>2.8444518343448300</TD><TD>130.0207229000000000</TD></TR><TR><TD>2006Q1</TD><TD>2.5487945793408100</TD><TD>132.8182149000000000</TD></TR><TR><TD>2006Q2</TD><TD>2.9662275149639800</TD><TD>132.6883096000000000</TD></TR><TR><TD>2006Q3</TD><TD>1.7026102303690900</TD><TD>134.6323000000000000</TD></TR><TR><TD>2006Q4</TD><TD>2.1814444418781900</TD><TD>137.5530985000000000</TD></TR><TR><TD>2007Q1</TD><TD>2.2305773056005900</TD><TD>138.7841262000000000</TD></TR><TR><TD>2007Q2</TD><TD>1.0829475601426700</TD><TD>140.2329980000000000</TD></TR><TR><TD>2007Q3</TD><TD>2.4291482568206800</TD><TD>141.7630128000000000</TD></TR><TR><TD>2007Q4</TD><TD>2.3145689002407200</TD><TD>142.2002388000000000</TD></TR><TR><TD>2008Q1</TD><TD>3.2065052354548800</TD><TD>146.0547948000000000</TD></TR><TR><TD>2008Q2</TD><TD>4.0342500206461100</TD><TD>144.6496579000000000</TD></TR><TR><TD>2008Q3</TD><TD>2.6762028608582600</TD><TD>145.2911509000000000</TD></TR><TR><TD>2008Q4</TD><TD>0.9543692215926040</TD><TD>143.1153248000000000</TD></TR><TR><TD>2009Q1</TD><TD>-1.8238815512256100</TD><TD>146.1963144000000000</TD></TR><TR><TD>2009Q2</TD><TD>-4.6979696255696600</TD><TD>139.5495951000000000</TD></TR><TR><TD>2009Q3</TD><TD>-4.7265634894500900</TD><TD>139.9400998000000000</TD></TR><TR><TD>2009Q4</TD><TD>-5.1490781771431700</TD><TD>138.4258302000000000</TD></TR><TR><TD>2010Q1</TD><TD>-3.2981710949380400</TD><TD>138.7433644000000000</TD></TR><TR><TD>2010Q2</TD><TD>-0.6637109506627640</TD><TD>138.5053422000000000</TD></TR><TR><TD>2010Q3</TD><TD>-1.0106688037190800</TD><TD>136.1648689000000000</TD></TR><TR><TD>2010Q4</TD><TD>1.9894873244202500</TD><TD>136.0056812000000000</TD></TR><TR><TD>2011Q1</TD><TD>1.3946441074851600</TD><TD>136.5675436000000000</TD></TR><TR><TD>2011Q2</TD><TD>0.2637516770337850</TD><TD>135.7307409000000000</TD></TR><TR><TD>2011Q3</TD><TD>0.6349998081571580</TD><TD>135.0126337000000000</TD></TR><TR><TD>2011Q4</TD><TD>-1.8718825520941300</TD><TD>135.5315841000000000</TD></TR><TR><TD>2012Q1</TD><TD>-1.5735730296375100</TD><TD>133.7159334000000000</TD></TR><TR><TD>2012Q2</TD><TD>0.0737474340454649</TD><TD>131.0825881000000000</TD></TR><TR><TD>2012Q3</TD><TD>0.8757649122138130</TD><TD>131.3026443000000000</TD></TR><TR><TD>2012Q4</TD><TD>2.1949776391215500</TD><TD>131.2321800000000000</TD></TR><TR><TD>2013Q1</TD><TD>2.2888295914611700</TD><TD>133.3959875000000000</TD></TR><TR><TD>2013Q2</TD><TD>2.2423211043327000</TD><TD>130.0202857000000000</TD></TR><TR><TD>2013Q3</TD><TD>1.6493941386791200</TD><TD>128.8410652000000000</TD></TR><TR><TD>2013Q4</TD><TD>1.3714852869855500</TD><TD>129.9515952000000000</TD></TR><TR><TD>2014Q1</TD><TD>1.8515603331309400</TD><TD>131.1145455000000000</TD></TR><TR><TD>2014Q2</TD><TD>1.6826610491274600</TD><TD>128.6410867000000000</TD></TR><TR><TD>2014Q3</TD><TD>1.9375636744922800</TD><TD>129.2113542000000000</TD></TR><TR><TD>2014Q4</TD><TD>2.0727867466260200</TD><TD>127.6074090000000000</TD></TR><TR><TD>2015Q1</TD><TD>2.6981475075623200</TD><TD>129.5360682000000000</TD></TR><TR><TD>2015Q2</TD><TD>1.8309303362247200</TD><TD>127.6828525000000000</TD></TR><TR><TD>2015Q3</TD><TD>2.4591748523656200</TD><TD>126.9790237000000000</TD></TR><TR><TD>2015Q4</TD><TD>2.8082375938319800</TD><TD>128.7339383000000000</TD></TR><TR><TD>2016Q1</TD><TD>2.1797086077527800</TD><TD>127.1332319000000000</TD></TR><TR><TD>2016Q2</TD><TD>2.8992059476779400</TD><TD>127.5594986000000000</TD></TR><TR><TD>2016Q3</TD><TD>2.8316227540859900</TD><TD>127.3998496655820000</TD></TR><TR><TD>2016Q4</TD><TD>2.7991376720679900</TD><TD>129.7261627099590000</TD></TR><TR><TD>2017Q1</TD><TD>3.1665559934047400</TD><TD>130.6954598117830000</TD></TR><TR><TD>2017Q2</TD><TD>2.6113366854055600</TD><TD>128.7454621128200000</TD></TR><TR><TD>2017Q3</TD><TD>2.5752992836911800</TD><TD>129.8059871771680000</TD></TR><TR><TD>2017Q4</TD><TD>2.2356650307510500</TD><TD>129.5437067849100000</TD></TR><TR><TD>2018Q1</TD><TD>1.5478877781360700</TD><TD>129.5208997942790000</TD></TR><TR><TD>2018Q2</TD><TD>1.8491368391964500</TD><TD>128.4945852158770000</TD></TR><TR><TD>2018Q3</TD><TD>1.4698034671504900</TD><TD>128.6656376456110000</TD></TR><TR><TD>2018Q4</TD><TD>1.5943184839162900</TD><TD>128.8594970659750000</TD></TR><TR><TD>2019Q1</TD><TD>1.6437568993936300</TD><TD>128.9393215331840000</TD></TR><TR><TD>2019Q2</TD><TD>1.7462279366323500</TD><TD>129.0875669722870000</TD></TR><TR><TD>2019Q3</TD><TD>1.7565476101035200</TD><TD>128.9963390097620000</TD></TR><TR><TD>2019Q4</TD><TD>1.7562091600998800</TD><TD>128.7454621128200000</TD></TR><TR><TD>2020Q1</TD><TD>1.6097357771958900</TD><TD>128.6656376456110000</TD></TR><TR><TD>2020Q2</TD><TD>1.5710761983067100</TD><TD>128.5972166737170000</TD></TR><TR><TD>2020Q3</TD><TD>1.4759303012403900</TD><TD>128.4033572533520000</TD></TR><TR><TD>2020Q4</TD><TD>1.2901993343276700</TD><TD>128.2323048236190000</TD></TR><TR><TD>2021Q1</TD><TD>1.2299042431696100</TD><TD>128.1182698704630000</TD></TR><TR><TD>2021Q2</TD><TD>1.0807736063708800</TD><TD>127.9586209360450000</TD></TR><TR><TD>2021Q3</TD><TD>1.2187224877945900</TD><TD>127.6393230672090000</TD></TR><TR><TD>2021Q4</TD><TD>1.3542822739175500</TD><TD>127.3086217030570000</TD></TR><TR><TD>2022Q1</TD><TD>1.5519685267146900</TD><TD>127.0463413107990000</TD></TR><TR><TD>2022Q2</TD><TD>1.7069968111048300</TD><TD>126.7612539279100000</TD></TR><TR><TD>2022Q3</TD><TD>1.7187342754862500</TD><TD>126.4305525637580000</TD></TR><TR><TD>2022Q4</TD><TD>1.7076277858093500</TD><TD>126.0884477042910000</TD></TR><TR><TD>2023Q1</TD><TD>1.6364957058010700</TD><TD>125.7235358541930000</TD></TR><TR><TD>2023Q2</TD><TD>1.6577760122577200</TD><TD>125.3586240040940000</TD></TR><TR><TD>2023Q3</TD><TD>1.7207872513338600</TD><TD>125.0051156493120000</TD></TR><TR><TD>2023Q4</TD><TD>1.7387694213015000</TD><TD>124.6858177804760000</TD></TR><TR><TD>2024Q1</TD><TD>1.7825112107623100</TD><TD>124.4007303975860000</TD></TR><TR><TD>2024Q2</TD><TD>1.8435687919111800</TD><TD>124.1384500053280000</TD></TR><TR><TD>2024Q3</TD><TD>1.8556342920661300</TD><TD>123.8989766037010000</TD></TR><TR><TD>2024Q4</TD><TD>1.9276125132277100</TD><TD>123.6709066973900000</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I want all values of X and Y from 2015 q1 to be replaced with the values from 2005 q1 to 2014 q4.</P><P>&nbsp;</P><P>The output has to be like below</P><P>&nbsp;</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Q</TD><TD>X</TD><TD>Y</TD></TR><TR><TD>2005Q1</TD><TD>3.0961169887314500</TD><TD>129.1040486000000000</TD></TR><TR><TD>2005Q2</TD><TD>3.4104085945044000</TD><TD>129.9512334000000000</TD></TR><TR><TD>2005Q3</TD><TD>3.6573427695665400</TD><TD>128.8106877000000000</TD></TR><TR><TD>2005Q4</TD><TD>2.8444518343448300</TD><TD>130.0207229000000000</TD></TR><TR><TD>2006Q1</TD><TD>2.5487945793408100</TD><TD>132.8182149000000000</TD></TR><TR><TD>2006Q2</TD><TD>2.9662275149639800</TD><TD>132.6883096000000000</TD></TR><TR><TD>2006Q3</TD><TD>1.7026102303690900</TD><TD>134.6323000000000000</TD></TR><TR><TD>2006Q4</TD><TD>2.1814444418781900</TD><TD>137.5530985000000000</TD></TR><TR><TD>2007Q1</TD><TD>2.2305773056005900</TD><TD>138.7841262000000000</TD></TR><TR><TD>2007Q2</TD><TD>1.0829475601426700</TD><TD>140.2329980000000000</TD></TR><TR><TD>2007Q3</TD><TD>2.4291482568206800</TD><TD>141.7630128000000000</TD></TR><TR><TD>2007Q4</TD><TD>2.3145689002407200</TD><TD>142.2002388000000000</TD></TR><TR><TD>2008Q1</TD><TD>3.2065052354548800</TD><TD>146.0547948000000000</TD></TR><TR><TD>2008Q2</TD><TD>4.0342500206461100</TD><TD>144.6496579000000000</TD></TR><TR><TD>2008Q3</TD><TD>2.6762028608582600</TD><TD>145.2911509000000000</TD></TR><TR><TD>2008Q4</TD><TD>0.9543692215926040</TD><TD>143.1153248000000000</TD></TR><TR><TD>2009Q1</TD><TD>-1.8238815512256100</TD><TD>146.1963144000000000</TD></TR><TR><TD>2009Q2</TD><TD>-4.6979696255696600</TD><TD>139.5495951000000000</TD></TR><TR><TD>2009Q3</TD><TD>-4.7265634894500900</TD><TD>139.9400998000000000</TD></TR><TR><TD>2009Q4</TD><TD>-5.1490781771431700</TD><TD>138.4258302000000000</TD></TR><TR><TD>2010Q1</TD><TD>-3.2981710949380400</TD><TD>138.7433644000000000</TD></TR><TR><TD>2010Q2</TD><TD>-0.6637109506627640</TD><TD>138.5053422000000000</TD></TR><TR><TD>2010Q3</TD><TD>-1.0106688037190800</TD><TD>136.1648689000000000</TD></TR><TR><TD>2010Q4</TD><TD>1.9894873244202500</TD><TD>136.0056812000000000</TD></TR><TR><TD>2011Q1</TD><TD>1.3946441074851600</TD><TD>136.5675436000000000</TD></TR><TR><TD>2011Q2</TD><TD>0.2637516770337850</TD><TD>135.7307409000000000</TD></TR><TR><TD>2011Q3</TD><TD>0.6349998081571580</TD><TD>135.0126337000000000</TD></TR><TR><TD>2011Q4</TD><TD>-1.8718825520941300</TD><TD>135.5315841000000000</TD></TR><TR><TD>2012Q1</TD><TD>-1.5735730296375100</TD><TD>133.7159334000000000</TD></TR><TR><TD>2012Q2</TD><TD>0.0737474340454649</TD><TD>131.0825881000000000</TD></TR><TR><TD>2012Q3</TD><TD>0.8757649122138130</TD><TD>131.3026443000000000</TD></TR><TR><TD>2012Q4</TD><TD>2.1949776391215500</TD><TD>131.2321800000000000</TD></TR><TR><TD>2013Q1</TD><TD>2.2888295914611700</TD><TD>133.3959875000000000</TD></TR><TR><TD>2013Q2</TD><TD>2.2423211043327000</TD><TD>130.0202857000000000</TD></TR><TR><TD>2013Q3</TD><TD>1.6493941386791200</TD><TD>128.8410652000000000</TD></TR><TR><TD>2013Q4</TD><TD>1.3714852869855500</TD><TD>129.9515952000000000</TD></TR><TR><TD>2014Q1</TD><TD>1.8515603331309400</TD><TD>131.1145455000000000</TD></TR><TR><TD>2014Q2</TD><TD>1.6826610491274600</TD><TD>128.6410867000000000</TD></TR><TR><TD>2014Q3</TD><TD>1.9375636744922800</TD><TD>129.2113542000000000</TD></TR><TR><TD>2014Q4</TD><TD>2.0727867466260200</TD><TD>127.6074090000000000</TD></TR><TR><TD><FONT color="#ff0000">2015Q1</FONT></TD><TD><FONT color="#ff0000">3.0961169887314500</FONT></TD><TD><FONT color="#ff0000">129.1040486000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2015Q2</FONT></TD><TD><FONT color="#ff0000">3.4104085945044000</FONT></TD><TD><FONT color="#ff0000">129.9512334000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2015Q3</FONT></TD><TD><FONT color="#ff0000">3.6573427695665400</FONT></TD><TD><FONT color="#ff0000">128.8106877000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2015Q4</FONT></TD><TD><FONT color="#ff0000">2.8444518343448300</FONT></TD><TD><FONT color="#ff0000">130.0207229000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2016Q1</FONT></TD><TD><FONT color="#ff0000">2.5487945793408100</FONT></TD><TD><FONT color="#ff0000">132.8182149000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2016Q2</FONT></TD><TD><FONT color="#ff0000">2.9662275149639800</FONT></TD><TD><FONT color="#ff0000">132.6883096000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2016Q3</FONT></TD><TD><FONT color="#ff0000">1.7026102303690900</FONT></TD><TD><FONT color="#ff0000">134.6323000000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2016Q4</FONT></TD><TD><FONT color="#ff0000">2.1814444418781900</FONT></TD><TD><FONT color="#ff0000">137.5530985000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2017Q1</FONT></TD><TD><FONT color="#ff0000">2.2305773056005900</FONT></TD><TD><FONT color="#ff0000">138.7841262000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2017Q2</FONT></TD><TD><FONT color="#ff0000">1.0829475601426700</FONT></TD><TD><FONT color="#ff0000">140.2329980000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2017Q3</FONT></TD><TD><FONT color="#ff0000">2.4291482568206800</FONT></TD><TD><FONT color="#ff0000">141.7630128000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2017Q4</FONT></TD><TD><FONT color="#ff0000">2.3145689002407200</FONT></TD><TD><FONT color="#ff0000">142.2002388000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2018Q1</FONT></TD><TD><FONT color="#ff0000">3.2065052354548800</FONT></TD><TD><FONT color="#ff0000">146.0547948000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2018Q2</FONT></TD><TD><FONT color="#ff0000">4.0342500206461100</FONT></TD><TD><FONT color="#ff0000">144.6496579000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2018Q3</FONT></TD><TD><FONT color="#ff0000">2.6762028608582600</FONT></TD><TD><FONT color="#ff0000">145.2911509000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2018Q4</FONT></TD><TD><FONT color="#ff0000">0.9543692215926040</FONT></TD><TD><FONT color="#ff0000">143.1153248000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2019Q1</FONT></TD><TD><FONT color="#ff0000">-1.8238815512256100</FONT></TD><TD><FONT color="#ff0000">146.1963144000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2019Q2</FONT></TD><TD><FONT color="#ff0000">-4.6979696255696600</FONT></TD><TD><FONT color="#ff0000">139.5495951000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2019Q3</FONT></TD><TD><FONT color="#ff0000">-4.7265634894500900</FONT></TD><TD><FONT color="#ff0000">139.9400998000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2019Q4</FONT></TD><TD><FONT color="#ff0000">-5.1490781771431700</FONT></TD><TD><FONT color="#ff0000">138.4258302000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2020Q1</FONT></TD><TD><FONT color="#ff0000">-3.2981710949380400</FONT></TD><TD><FONT color="#ff0000">138.7433644000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2020Q2</FONT></TD><TD><FONT color="#ff0000">-0.6637109506627640</FONT></TD><TD><FONT color="#ff0000">138.5053422000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2020Q3</FONT></TD><TD><FONT color="#ff0000">-1.0106688037190800</FONT></TD><TD><FONT color="#ff0000">136.1648689000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2020Q4</FONT></TD><TD><FONT color="#ff0000">1.9894873244202500</FONT></TD><TD><FONT color="#ff0000">136.0056812000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2021Q1</FONT></TD><TD><FONT color="#ff0000">1.3946441074851600</FONT></TD><TD><FONT color="#ff0000">136.5675436000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2021Q2</FONT></TD><TD><FONT color="#ff0000">0.2637516770337850</FONT></TD><TD><FONT color="#ff0000">135.7307409000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2021Q3</FONT></TD><TD><FONT color="#ff0000">0.6349998081571580</FONT></TD><TD><FONT color="#ff0000">135.0126337000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2021Q4</FONT></TD><TD><FONT color="#ff0000">-1.8718825520941300</FONT></TD><TD><FONT color="#ff0000">135.5315841000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2022Q1</FONT></TD><TD><FONT color="#ff0000">-1.5735730296375100</FONT></TD><TD><FONT color="#ff0000">133.7159334000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2022Q2</FONT></TD><TD><FONT color="#ff0000">0.0737474340454649</FONT></TD><TD><FONT color="#ff0000">131.0825881000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2022Q3</FONT></TD><TD><FONT color="#ff0000">0.8757649122138130</FONT></TD><TD><FONT color="#ff0000">131.3026443000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2022Q4</FONT></TD><TD><FONT color="#ff0000">2.1949776391215500</FONT></TD><TD><FONT color="#ff0000">131.2321800000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2023Q1</FONT></TD><TD><FONT color="#ff0000">2.2888295914611700</FONT></TD><TD><FONT color="#ff0000">133.3959875000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2023Q2</FONT></TD><TD><FONT color="#ff0000">2.2423211043327000</FONT></TD><TD><FONT color="#ff0000">130.0202857000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2023Q3</FONT></TD><TD><FONT color="#ff0000">1.6493941386791200</FONT></TD><TD><FONT color="#ff0000">128.8410652000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2023Q4</FONT></TD><TD><FONT color="#ff0000">1.3714852869855500</FONT></TD><TD><FONT color="#ff0000">129.9515952000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2024Q1</FONT></TD><TD><FONT color="#ff0000">1.8515603331309400</FONT></TD><TD><FONT color="#ff0000">131.1145455000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2024Q2</FONT></TD><TD><FONT color="#ff0000">1.6826610491274600</FONT></TD><TD><FONT color="#ff0000">128.6410867000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2024Q3</FONT></TD><TD><FONT color="#ff0000">1.9375636744922800</FONT></TD><TD><FONT color="#ff0000">129.2113542000000000</FONT></TD></TR><TR><TD><FONT color="#ff0000">2024Q4</FONT></TD><TD><FONT color="#ff0000">2.0727867466260200</FONT></TD><TD><FONT color="#ff0000">127.6074090000000000</FONT></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P><P>any help will be appreciated</P> Thu, 19 Dec 2019 08:56:24 GMT https://communities.sas.com/t5/New-SAS-User/data-manipulation-in-SAS/m-p/612952#M18334 npr 2019-12-19T08:56:24Z Re: data manipulation in SAS https://communities.sas.com/t5/New-SAS-User/data-manipulation-in-SAS/m-p/612959#M18335 <P>Hi&nbsp;<a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/302099">@npr</a>&nbsp;</P> <P>You can try this, assuming you have 80 rows and you want to update the second half with the first one.</P> <P><CODE class=" language-sas"></CODE></P> <PRE><CODE class=" language-sas">data want; set have (rename=(X = X_old Y=Y_old)); if _n_&lt;= 40 then do; set have (obs=40 keep=X Y); end; if _n_&gt; 40 then do; set have (obs=40 keep=X Y); end; drop X_old Y_old; run;</CODE></PRE> <P><CODE class=" language-sas"></CODE>&nbsp;</P> Thu, 19 Dec 2019 09:23:04 GMT https://communities.sas.com/t5/New-SAS-User/data-manipulation-in-SAS/m-p/612959#M18335 ed_sas_member 2019-12-19T09:23:04Z Re: data manipulation in SAS https://communities.sas.com/t5/New-SAS-User/data-manipulation-in-SAS/m-p/612968#M18336 <P>Hi Ed</P><P>&nbsp;</P><P>If I have more than 80 rows then what do I have to do ? Basically I want the values from 2005 q1 to 2014 q4 to repeat from 2015 q1.</P> Thu, 19 Dec 2019 10:02:25 GMT https://communities.sas.com/t5/New-SAS-User/data-manipulation-in-SAS/m-p/612968#M18336 npr 2019-12-19T10:02:25Z Re: data manipulation in SAS https://communities.sas.com/t5/New-SAS-User/data-manipulation-in-SAS/m-p/612969#M18337 <P>for eg 2025 q1 values of X and Y should be similar to that of 2015 q1 and so on ………….</P> Thu, 19 Dec 2019 10:03:41 GMT https://communities.sas.com/t5/New-SAS-User/data-manipulation-in-SAS/m-p/612969#M18337 npr 2019-12-19T10:03:41Z Re: data manipulation in SAS https://communities.sas.com/t5/New-SAS-User/data-manipulation-in-SAS/m-p/613044#M18345 <P>One approach:</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">data want; set have; if Q = '2005Q1' then firstrow = _n_; else if Q = '2014Q4' then lastrow = _n_; else if Q &gt; '2014Q4' then do; pointer = firstrow + mod(_n_, lastrow - firstrow + 1); set have (keep=x y) point = pointer; end; run;</CODE></PRE> <P>This definitely assumes you have no gaps in your time sequence ... every row within the range is present.</P> <P>&nbsp;</P> <P>It's untested code, since you have the data.&nbsp; But see if it works for what you need.</P> Thu, 19 Dec 2019 14:15:55 GMT https://communities.sas.com/t5/New-SAS-User/data-manipulation-in-SAS/m-p/613044#M18345 Astounding 2019-12-19T14:15:55Z