Quarters- months grouping in SasJobExecution

[gopalxor]

Hi Team,

I am trying to export the report from Proc report , with the attached input from dataset and optput mentioned in the dataset.

I tried , but for me all the months are coming in each quarter

proc report data= xxxx;
column 'Dept'n 'loc'n 'QUARTER'n,('MonthYear'n,('count'n 'Amount'n));
define 'Dept'n / group;
define 'loc'n / group;
define 'QUARTER'n / across;
define 'MonthYear'n / across;

run;

[BrunoMueller]

Add the NOCOMPLETECOLS to the Proc REPORT statement