topic Re: how to find out if several fields are empty ? in SAS Programming

how to find out if several fields are empty ?

shikoulitz — Fri, 31 Oct 2014 21:39:40 GMT

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 — Fri, 31 Oct 2014 21:45:35 GMT

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 — Fri, 31 Oct 2014 22:21:02 GMT

Try LENGTHN().

And here is why:

PGStats — Sat, 01 Nov 2014 00:32:44 GMT

Try

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

to check if all values are missing.

shikoulitz — Mon, 03 Nov 2014 05:08:43 GMT

Thanks PGStats,

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