Renaming the group of variables

[Pooja98]

Hi,

i have the column name as week1 week2, week3 and so on upto week100.

i need week1 as 29-Oct and week2 as 22-Oct and week3 as 15-Oct and so on.

Like, week 1 is current week, week2 is -7 of current week.

For example,

week1     week2      week3 

29-Oct      22-Oct      15-Oct

thanks

[PeterClemmensen]

Should it always be the friday of the week?

[Pooja98]

Yes

[PeterClemmensen]

Try this

data want;
   array w {*} week1 - week100;
   
   w[1] = intnx("week.6", date(), 1);
   
   do i = 2 to dim(w);
      w[i] = w[i - 1] - 7;
   end;
   
   format week: date9.;
run;

[Pooja98]

Not working

the values below the week column got changed