Last 13 week's data

[BURHAN_CIGDEM]

Hi,

I have a SAS data set which contains 3 variables and 300 obs. Name of variables are Tarih, K1 and K2. Tarih variable is actually dates of data on weekly basis. Well, I wanna create a new SAS data set which includes last 13 weeks when I run the code every times.  How can I do that?

Thanks.

[PaigeMiller]

data want;
    set have;
    if tarih>=intnx('week',today(),-13,'s');
    /* ALTERNATIVE: if tarih >= today()-13*7; */
run;

[BURHAN_CIGDEM]

Thank you but it did not work. "Tarih" variable is stored as numeric variable. For example; 20180511(yyyymmdd). Should I convert it date format or something else?

[PaigeMiller]

---

@BURHAN_CIGDEM wrote:
Thank you but it did not work. "Tarih" variable is stored as numeric variable. For example; 20180511(yyyymmdd). Should I convert it date format or something else?

---

Show us the SASLOG. Show us other evidence that it did not work. 

The code I wrote expects TARIH to be numeric.

[BURHAN_CIGDEM]

There is no any problem on SASLog but I can see all obs in output data, not just last 13.

[PaigeMiller]

Burhan, show us the code then. Show us (some of) the data. Don't keep replying without showing us what is happening. Show us.