BookmarkSubscribeRSS Feed
manshreep_sas
Calcite | Level 5

Hi,

 

I am facing few difficulties, while validating null values in a field which is Alphanumaric field type & no result found in report. please guide me how to use the node for validating the NULL or Blank Value In the row.

 

Which Node should I use for replace the Null and Blank values with any?

 

Please refer the attached snapshort.

 

Thank You.

 


How to use Data Validation Node for Blanks & Null Values  - Data Flux.png
1 REPLY 1
RonAgresta
SAS Employee

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?

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Register now

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 1280 views
  • 0 likes
  • 2 in conversation