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?

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

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
  • 1221 views
  • 0 likes
  • 2 in conversation