topic Re: Renaming the group of variables in New SAS User

Renaming the group of variables

Pooja98 — Thu, 28 Oct 2021 06:25:12 GMT

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

Re: Renaming the group of variables

PeterClemmensen — Thu, 28 Oct 2021 06:30:26 GMT

Should it always be the friday of the week?

Re: Renaming the group of variables

Pooja98 — Thu, 28 Oct 2021 06:38:08 GMT

Yes

Re: Renaming the group of variables

PeterClemmensen — Thu, 28 Oct 2021 06:44:53 GMT

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;

Re: Renaming the group of variables

Pooja98 — Thu, 28 Oct 2021 07:06:29 GMT

Not working

the values below the week column got changed