how to find out if several fields are empty ?

[shikoulitz]

Hi all,

Is there a way to concatenate several fields, and if they are empty have length = 0 or nulls?

I am trying to execute the following and always comes back with length of 1, even though fields are empty..

ALLVARS = LENGTH(COMPRESS(CATS(FIELD1,FIELD2,FIELD3,DATE1,DATE2),'00'X));

the compress is there because sometimes I have binary zeroes on the dates.

I just want to execute a process in case the fields have values and another one if they don't.

how can I solve it?

Thanks

Miguel

[shikoulitz]

forgot to say, all  the fields are defined as characters.

It always comes back with a length of 1...

Not understanding why is that..

Thanks

[Haikuo · Accepted solution]

Try LENGTHN().

And here is why:

SAS(R) 9.3 Functions and CALL Routines: Reference

[PGStats]

Try

CMISS(FIELD1,FIELD2,FIELD3,DATE1,DATE2) = 5;

to check if all values are missing.

PG

[shikoulitz]

Thanks PGStats,

I wasn't even aware this functions existed. :smileylaugh: