https://communities.sas.com/t5/ODS-and-Base-Reporting/Quarters-months-grouping-in-SasJobExecution/m-p/712150#M24801 <P>Add the&nbsp;<A href="https://go.documentation.sas.com/?cdcId=pgmsascdc&amp;cdcVersion=9.4_3.5&amp;docsetId=proc&amp;docsetTarget=n1dz7jdasx5t56n1rmlx346dyk6n.htm&amp;locale=en#n043oepofhgemxn1rl3a6if1vuco" target="_self">NOCOMPLETECOLS</A> to the Proc REPORT statement</P> Mon, 18 Jan 2021 16:34:24 GMT BrunoMueller 2021-01-18T16:34:24Z https://communities.sas.com/t5/ODS-and-Base-Reporting/Quarters-months-grouping-in-SasJobExecution/m-p/712129#M24800 <P>Hi Team,</P><P>I am trying to export the report from Proc report , with the attached input from dataset and optput mentioned in the dataset.</P><P>I tried , but for me all the months are coming in each quarter</P><P>proc report data= xxxx;<BR />column 'Dept'n 'loc'n 'QUARTER'n,('MonthYear'n,('count'n 'Amount'n));<BR />define 'Dept'n / group;<BR />define 'loc'n / group;<BR />define 'QUARTER'n / across;<BR />define 'MonthYear'n / across;<BR /><BR />run;</P> Mon, 18 Jan 2021 14:46:48 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Quarters-months-grouping-in-SasJobExecution/m-p/712129#M24800 gopalxor 2021-01-18T14:46:48Z https://communities.sas.com/t5/ODS-and-Base-Reporting/Quarters-months-grouping-in-SasJobExecution/m-p/712150#M24801 <P>Add the&nbsp;<A href="https://go.documentation.sas.com/?cdcId=pgmsascdc&amp;cdcVersion=9.4_3.5&amp;docsetId=proc&amp;docsetTarget=n1dz7jdasx5t56n1rmlx346dyk6n.htm&amp;locale=en#n043oepofhgemxn1rl3a6if1vuco" target="_self">NOCOMPLETECOLS</A> to the Proc REPORT statement</P> Mon, 18 Jan 2021 16:34:24 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Quarters-months-grouping-in-SasJobExecution/m-p/712150#M24801 BrunoMueller 2021-01-18T16:34:24Z