https://communities.sas.com/t5/SAS-Enterprise-Guide/Finding-Previous-Year-Values/m-p/706459#M37887 <P>Did&nbsp; prevyear_value = Lag12 (year_value) ; not work? If not show the code you used from the log and describe what is incorrect.</P> <P>&nbsp;</P> <P>If you are hiding some sort of "group", such as company, that needs to reset then you need to include that information in your description and better instead of picture, that we can't code with, provide some example data in the form of a data step. You only need to provide the relevant variables and dummy data is fine as long as it behaves like your actual data.</P> <P>&nbsp;</P> <P>Instructions here: <A href="https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712" target="_blank">https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712</A> will show how to turn an existing SAS data set into data step code that can be pasted into a forum code box using the &lt;/&gt; icon or attached as text to show exactly what you have and that we can test code against.</P> <P>&nbsp;</P> <P>&nbsp;</P> Wed, 16 Dec 2020 21:30:07 GMT ballardw 2020-12-16T21:30:07Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Finding-Previous-Year-Values/m-p/706446#M37885 <P>Hi all,</P><P>Below is a screenshot of my data. I am having trouble on how to create a column with Previous Year values. As you can see I need the 2016 year value to be in 2017's previous year column. I have tried multiple versions of retain and lag, but I'm not getting what I need still. Any help would be great!</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="kathleen_07_1-1608151885553.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/52706iC9D751DE07B538B0/image-size/medium?v=v2&amp;px=400" role="button" title="kathleen_07_1-1608151885553.png" alt="kathleen_07_1-1608151885553.png" /></span></P><P>&nbsp;</P> Wed, 16 Dec 2020 20:53:24 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Finding-Previous-Year-Values/m-p/706446#M37885 kathleen_07 2020-12-16T20:53:24Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Finding-Previous-Year-Values/m-p/706459#M37887 <P>Did&nbsp; prevyear_value = Lag12 (year_value) ; not work? If not show the code you used from the log and describe what is incorrect.</P> <P>&nbsp;</P> <P>If you are hiding some sort of "group", such as company, that needs to reset then you need to include that information in your description and better instead of picture, that we can't code with, provide some example data in the form of a data step. You only need to provide the relevant variables and dummy data is fine as long as it behaves like your actual data.</P> <P>&nbsp;</P> <P>Instructions here: <A href="https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712" target="_blank">https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712</A> will show how to turn an existing SAS data set into data step code that can be pasted into a forum code box using the &lt;/&gt; icon or attached as text to show exactly what you have and that we can test code against.</P> <P>&nbsp;</P> <P>&nbsp;</P> Wed, 16 Dec 2020 21:30:07 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Finding-Previous-Year-Values/m-p/706459#M37887 ballardw 2020-12-16T21:30:07Z