How to select Observations which is not null or empty in SAS Enterprise Guide

[Nancy05]

Hi ,

I am new to SAS Enterprise Guid. How do I write the data clause as I only want the data set where particalar observations is not null or empty.

For example:

data mydataset;

   set orion.employee;

  where <employeeName is not empty or blank>?

proc print data = mydataset;

run;

How do I write empoyeeName is not empty? what is the syntaxt for not empty for blank in SAS langauge?

Thanks!

Nancy

[Reeza]

Where not missing(variable);

SAS treats null and blanks/missing the same in most cases. 

[Nancy05]

Hi Reeze,

Thanks for the reply.

Where not missing(variable); 

does seems work; However,

Where variable ne ' ';

works.

Thank you anyway!

Nancy

[Reeza]

Yes it will, for character variables. 

For numeric you use

where variable ne .;

Not Missing works for either character or numeric. 

[Nancy05]

How about Date type variable?

[Reeza]

SAS only has two data types, numeric and character.

Dates are numeric, with a date format applied.

A date is the number of days from Jan 1, 1960

A datetime is the number of seconds from Jan 1, 1960

Hope that helps.

There can be more data types if you're using DS2 but I'm assuming that you're not. And they only exist within the DS2 step.

[Nancy05 · Accepted solution]

Okay. Thank you for your reply!