Help using Base SAS procedures

how can I create an extra variable?

Reply
Frequent Contributor
Posts: 75

how can I create an extra variable?

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

Super Contributor
Posts: 1,636

Re: how can I create an extra variable?

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;

Frequent Contributor
Posts: 75

Re: how can I create an extra variable?

Thank you!

Ask a Question
Discussion stats
  • 2 replies
  • 151 views
  • 1 like
  • 2 in conversation