topic Re: Last 13 week's data in SAS Enterprise Guide

Last 13 week's data

BURHAN_CIGDEM — Thu, 10 May 2018 13:52:47 GMT

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.

Re: Last 13 week's data

PaigeMiller — Thu, 10 May 2018 14:31:33 GMT

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

Re: Last 13 week's data

BURHAN_CIGDEM — Fri, 18 May 2018 12:02:35 GMT

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?

Re: Last 13 week's data

PaigeMiller — Fri, 18 May 2018 12:15:14 GMT

@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.

Re: Last 13 week's data

BURHAN_CIGDEM — Fri, 18 May 2018 12:32:30 GMT

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

Re: Last 13 week's data

PaigeMiller — Fri, 18 May 2018 14:16:37 GMT

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