https://communities.sas.com/t5/SAS-Data-Science/How-to-standardize-or-normalize-data-in-sas-viya/m-p/684017#M8424 <P>There are a few ways to standardize/normalize your data.&nbsp;</P> <P><BR />First, you can use the "Prepare Data" interface where you can find options for removing white spaces, applying formats, splitting column, parsing data, extracting fields and more. (See here&nbsp;<A href="https://go.documentation.sas.com/?cdcId=dprepcdc&amp;cdcVersion=2.5&amp;docsetId=datastudioadv&amp;docsetTarget=p1fpmxeffyb0s1n12lr5a39dhrxc.htm&amp;locale=en">https://go.documentation.sas.com/?cdcId=dprepcdc&amp;cdcVersion=2.5&amp;docsetId=datastudioadv&amp;docsetTarget=p1fpmxeffyb0s1n12lr5a39dhrxc.htm&amp;locale=en</A>&nbsp;and here&nbsp;<A href="https://go.documentation.sas.com/?cdcId=dprepcdc&amp;cdcVersion=2.5&amp;docsetId=datastudioadv&amp;docsetTarget=p0zfkkr3scuoxpn1cv55jdd5auel.htm&amp;locale=en">https://go.documentation.sas.com/?cdcId=dprepcdc&amp;cdcVersion=2.5&amp;docsetId=datastudioadv&amp;docsetTarget=p0zfkkr3scuoxpn1cv55jdd5auel.htm&amp;locale=en</A>).&nbsp;</P> <P>&nbsp;</P> <P>If you prefer to work with SAS code, you can use the "Develop SAS Code" interface and use DATA steps or actions and procs.&nbsp;</P> Tue, 15 Sep 2020 18:15:28 GMT SophiaRowland 2020-09-15T18:15:28Z https://communities.sas.com/t5/SAS-Data-Science/How-to-standardize-or-normalize-data-in-sas-viya/m-p/683774#M8421 I want to standardize or normalize one or multiple columns in data in sas viya interface. How can I achieve this? Mon, 14 Sep 2020 20:15:55 GMT https://communities.sas.com/t5/SAS-Data-Science/How-to-standardize-or-normalize-data-in-sas-viya/m-p/683774#M8421 Saurabh_Rana 2020-09-14T20:15:55Z https://communities.sas.com/t5/SAS-Data-Science/How-to-standardize-or-normalize-data-in-sas-viya/m-p/684017#M8424 <P>There are a few ways to standardize/normalize your data.&nbsp;</P> <P><BR />First, you can use the "Prepare Data" interface where you can find options for removing white spaces, applying formats, splitting column, parsing data, extracting fields and more. (See here&nbsp;<A href="https://go.documentation.sas.com/?cdcId=dprepcdc&amp;cdcVersion=2.5&amp;docsetId=datastudioadv&amp;docsetTarget=p1fpmxeffyb0s1n12lr5a39dhrxc.htm&amp;locale=en">https://go.documentation.sas.com/?cdcId=dprepcdc&amp;cdcVersion=2.5&amp;docsetId=datastudioadv&amp;docsetTarget=p1fpmxeffyb0s1n12lr5a39dhrxc.htm&amp;locale=en</A>&nbsp;and here&nbsp;<A href="https://go.documentation.sas.com/?cdcId=dprepcdc&amp;cdcVersion=2.5&amp;docsetId=datastudioadv&amp;docsetTarget=p0zfkkr3scuoxpn1cv55jdd5auel.htm&amp;locale=en">https://go.documentation.sas.com/?cdcId=dprepcdc&amp;cdcVersion=2.5&amp;docsetId=datastudioadv&amp;docsetTarget=p0zfkkr3scuoxpn1cv55jdd5auel.htm&amp;locale=en</A>).&nbsp;</P> <P>&nbsp;</P> <P>If you prefer to work with SAS code, you can use the "Develop SAS Code" interface and use DATA steps or actions and procs.&nbsp;</P> Tue, 15 Sep 2020 18:15:28 GMT https://communities.sas.com/t5/SAS-Data-Science/How-to-standardize-or-normalize-data-in-sas-viya/m-p/684017#M8424 SophiaRowland 2020-09-15T18:15:28Z