topic Re: how can I create an extra variable? in SAS Procedures

how can I create an extra variable?

thdang — Wed, 10 Apr 2013 20:32:26 GMT

Hi,

Can someone tell me if there is a quick way to add an variable that take the value of the last month of each year and apply it for the next year, and the first year would have empty value. Thanks in advance!

Date ID Value WANT

Re: how can I create an extra variable?

Linlin — Wed, 10 Apr 2013 20:51:32 GMT

example:

data have;

input date mmddyy10. v;

format date mmddyy10.;

cards;

10/31/2010 8

12/31/2010 9

10/31/2011 9

12/31/2011 10

01/31/2012 15

;

data want;

retain nv .;

set have;

if month(date)=12 then nv=v;

new=lag(nv);

proc print;run;

Re: how can I create an extra variable?

thdang — Thu, 11 Apr 2013 18:35:38 GMT

Thank you!