https://communities.sas.com/t5/New-SAS-User/how-to-create-a-new-column-with-a-formula-under-square-root/m-p/844409#M36685 <P>SAS has a SQRT() function.</P> <PRE><CODE class=" language-sas">new_column = sqrt(var1 * (1-var1) / conteggio_rapport);</CODE></PRE> <P>Or you can just raise the value to the 0.5 power.</P> <PRE><CODE class=" language-sas">new_column = (var1 * (1-var1) / conteggio_rapport) ** 0.5 ;</CODE></PRE> Tue, 15 Nov 2022 16:08:13 GMT Tom 2022-11-15T16:08:13Z https://communities.sas.com/t5/New-SAS-User/how-to-create-a-new-column-with-a-formula-under-square-root/m-p/844407#M36684 <P>Hi. I need to create a new column which is the result of a calculation. Specifically i need the new column to be the square root of ((1-var1)/var2). How can I include square root in sas? this is the code i would use but i do not know how to include square root</P><PRE><CODE class="">data output_datase; set input_dataset; new_column = var1 * (1-var1) / conteggio_rapport; run;</CODE></PRE><P>the square root has to involve the whole formula. thanks for help</P><P>&nbsp;</P> Tue, 15 Nov 2022 15:58:45 GMT https://communities.sas.com/t5/New-SAS-User/how-to-create-a-new-column-with-a-formula-under-square-root/m-p/844407#M36684 ari2495 2022-11-15T15:58:45Z https://communities.sas.com/t5/New-SAS-User/how-to-create-a-new-column-with-a-formula-under-square-root/m-p/844409#M36685 <P>SAS has a SQRT() function.</P> <PRE><CODE class=" language-sas">new_column = sqrt(var1 * (1-var1) / conteggio_rapport);</CODE></PRE> <P>Or you can just raise the value to the 0.5 power.</P> <PRE><CODE class=" language-sas">new_column = (var1 * (1-var1) / conteggio_rapport) ** 0.5 ;</CODE></PRE> Tue, 15 Nov 2022 16:08:13 GMT https://communities.sas.com/t5/New-SAS-User/how-to-create-a-new-column-with-a-formula-under-square-root/m-p/844409#M36685 Tom 2022-11-15T16:08:13Z