topic Re: Compare this quarter vs previous quarter in SAS Programming

Compare this quarter vs previous quarter

harshpatel — Fri, 08 Sep 2023 11:33:08 GMT

Hi,

I need to compare this quarter vs previous quarter with the following output

From input table, i need to compare 2 quarters current and previous

Input table:

ID Repdate Amount

1 31DEC2020 2000

1 31DEC2021 3000

1 30SEP2020 1500

1 30SEP2021 3000

Output table:

ID Repdate Amount Previousqtr Amount

1 31DEC2020 2000 30SEP2020 1500

1 31DEC2021 3000 30SEP2021 3000

Thanks in advance

Re: Compare this quarter vs previous quarter

yabwon — Fri, 08 Sep 2023 11:39:18 GMT

What did you try up to now?

Re: Compare this quarter vs previous quarter

andreas_lds — Fri, 08 Sep 2023 12:06:56 GMT

Can you post the input table as working data step code?

You want the output as html/pdf/excel, not as dataset, right?

Re: Compare this quarter vs previous quarter

harshpatel — Fri, 08 Sep 2023 12:08:59 GMT

Hi, i want to compare current quarter vs previous quarter in the sas dataset itself as i have mentioned the output table

Re: Compare this quarter vs previous quarter

harshpatel — Fri, 08 Sep 2023 12:09:45 GMT

Hi, i want sas dataset only

Re: Compare this quarter vs previous quarter

yabwon — Fri, 08 Sep 2023 12:15:27 GMT

I didn't asked what do you want (I can tell that from the first post). I asked what did you try so far? What code have you wrote?

Bart

Re: Compare this quarter vs previous quarter

harshpatel — Fri, 08 Sep 2023 12:27:00 GMT

Hi, below is my code, but i want amount column as well which is previous quarter amount
data y ;
set test;
format end_last_q date9.;
end_last_q = intnx('qtr', repdate, -1, 'end');
put end_last_q;
run;

Re: Compare this quarter vs previous quarter

harshpatel — Fri, 08 Sep 2023 12:27:48 GMT

Hi, i tried below code but i am not getting another amount column which is previous quarter amount
data y ;
set test;
format end_last_q date9.;
end_last_q = intnx('qtr', repdate, -1, 'end');
put end_last_q;
run;

Re: Compare this quarter vs previous quarter

Kurt_Bremser — Fri, 08 Sep 2023 13:01:27 GMT

Join the dataset with itself and use this condition:
on t1.id = t2.id and intnx("qtr“,t1.repdate,-1,“e“) = t2.repdate

Re: Compare this quarter vs previous quarter

harshpatel — Fri, 08 Sep 2023 13:21:44 GMT

Thanks, it works