topic how to create lag values? in SAS Programming https://communities.sas.com/t5/SAS-Programming/how-to-create-lag-values/m-p/826553#M326479 <P>dear all</P><P>my data is in the following format&nbsp;</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>company_name</TD><TD>year</TD><TD>CA</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2011</TD><TD>958.9</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2012</TD><TD>1185.3</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2013</TD><TD>1097.5</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2014</TD><TD>1341.1</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2015</TD><TD>1505.3</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2016</TD><TD>1631.1</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2017</TD><TD>1557.9</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2018</TD><TD>1679.5</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2019</TD><TD>1893.7</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2020</TD><TD>1957.2</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2021</TD><TD>2040.1</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2011</TD><TD>9043.3</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2012</TD><TD>6329.7</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2013</TD><TD>6221.6</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2014</TD><TD>6976.8</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2015</TD><TD>6608.5</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2016</TD><TD>7162.7</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2017</TD><TD>7443.1</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2018</TD><TD>7101.5</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2019</TD><TD>7944.2</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2020</TD><TD>8165.2</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2021</TD><TD>11286.2</TD></TR><TR><TD>3M India Ltd.</TD><TD>2011</TD><TD>4652.1</TD></TR><TR><TD>3M India Ltd.</TD><TD>2012</TD><TD>5684.4</TD></TR><TR><TD>3M India Ltd.</TD><TD>2013</TD><TD>8996.1</TD></TR><TR><TD>3M India Ltd.</TD><TD>2014</TD><TD>9574.9</TD></TR><TR><TD>3M India Ltd.</TD><TD>2015</TD><TD>7634.6</TD></TR><TR><TD>3M India Ltd.</TD><TD>2016</TD><TD>10677.2</TD></TR><TR><TD>3M India Ltd.</TD><TD>2017</TD><TD>15550.9</TD></TR><TR><TD>3M India Ltd.</TD><TD>2018</TD><TD>17775.3</TD></TR><TR><TD>3M India Ltd.</TD><TD>2019</TD><TD>15342.9</TD></TR><TR><TD>3M India Ltd.</TD><TD>2020</TD><TD>17414.6</TD></TR><TR><TD>3M India Ltd.</TD><TD>2021</TD><TD>19899.4</TD></TR><TR><TD>3P Land Holdings Ltd.</TD><TD>2011</TD><TD>465.9</TD></TR><TR><TD>3P Land Holdings Ltd.</TD><TD>2012</TD><TD>518</TD></TR><TR><TD>3P Land Holdings Ltd.</TD><TD>2013</TD><TD>502.6</TD></TR><TR><TD>3P Land Holdings Ltd.</TD><TD>2014</TD><TD>483.2</TD></TR><TR><TD>3P Land Holdings Ltd.</TD><TD>2016</TD><TD>9.1</TD></TR><TR><TD>3P Land Holdings Ltd.</TD><TD>2017</TD><TD>3.1</TD></TR><TR><TD>3P Land Holdings Ltd.</TD><TD>2018</TD><TD>2.7</TD></TR><TR><TD>3Rd Rock Multimedia Ltd.</TD><TD>2014</TD><TD>110.7</TD></TR><TR><TD>3Rd Rock Multimedia Ltd.</TD><TD>2019</TD><TD>96.2</TD></TR><TR><TD>52 Weeks Entertainment Ltd.</TD><TD>2018</TD><TD>388.4</TD></TR><TR><TD>52 Weeks Entertainment Ltd.</TD><TD>2019</TD><TD>295.9</TD></TR><TR><TD>63 Moons Technologies Ltd.</TD><TD>2011</TD><TD>10732.7</TD></TR><TR><TD>63 Moons Technologies Ltd.</TD><TD>2012</TD><TD>14470.4</TD></TR><TR><TD>63 Moons Technologies Ltd.</TD><TD>2013</TD><TD>16083.7</TD></TR><TR><TD>63 Moons Technologies Ltd.</TD><TD>2014</TD><TD>13040.1</TD></TR><TR><TD>63 Moons Technologies Ltd.</TD><TD>2015</TD><TD>17269</TD></TR><TR><TD>63 Moons Technologies Ltd.</TD><TD>2016</TD><TD>7948.6</TD></TR><TR><TD>63 Moons Technologies Ltd.</TD><TD>2017</TD><TD>7197.1</TD></TR><TR><TD>63 Moons Technologies Ltd.</TD><TD>2018</TD><TD>13677.4</TD></TR><TR><TD>63 Moons Technologies Ltd.</TD><TD>2019</TD><TD>13101.7</TD></TR><TR><TD>63 Moons Technologies Ltd.</TD><TD>2020</TD><TD>13394.7</TD></TR><TR><TD>63 Moons Technologies Ltd.</TD><TD>2021</TD><TD>13280.4</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>it is a unbalanced panel data of nearly 3,000 companies, from 2011 to 2021.</P><P>&nbsp;i have to create one year lag value of the variable&nbsp; "CA".</P><P>my output should be in the following format</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>company_name</TD><TD>year</TD><TD>CA</TD><TD>CA Lag</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2011</TD><TD>958.9</TD><TD>&nbsp;</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2012</TD><TD>1185.3</TD><TD>958.9</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2013</TD><TD>1097.5</TD><TD>1185.3</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2014</TD><TD>1341.1</TD><TD>1097.5</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2015</TD><TD>1505.3</TD><TD>1341.1</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2016</TD><TD>1631.1</TD><TD>1505.3</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2017</TD><TD>1557.9</TD><TD>1631.1</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2018</TD><TD>1679.5</TD><TD>1557.9</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2019</TD><TD>1893.7</TD><TD>1679.5</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2020</TD><TD>1957.2</TD><TD>1893.7</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2021</TD><TD>2040.1</TD><TD>1957.2</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2011</TD><TD>9043.3</TD><TD>&nbsp;</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2012</TD><TD>6329.7</TD><TD>9043.3</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2013</TD><TD>6221.6</TD><TD>6329.7</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2014</TD><TD>6976.8</TD><TD>6221.6</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2015</TD><TD>6608.5</TD><TD>6976.8</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2016</TD><TD>7162.7</TD><TD>6608.5</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2017</TD><TD>7443.1</TD><TD>7162.7</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2018</TD><TD>7101.5</TD><TD>7443.1</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2019</TD><TD>7944.2</TD><TD>7101.5</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2020</TD><TD>8165.2</TD><TD>7944.2</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2021</TD><TD>11286.2</TD><TD>8165.2</TD></TR><TR><TD>3M India Ltd.</TD><TD>2011</TD><TD>4652.1</TD><TD>&nbsp;</TD></TR><TR><TD>3M India Ltd.</TD><TD>2012</TD><TD>5684.4</TD><TD>4652.1</TD></TR><TR><TD>3M India Ltd.</TD><TD>2013</TD><TD>8996.1</TD><TD>5684.4</TD></TR><TR><TD>3M India Ltd.</TD><TD>2014</TD><TD>9574.9</TD><TD>8996.1</TD></TR><TR><TD>3M India Ltd.</TD><TD>2015</TD><TD>7634.6</TD><TD>9574.9</TD></TR><TR><TD>3M India Ltd.</TD><TD>2016</TD><TD>10677.2</TD><TD>7634.6</TD></TR><TR><TD>3M India Ltd.</TD><TD>2017</TD><TD>15550.9</TD><TD>10677.2</TD></TR><TR><TD>3M India Ltd.</TD><TD>2018</TD><TD>17775.3</TD><TD>15550.9</TD></TR><TR><TD>3M India Ltd.</TD><TD>2019</TD><TD>15342.9</TD><TD>17775.3</TD></TR><TR><TD>3M India Ltd.</TD><TD>2020</TD><TD>17414.6</TD><TD>15342.9</TD></TR><TR><TD>3M India Ltd.</TD><TD>2021</TD><TD>19899.4</TD><TD><P>17414.6</P><P>&nbsp;</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>please suggest me a SAS code&nbsp; to get the output in the above mentioned format</P><P>&nbsp;</P><P>thanking you in advance&nbsp;</P> Tue, 02 Aug 2022 06:12:39 GMT srikanthyadav44 2022-08-02T06:12:39Z how to create lag values? https://communities.sas.com/t5/SAS-Programming/how-to-create-lag-values/m-p/826553#M326479 <P>dear all</P><P>my data is in the following format&nbsp;</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>company_name</TD><TD>year</TD><TD>CA</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2011</TD><TD>958.9</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2012</TD><TD>1185.3</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2013</TD><TD>1097.5</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2014</TD><TD>1341.1</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2015</TD><TD>1505.3</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2016</TD><TD>1631.1</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2017</TD><TD>1557.9</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2018</TD><TD>1679.5</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2019</TD><TD>1893.7</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2020</TD><TD>1957.2</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2021</TD><TD>2040.1</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2011</TD><TD>9043.3</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2012</TD><TD>6329.7</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2013</TD><TD>6221.6</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2014</TD><TD>6976.8</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2015</TD><TD>6608.5</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2016</TD><TD>7162.7</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2017</TD><TD>7443.1</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2018</TD><TD>7101.5</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2019</TD><TD>7944.2</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2020</TD><TD>8165.2</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2021</TD><TD>11286.2</TD></TR><TR><TD>3M India Ltd.</TD><TD>2011</TD><TD>4652.1</TD></TR><TR><TD>3M India Ltd.</TD><TD>2012</TD><TD>5684.4</TD></TR><TR><TD>3M India Ltd.</TD><TD>2013</TD><TD>8996.1</TD></TR><TR><TD>3M India Ltd.</TD><TD>2014</TD><TD>9574.9</TD></TR><TR><TD>3M India Ltd.</TD><TD>2015</TD><TD>7634.6</TD></TR><TR><TD>3M India Ltd.</TD><TD>2016</TD><TD>10677.2</TD></TR><TR><TD>3M India Ltd.</TD><TD>2017</TD><TD>15550.9</TD></TR><TR><TD>3M India Ltd.</TD><TD>2018</TD><TD>17775.3</TD></TR><TR><TD>3M India Ltd.</TD><TD>2019</TD><TD>15342.9</TD></TR><TR><TD>3M India Ltd.</TD><TD>2020</TD><TD>17414.6</TD></TR><TR><TD>3M India Ltd.</TD><TD>2021</TD><TD>19899.4</TD></TR><TR><TD>3P Land Holdings Ltd.</TD><TD>2011</TD><TD>465.9</TD></TR><TR><TD>3P Land Holdings Ltd.</TD><TD>2012</TD><TD>518</TD></TR><TR><TD>3P Land Holdings Ltd.</TD><TD>2013</TD><TD>502.6</TD></TR><TR><TD>3P Land Holdings Ltd.</TD><TD>2014</TD><TD>483.2</TD></TR><TR><TD>3P Land Holdings Ltd.</TD><TD>2016</TD><TD>9.1</TD></TR><TR><TD>3P Land Holdings Ltd.</TD><TD>2017</TD><TD>3.1</TD></TR><TR><TD>3P Land Holdings Ltd.</TD><TD>2018</TD><TD>2.7</TD></TR><TR><TD>3Rd Rock Multimedia Ltd.</TD><TD>2014</TD><TD>110.7</TD></TR><TR><TD>3Rd Rock Multimedia Ltd.</TD><TD>2019</TD><TD>96.2</TD></TR><TR><TD>52 Weeks Entertainment Ltd.</TD><TD>2018</TD><TD>388.4</TD></TR><TR><TD>52 Weeks Entertainment Ltd.</TD><TD>2019</TD><TD>295.9</TD></TR><TR><TD>63 Moons Technologies Ltd.</TD><TD>2011</TD><TD>10732.7</TD></TR><TR><TD>63 Moons Technologies Ltd.</TD><TD>2012</TD><TD>14470.4</TD></TR><TR><TD>63 Moons Technologies Ltd.</TD><TD>2013</TD><TD>16083.7</TD></TR><TR><TD>63 Moons Technologies Ltd.</TD><TD>2014</TD><TD>13040.1</TD></TR><TR><TD>63 Moons Technologies Ltd.</TD><TD>2015</TD><TD>17269</TD></TR><TR><TD>63 Moons Technologies Ltd.</TD><TD>2016</TD><TD>7948.6</TD></TR><TR><TD>63 Moons Technologies Ltd.</TD><TD>2017</TD><TD>7197.1</TD></TR><TR><TD>63 Moons Technologies Ltd.</TD><TD>2018</TD><TD>13677.4</TD></TR><TR><TD>63 Moons Technologies Ltd.</TD><TD>2019</TD><TD>13101.7</TD></TR><TR><TD>63 Moons Technologies Ltd.</TD><TD>2020</TD><TD>13394.7</TD></TR><TR><TD>63 Moons Technologies Ltd.</TD><TD>2021</TD><TD>13280.4</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>it is a unbalanced panel data of nearly 3,000 companies, from 2011 to 2021.</P><P>&nbsp;i have to create one year lag value of the variable&nbsp; "CA".</P><P>my output should be in the following format</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>company_name</TD><TD>year</TD><TD>CA</TD><TD>CA Lag</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2011</TD><TD>958.9</TD><TD>&nbsp;</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2012</TD><TD>1185.3</TD><TD>958.9</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2013</TD><TD>1097.5</TD><TD>1185.3</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2014</TD><TD>1341.1</TD><TD>1097.5</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2015</TD><TD>1505.3</TD><TD>1341.1</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2016</TD><TD>1631.1</TD><TD>1505.3</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2017</TD><TD>1557.9</TD><TD>1631.1</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2018</TD><TD>1679.5</TD><TD>1557.9</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2019</TD><TD>1893.7</TD><TD>1679.5</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2020</TD><TD>1957.2</TD><TD>1893.7</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2021</TD><TD>2040.1</TD><TD>1957.2</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2011</TD><TD>9043.3</TD><TD>&nbsp;</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2012</TD><TD>6329.7</TD><TD>9043.3</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2013</TD><TD>6221.6</TD><TD>6329.7</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2014</TD><TD>6976.8</TD><TD>6221.6</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2015</TD><TD>6608.5</TD><TD>6976.8</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2016</TD><TD>7162.7</TD><TD>6608.5</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2017</TD><TD>7443.1</TD><TD>7162.7</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2018</TD><TD>7101.5</TD><TD>7443.1</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2019</TD><TD>7944.2</TD><TD>7101.5</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2020</TD><TD>8165.2</TD><TD>7944.2</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2021</TD><TD>11286.2</TD><TD>8165.2</TD></TR><TR><TD>3M India Ltd.</TD><TD>2011</TD><TD>4652.1</TD><TD>&nbsp;</TD></TR><TR><TD>3M India Ltd.</TD><TD>2012</TD><TD>5684.4</TD><TD>4652.1</TD></TR><TR><TD>3M India Ltd.</TD><TD>2013</TD><TD>8996.1</TD><TD>5684.4</TD></TR><TR><TD>3M India Ltd.</TD><TD>2014</TD><TD>9574.9</TD><TD>8996.1</TD></TR><TR><TD>3M India Ltd.</TD><TD>2015</TD><TD>7634.6</TD><TD>9574.9</TD></TR><TR><TD>3M India Ltd.</TD><TD>2016</TD><TD>10677.2</TD><TD>7634.6</TD></TR><TR><TD>3M India Ltd.</TD><TD>2017</TD><TD>15550.9</TD><TD>10677.2</TD></TR><TR><TD>3M India Ltd.</TD><TD>2018</TD><TD>17775.3</TD><TD>15550.9</TD></TR><TR><TD>3M India Ltd.</TD><TD>2019</TD><TD>15342.9</TD><TD>17775.3</TD></TR><TR><TD>3M India Ltd.</TD><TD>2020</TD><TD>17414.6</TD><TD>15342.9</TD></TR><TR><TD>3M India Ltd.</TD><TD>2021</TD><TD>19899.4</TD><TD><P>17414.6</P><P>&nbsp;</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>please suggest me a SAS code&nbsp; to get the output in the above mentioned format</P><P>&nbsp;</P><P>thanking you in advance&nbsp;</P> Tue, 02 Aug 2022 06:12:39 GMT https://communities.sas.com/t5/SAS-Programming/how-to-create-lag-values/m-p/826553#M326479 srikanthyadav44 2022-08-02T06:12:39Z Re: how to create lag values? https://communities.sas.com/t5/SAS-Programming/how-to-create-lag-values/m-p/826555#M326480 <P>Use the <A href="https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/lefunctionsref/n0l66p5oqex1f2n1quuopdvtcjqb.htm" target="_blank" rel="noopener">LAG Function</A>&nbsp;(unconditionally), and set the new variable to missing at first.company_name.</P> Tue, 02 Aug 2022 06:28:39 GMT https://communities.sas.com/t5/SAS-Programming/how-to-create-lag-values/m-p/826555#M326480 Kurt_Bremser 2022-08-02T06:28:39Z Re: how to create lag values? https://communities.sas.com/t5/SAS-Programming/how-to-create-lag-values/m-p/826557#M326482 <P>could you please provide one illustration of the SAS CODE for this purpose</P> Tue, 02 Aug 2022 06:35:41 GMT https://communities.sas.com/t5/SAS-Programming/how-to-create-lag-values/m-p/826557#M326482 srikanthyadav44 2022-08-02T06:35:41Z Re: how to create lag values? https://communities.sas.com/t5/SAS-Programming/how-to-create-lag-values/m-p/826559#M326483 <P>It's simple; try it on your own, and let's see what you come up with.</P> <P>&nbsp;</P> <P>The SAS communities are meant to&nbsp;<EM>assist</EM> people in their SAS life, not for doing other's work. If you want someone else to do <EM>your</EM> work for you, hire a consultant.</P> Tue, 02 Aug 2022 06:57:21 GMT https://communities.sas.com/t5/SAS-Programming/how-to-create-lag-values/m-p/826559#M326483 Kurt_Bremser 2022-08-02T06:57:21Z Re: how to create lag values? https://communities.sas.com/t5/SAS-Programming/how-to-create-lag-values/m-p/826562#M326484 <P>Good day</P><P>&nbsp;</P><P>Kindly give the below a try. I've created dummy data to get the point across. I've also done it in smaller steps, to show you how to get to the final result. Whenever you need to lag something by a group, that group needs to be sorted, that's why there's a sort step. This can also be done in PROC SQL if you are more familiar with SQL.&nbsp;</P><PRE><CODE class="">DATA HAVE; INPUT GROUP $ NUMBER; DATALINES; A 1 A 2 A 3 A 4 A 5 B 1 B 2 B 3 B 4 B 5 ; RUN; PROC SORT DATA=HAVE OUT=SORT; BY GROUP; RUN; DATA WANT; SET SORT; BY GROUP; LAG_NUMBER = LAG1(NUMBER); IF FIRST.GROUP THEN LAG_NUMBER_CLEAN = .; ELSE LAG_NUMBER_CLEAN = LAG_NUMBER; RUN;</CODE></PRE> Tue, 02 Aug 2022 07:31:04 GMT https://communities.sas.com/t5/SAS-Programming/how-to-create-lag-values/m-p/826562#M326484 Adriaan_Gouws 2022-08-02T07:31:04Z