Compare this quarter vs previous quarter

[harshpatel]

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

[yabwon]

What did you try up to now?

[harshpatel]

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

[yabwon]

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

[harshpatel]

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;

[andreas_lds]

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

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

[harshpatel]

Hi, i want sas dataset only

[harshpatel]

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;

[Kurt_Bremser · Accepted solution]

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

[harshpatel]

Thanks, it works