06-22-2016 06:59 PM
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.
where <employeeName is not empty or blank>?
proc print data = mydataset;
How do I write empoyeeName is not empty? what is the syntaxt for not empty for blank in SAS langauge?
06-22-2016 10:08 PM
Thanks for the reply.
Where not missing(variable);
does seems work; However,
Where variable ne ' ';
Thank you anyway!
06-22-2016 10:38 PM
Yes it will, for character variables.
For numeric you use
where variable ne .;
Not Missing works for either character or numeric.
06-23-2016 02:54 AM
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.
Need further help from the community? Please ask a new question.