topic Re: How to select Observations which is not null or empty in SAS Enterprise Guide in SAS Programming

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

Nancy05 — Wed, 22 Jun 2016 22:59:28 GMT

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 — Thu, 23 Jun 2016 01:51:17 GMT

Where not missing(variable);

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

Nancy05 — Thu, 23 Jun 2016 02:08:46 GMT

Hi Reeze,

Thanks for the reply.

Where not missing(variable);

does seems work; However,

Where variable ne ' ';

works.

Thank you anyway!

Nancy

Reeza — Thu, 23 Jun 2016 02:38:33 GMT

Yes it will, for character variables.

For numeric you use

where variable ne .;

Not Missing works for either character or numeric.

Nancy05 — Thu, 23 Jun 2016 03:18:49 GMT

How about Date type variable?

Reeza — Thu, 23 Jun 2016 06:54:35 GMT

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 — Fri, 24 Jun 2016 03:24:34 GMT

Okay. Thank you for your reply!