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?

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
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
  • 905 views
  • 0 likes
  • 2 in conversation