topic Validation on column values. in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/Validation-on-column-values/m-p/132620#M10762 <HTML><HEAD></HEAD><BODY><P><BR />Hi,</P><P></P><P>I am trying to create a template in which I will be creating 2-3 data sets. some of the fields in the data set are set in such a way that user can enter the values.I want a validation to check if user enters only numeric or null values.</P><P></P><P>The character values are not allowed.</P><P></P><P>can any one suggest me a way to achieve that.</P><P></P><P>Thanks in advance,</P></BODY></HTML> Wed, 08 May 2013 17:16:45 GMT Sheeba 2013-05-08T17:16:45Z Validation on column values. https://communities.sas.com/t5/SAS-Enterprise-Guide/Validation-on-column-values/m-p/132620#M10762 <HTML><HEAD></HEAD><BODY><P><BR />Hi,</P><P></P><P>I am trying to create a template in which I will be creating 2-3 data sets. some of the fields in the data set are set in such a way that user can enter the values.I want a validation to check if user enters only numeric or null values.</P><P></P><P>The character values are not allowed.</P><P></P><P>can any one suggest me a way to achieve that.</P><P></P><P>Thanks in advance,</P></BODY></HTML> Wed, 08 May 2013 17:16:45 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Validation-on-column-values/m-p/132620#M10762 Sheeba 2013-05-08T17:16:45Z Re: Validation on column values. https://communities.sas.com/t5/SAS-Enterprise-Guide/Validation-on-column-values/m-p/132621#M10763 <HTML><HEAD></HEAD><BODY><P> " user can enter the values", if you are talking about Prompts, then yes, you can set it to accept "Numeric" value only. More details will be needed.</P><P></P><P>Haikuo </P></BODY></HTML> Wed, 08 May 2013 18:08:50 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Validation-on-column-values/m-p/132621#M10763 Haikuo 2013-05-08T18:08:50Z Re: Validation on column values. https://communities.sas.com/t5/SAS-Enterprise-Guide/Validation-on-column-values/m-p/132622#M10764 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Thank you for the reply.</P><P></P><P>user would be opening the data set and entering the values. I believe that defining them as numeric would solve this problem</P></BODY></HTML> Wed, 08 May 2013 18:14:19 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Validation-on-column-values/m-p/132622#M10764 Sheeba 2013-05-08T18:14:19Z