https://communities.sas.com/t5/SAS-Programming/How-to-retain-new-variables-based-on-old-ones/m-p/337815#M76782 <P>Thank you. I have a solution.</P> Fri, 03 Mar 2017 13:25:59 GMT MCB 2017-03-03T13:25:59Z https://communities.sas.com/t5/SAS-Programming/How-to-retain-new-variables-based-on-old-ones/m-p/337806#M76780 <P>I have a dataset with dates and prices which I need to complete with lagded variables.</P> <P>&nbsp;</P> <P>The&nbsp;attached file "have" shows how some observations in my data look like. Then Attached file "want" shows what I would like to do with the variables EDT and Price.</P> <P>&nbsp;</P> <P>Thanks!</P> <P>&nbsp;</P> Fri, 03 Mar 2017 13:02:44 GMT https://communities.sas.com/t5/SAS-Programming/How-to-retain-new-variables-based-on-old-ones/m-p/337806#M76780 MCB 2017-03-03T13:02:44Z https://communities.sas.com/t5/SAS-Programming/How-to-retain-new-variables-based-on-old-ones/m-p/337809#M76781 <P>Post example data <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">in a data step</A>.</P> <P>I won't touch Excel files from the internet (even if the firewall let them through).</P> <P>This is a SAS community, not a MS Office forum.</P> Fri, 03 Mar 2017 13:09:29 GMT https://communities.sas.com/t5/SAS-Programming/How-to-retain-new-variables-based-on-old-ones/m-p/337809#M76781 Kurt_Bremser 2017-03-03T13:09:29Z https://communities.sas.com/t5/SAS-Programming/How-to-retain-new-variables-based-on-old-ones/m-p/337815#M76782 <P>Thank you. I have a solution.</P> Fri, 03 Mar 2017 13:25:59 GMT https://communities.sas.com/t5/SAS-Programming/How-to-retain-new-variables-based-on-old-ones/m-p/337815#M76782 MCB 2017-03-03T13:25:59Z