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
Should it always be the friday of the week?
Yes
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;
Not working
the values below the week column got changed
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
Register now!
SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.
Find more tutorials on the SAS Users YouTube channel.