DATA Step, Macro, Functions and more

how to take lag value

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 122
Accepted Solution

how to take lag value

I used following code and wanted to take lag return value for each id each date, but the result is not desirable. Please check and let me know what's wrong. thanks

data want;

  set have;

  by id date;

  if first.id then lagret = .; else lagret=lag(ret);

run;


Accepted Solutions
Solution
‎11-19-2013 05:23 AM
Respected Advisor
Posts: 3,896

Re: how to take lag value

The challenge you're facing is caused by using the lag() function conditionally.

http://support.sas.com/kb/24/665.html

http://support.sas.com/resources/papers/proceedings09/055-2009.pdf

Formulate your program as below and things will work as - I believe - you intended it to work.

data want;

  set have;

  by id date;

  lagret=lag(ret);

  if first.id then

    lagret = .;

run;

View solution in original post


All Replies
Solution
‎11-19-2013 05:23 AM
Respected Advisor
Posts: 3,896

Re: how to take lag value

The challenge you're facing is caused by using the lag() function conditionally.

http://support.sas.com/kb/24/665.html

http://support.sas.com/resources/papers/proceedings09/055-2009.pdf

Formulate your program as below and things will work as - I believe - you intended it to work.

data want;

  set have;

  by id date;

  lagret=lag(ret);

  if first.id then

    lagret = .;

run;

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 168 views
  • 1 like
  • 2 in conversation