https://communities.sas.com/t5/SAS-Programming/How-to-aggregate-on-SAS-STUDIO/m-p/982004#M379225 <P>It would be helpful to have a sample for me and other users</P> <P>I am on the LTS09. Before, It was very easy for me but now.....</P> <P>&nbsp;</P> Thu, 15 Jan 2026 11:49:31 GMT YannRC 2026-01-15T11:49:31Z https://communities.sas.com/t5/SAS-Programming/How-to-aggregate-on-SAS-STUDIO/m-p/982003#M379224 <P>I have a lot of questions on flow.</P> <P>I want to aggregate data at week level. My first DATA are on a day level.</P> <P>I Change it in YYWEEKV5 and WEEKV5 in informat (I have not an other choice).</P> <P>I put a SUM on the variables.</P> <P>But the result is not good. It continue to aggregate at a day level&nbsp;</P> <P>If you can help me</P> <P>&nbsp;</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="YannRC_0-1768476581992.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/112636i7A58B2E51E7566AA/image-size/medium?v=v2&amp;px=400" role="button" title="YannRC_0-1768476581992.png" alt="YannRC_0-1768476581992.png" /></span></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="YannRC_0-1768477025221.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/112637i3F7F61C9F8FFDA9D/image-size/medium?v=v2&amp;px=400" role="button" title="YannRC_0-1768477025221.png" alt="YannRC_0-1768477025221.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> Thu, 15 Jan 2026 11:37:33 GMT https://communities.sas.com/t5/SAS-Programming/How-to-aggregate-on-SAS-STUDIO/m-p/982003#M379224 YannRC 2026-01-15T11:37:33Z https://communities.sas.com/t5/SAS-Programming/How-to-aggregate-on-SAS-STUDIO/m-p/982004#M379225 <P>It would be helpful to have a sample for me and other users</P> <P>I am on the LTS09. Before, It was very easy for me but now.....</P> <P>&nbsp;</P> Thu, 15 Jan 2026 11:49:31 GMT https://communities.sas.com/t5/SAS-Programming/How-to-aggregate-on-SAS-STUDIO/m-p/982004#M379225 YannRC 2026-01-15T11:49:31Z https://communities.sas.com/t5/SAS-Programming/How-to-aggregate-on-SAS-STUDIO/m-p/982055#M379230 <P>This step uses SQL, and SQL does not aggregate based on formats.</P> <P>So what you need to do is transform this column, by using put(LaDate,YYWEEKV5 .).</P> Fri, 16 Jan 2026 07:16:02 GMT https://communities.sas.com/t5/SAS-Programming/How-to-aggregate-on-SAS-STUDIO/m-p/982055#M379230 LinusH 2026-01-16T07:16:02Z https://communities.sas.com/t5/SAS-Programming/How-to-aggregate-on-SAS-STUDIO/m-p/982057#M379232 Thanks a lot Fri, 16 Jan 2026 07:44:06 GMT https://communities.sas.com/t5/SAS-Programming/How-to-aggregate-on-SAS-STUDIO/m-p/982057#M379232 YannRC 2026-01-16T07:44:06Z