topic Datagrid output column names are always uppercase in Decisioning https://communities.sas.com/t5/Decisioning/Datagrid-output-column-names-are-always-uppercase/m-p/959569#M139 <P>Dear experts,</P><P>&nbsp;</P><P>&nbsp;We are implementing a large decision in Viya4 2024.03 and we noticed a strange behaviour. We have defined various input/output datagrids that contain columns names that are case sensitive. See the example below</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Sebastianc1_0-1739953659115.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/104739iCB245F2D42C7E295/image-size/medium?v=v2&amp;px=400" role="button" title="Sebastianc1_0-1739953659115.png" alt="Sebastianc1_0-1739953659115.png" /></span></P><P>&nbsp;</P><P>However, in the response json that the third-party system receives, we get only upcased column names</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Sebastianc1_2-1739953783227.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/104741i85B4FACD8DD4AD3A/image-size/medium?v=v2&amp;px=400" role="button" title="Sebastianc1_2-1739953783227.png" alt="Sebastianc1_2-1739953783227.png" /></span></P><P>The client requires that we match the exact case of the input columns. Is there any way to do this?&nbsp;</P><P>&nbsp;</P><P>Thanks,</P><P>Sebastian</P> Wed, 19 Feb 2025 08:35:08 GMT Sebastianc1 2025-02-19T08:35:08Z Datagrid output column names are always uppercase https://communities.sas.com/t5/Decisioning/Datagrid-output-column-names-are-always-uppercase/m-p/959569#M139 <P>Dear experts,</P><P>&nbsp;</P><P>&nbsp;We are implementing a large decision in Viya4 2024.03 and we noticed a strange behaviour. We have defined various input/output datagrids that contain columns names that are case sensitive. See the example below</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Sebastianc1_0-1739953659115.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/104739iCB245F2D42C7E295/image-size/medium?v=v2&amp;px=400" role="button" title="Sebastianc1_0-1739953659115.png" alt="Sebastianc1_0-1739953659115.png" /></span></P><P>&nbsp;</P><P>However, in the response json that the third-party system receives, we get only upcased column names</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Sebastianc1_2-1739953783227.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/104741i85B4FACD8DD4AD3A/image-size/medium?v=v2&amp;px=400" role="button" title="Sebastianc1_2-1739953783227.png" alt="Sebastianc1_2-1739953783227.png" /></span></P><P>The client requires that we match the exact case of the input columns. Is there any way to do this?&nbsp;</P><P>&nbsp;</P><P>Thanks,</P><P>Sebastian</P> Wed, 19 Feb 2025 08:35:08 GMT https://communities.sas.com/t5/Decisioning/Datagrid-output-column-names-are-always-uppercase/m-p/959569#M139 Sebastianc1 2025-02-19T08:35:08Z Re: Datagrid output column names are always uppercase https://communities.sas.com/t5/Decisioning/Datagrid-output-column-names-are-always-uppercase/m-p/959841#M140 <P><SPAN>SAS Intelligent Decisioning uses dataGrid methods in our generated code.&nbsp; The ds2 package implementation of these methods includes logic that upcases dataGrid column variable names.&nbsp; The upcasing of dataGrid column names simplifies the processing of dataGrids by other dataGrid methods in our generated code.&nbsp;&nbsp;</SPAN></P> Thu, 20 Feb 2025 21:31:09 GMT https://communities.sas.com/t5/Decisioning/Datagrid-output-column-names-are-always-uppercase/m-p/959841#M140 dawieh 2025-02-20T21:31:09Z