https://communities.sas.com/t5/SAS-Programming/Calculated-columns-in-SAS-Data-Studio/m-p/897874#M354879 <P>CASE as a statement pretty much only exists in Proc SQL and is <STRONG>not a function</STRONG>. So I am pretty confused as to what sort of code you even attempting.</P> <P>&nbsp;</P> Mon, 09 Oct 2023 20:43:57 GMT ballardw 2023-10-09T20:43:57Z https://communities.sas.com/t5/SAS-Programming/Calculated-columns-in-SAS-Data-Studio/m-p/897788#M354832 <P>Hi, i'm not sure to be in the good location. I prepare data with sas data studio. I want to sort my data with a date. I know that i can use a function in studio with case and INTCK but i would like to do this on SAS data studio by using a calculated collumns. But i dont' find the function case and if i use IF, i have an error. Can you help me?</P> Tue, 10 Oct 2023 12:09:20 GMT https://communities.sas.com/t5/SAS-Programming/Calculated-columns-in-SAS-Data-Studio/m-p/897788#M354832 YannRC 2023-10-10T12:09:20Z https://communities.sas.com/t5/SAS-Programming/Calculated-columns-in-SAS-Data-Studio/m-p/897789#M354833 <P>Show us the log for your code (all of it, not just the errors)</P> <P>&nbsp;</P> <P>Show us a portion of your data.</P> Mon, 09 Oct 2023 11:28:16 GMT https://communities.sas.com/t5/SAS-Programming/Calculated-columns-in-SAS-Data-Studio/m-p/897789#M354833 PaigeMiller 2023-10-09T11:28:16Z https://communities.sas.com/t5/SAS-Programming/Calculated-columns-in-SAS-Data-Studio/m-p/897874#M354879 <P>CASE as a statement pretty much only exists in Proc SQL and is <STRONG>not a function</STRONG>. So I am pretty confused as to what sort of code you even attempting.</P> <P>&nbsp;</P> Mon, 09 Oct 2023 20:43:57 GMT https://communities.sas.com/t5/SAS-Programming/Calculated-columns-in-SAS-Data-Studio/m-p/897874#M354879 ballardw 2023-10-09T20:43:57Z https://communities.sas.com/t5/SAS-Programming/Calculated-columns-in-SAS-Data-Studio/m-p/897942#M354911 <P>The calculated column transformation accept data step syntax, but does not allow conditional values. Help within the product:</P> <P>"Creating Calculated Columns</P> <DIV id="__popup54-popover-popover-cont" class="sapMPopoverCont" style="overflow: auto;"> <DIV id="__popup54-popover-popover-scroll" class="sapMPopoverScroll" style="display: inline-block;" tabindex="0"> <DIV id="__popup54-helpContent" data-sap-ui-preserve="__popup54-helpContent" data-sap-ui="__popup54-helpContent"> <SECTION class="xis-topicContent"> <DIV class="xis-paragraph">To create a calculated column, enter a DATA step expression in the <SPAN class="xis-windowItem">Expression</SPAN> field. A few considerations: <DIV class="xis-listUnordered"> <UL> <LI class="xis-item">Do not include the name of the table, semicolons, or the <SPAN class="xis-windowItem">column=</SPAN> statement in the expression. They are implicitly added for you.</LI> <LI class="xis-item">Enter a single value or single expression only. Do not enter conditional values.</LI> </UL> </DIV> </DIV> <P class="xis-paragraph">For more information about creating calculated columns, <SPAN class="xis-xrefSee"><SPAN class="xis-xrefText">see </SPAN><A href="http://documentation.sas.com/?softwareId=DMDPSTU&amp;softwareVersion=2.5&amp;requestor=inapp&amp;locale=en&amp;docsetId=datastudioadv&amp;docsetTarget=n1804pdfa1izx0n13q052py8d5n8" target="_blank" rel="noopener" data-help-docset="datastudioadv" data-help-topic="n1804pdfa1izx0n13q052py8d5n8" data-help-pubcode="73598">Creating Calculated Columns</A> in <I>SAS Data Studio: User’s Guide</I><SPAN class="xis-xrefText">."</SPAN></SPAN></P> <P class="xis-paragraph">&nbsp;</P> <P class="xis-paragraph"><SPAN class="xis-xrefSee"><SPAN class="xis-xrefText">That being said, INTCK should work.</SPAN></SPAN></P> <P class="xis-paragraph"><SPAN class="xis-xrefSee"><SPAN class="xis-xrefText">If wish to do conditional processing, use IFC/IFN functions rather than the corresponding statements.</SPAN></SPAN></P> <span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="LinusH_0-1696939718323.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/88739i3F708EE3BA40B8A4/image-size/medium?v=v2&amp;px=400" role="button" title="LinusH_0-1696939718323.png" alt="LinusH_0-1696939718323.png" /></span> <P>&nbsp;</P> </SECTION> </DIV> </DIV> </DIV> Tue, 10 Oct 2023 12:08:56 GMT https://communities.sas.com/t5/SAS-Programming/Calculated-columns-in-SAS-Data-Studio/m-p/897942#M354911 LinusH 2023-10-10T12:08:56Z https://communities.sas.com/t5/SAS-Programming/Calculated-columns-in-SAS-Data-Studio/m-p/897978#M354923 <P>Perhaps this is an actual use case for the IFN() or IFC() functions that SAS added a few years ago?</P> Tue, 10 Oct 2023 15:42:24 GMT https://communities.sas.com/t5/SAS-Programming/Calculated-columns-in-SAS-Data-Studio/m-p/897978#M354923 Tom 2023-10-10T15:42:24Z