https://communities.sas.com/t5/SAS-Visual-Analytics/How-to-Convert-Numeric-to-Character-in-Visual-Analytics-Prepare/m-p/393672#M8077 <P>Can I use this function in the graphical interrface?</P> Wed, 06 Sep 2017 18:47:03 GMT DavidPhillips2 2017-09-06T18:47:03Z https://communities.sas.com/t5/SAS-Visual-Analytics/How-to-Convert-Numeric-to-Character-in-Visual-Analytics-Prepare/m-p/393658#M8075 <P>I am trying to change the value type from numeric to character in Visual Analytics Prepare data tool.&nbsp; When I try to run the results</P><P>If I just change the type to character() the column shows up as a measure.</P><P>If I set a character format, I receive ERROR: Number expression requires a numeric format.</P> Wed, 06 Sep 2017 18:20:17 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/How-to-Convert-Numeric-to-Character-in-Visual-Analytics-Prepare/m-p/393658#M8075 DavidPhillips2 2017-09-06T18:20:17Z https://communities.sas.com/t5/SAS-Visual-Analytics/How-to-Convert-Numeric-to-Character-in-Visual-Analytics-Prepare/m-p/393670#M8076 <P>There's a function called 'Treat.AS' or something along those lines and that allows you to convert the type.</P> Wed, 06 Sep 2017 18:41:54 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/How-to-Convert-Numeric-to-Character-in-Visual-Analytics-Prepare/m-p/393670#M8076 Reeza 2017-09-06T18:41:54Z https://communities.sas.com/t5/SAS-Visual-Analytics/How-to-Convert-Numeric-to-Character-in-Visual-Analytics-Prepare/m-p/393672#M8077 <P>Can I use this function in the graphical interrface?</P> Wed, 06 Sep 2017 18:47:03 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/How-to-Convert-Numeric-to-Character-in-Visual-Analytics-Prepare/m-p/393672#M8077 DavidPhillips2 2017-09-06T18:47:03Z https://communities.sas.com/t5/SAS-Visual-Analytics/How-to-Convert-Numeric-to-Character-in-Visual-Analytics-Prepare/m-p/393675#M8078 <P>Where you drag and drop the formula's to create them? Yes, it needs to be nested inside the main function.&nbsp;</P> <P>&nbsp;</P> <P>This post has some pictures, if that helps:</P> <P><A href="https://communities.sas.com/t5/SAS-Communities-Library/3-FAQs-on-date-calculations-in-SAS-Visual-Analytics/ta-p/251260" target="_blank">https://communities.sas.com/t5/SAS-Communities-Library/3-FAQs-on-date-calculations-in-SAS-Visual-Analytics/ta-p/251260</A></P> Wed, 06 Sep 2017 18:51:02 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/How-to-Convert-Numeric-to-Character-in-Visual-Analytics-Prepare/m-p/393675#M8078 Reeza 2017-09-06T18:51:02Z https://communities.sas.com/t5/SAS-Visual-Analytics/How-to-Convert-Numeric-to-Character-in-Visual-Analytics-Prepare/m-p/421596#M8974 <P>The trick is in the Expression section, use the INPUT function. It is not shown on the drop down of available functions, but if you type it in will work and it will pass validation. As well as not require you to unlock the code.<BR /><BR />Parse and TreatAs are NOT available in the Data Preparation tool, those functions only work in Report Designer.</P> Fri, 15 Dec 2017 15:26:07 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/How-to-Convert-Numeric-to-Character-in-Visual-Analytics-Prepare/m-p/421596#M8974 IkeEisenhauer 2017-12-15T15:26:07Z https://communities.sas.com/t5/SAS-Visual-Analytics/How-to-Convert-Numeric-to-Character-in-Visual-Analytics-Prepare/m-p/421598#M8975 <P>They asked about Data Preparation tool. TreatAs does not work there, it won't pass validation. TreatAs is only available&nbsp;in Report Designer. You have to manually use INPUT</P> Fri, 15 Dec 2017 15:27:18 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/How-to-Convert-Numeric-to-Character-in-Visual-Analytics-Prepare/m-p/421598#M8975 IkeEisenhauer 2017-12-15T15:27:18Z https://communities.sas.com/t5/SAS-Visual-Analytics/How-to-Convert-Numeric-to-Character-in-Visual-Analytics-Prepare/m-p/874668#M17186 <P>I have a numeric field that I want to display as a 7 character field and this worked for formatting directly in SAS Visual Analytics:&nbsp; (in text field of calculated item):&nbsp;<BR /><BR /></P><P>Format('Variable Name'n[Raw], 'Z7.')</P> Tue, 09 May 2023 14:30:20 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/How-to-Convert-Numeric-to-Character-in-Visual-Analytics-Prepare/m-p/874668#M17186 CarolynSch 2023-05-09T14:30:20Z