https://communities.sas.com/t5/SAS-Data-Management/How-to-use-Data-Validation-Node-for-Blanks-amp-Null-Values-Data/m-p/275597#M7735 <P>Hi,</P><P>&nbsp;</P><P>I am facing few difficulties, while validating null values in a field which is <STRONG>Alphanumaric</STRONG> field type &amp; no result found in report. please guide me how to use the node for validating the NULL or Blank Value In the row.</P><P>&nbsp;</P><P>Which Node should I use for replace the Null and Blank values with any?</P><P>&nbsp;</P><P>Please refer the attached snapshort.</P><P>&nbsp;</P><P>Thank You.</P><P>&nbsp;</P><BR /><IMG src="https://communities.sas.com/t5/image/serverpage/image-id/12638iAE906B079C52F102/image-size/large?v=1.0&amp;px=600" border="0" alt="How to use Data Validation Node for Blanks &amp; Null Values - Data Flux.png" title="How to use Data Validation Node for Blanks &amp; Null Values - Data Flux.png" /> Tue, 07 Jun 2016 08:55:57 GMT manshreep_sas 2016-06-07T08:55:57Z https://communities.sas.com/t5/SAS-Data-Management/How-to-use-Data-Validation-Node-for-Blanks-amp-Null-Values-Data/m-p/275597#M7735 <P>Hi,</P><P>&nbsp;</P><P>I am facing few difficulties, while validating null values in a field which is <STRONG>Alphanumaric</STRONG> field type &amp; no result found in report. please guide me how to use the node for validating the NULL or Blank Value In the row.</P><P>&nbsp;</P><P>Which Node should I use for replace the Null and Blank values with any?</P><P>&nbsp;</P><P>Please refer the attached snapshort.</P><P>&nbsp;</P><P>Thank You.</P><P>&nbsp;</P><BR /><IMG src="https://communities.sas.com/t5/image/serverpage/image-id/12638iAE906B079C52F102/image-size/large?v=1.0&amp;px=600" border="0" alt="How to use Data Validation Node for Blanks &amp; Null Values - Data Flux.png" title="How to use Data Validation Node for Blanks &amp; Null Values - Data Flux.png" /> Tue, 07 Jun 2016 08:55:57 GMT https://communities.sas.com/t5/SAS-Data-Management/How-to-use-Data-Validation-Node-for-Blanks-amp-Null-Values-Data/m-p/275597#M7735 manshreep_sas 2016-06-07T08:55:57Z https://communities.sas.com/t5/SAS-Data-Management/How-to-use-Data-Validation-Node-for-Blanks-amp-Null-Values-Data/m-p/277608#M7847 <P>Assuming you are either building business rules or writing expression code to evaluate null/blank conditions, have you tried using the isnull() or the isblank() functions?</P> Wed, 15 Jun 2016 16:33:12 GMT https://communities.sas.com/t5/SAS-Data-Management/How-to-use-Data-Validation-Node-for-Blanks-amp-Null-Values-Data/m-p/277608#M7847 RonAgresta 2016-06-15T16:33:12Z