Help using Base SAS procedures

What does .N and .E do?

Reply
N/A
Posts: 0

What does .N and .E do?

Hi, I have pasted a small piece of SAS code below. Can someone please tell me what is the meaning of .N and .E. What they return/do?


case when cms.NEXT_PMT_DUE_DT is not null
then DATEPART(cms.NEXT_PMT_DUE_DT)
when cms.NEXT_PMT_DUE_DT is null
then .N
else .E
end
Regular Contributor
Posts: 165

Re: What does .N and .E do?

Posted in reply to deleted_user
Those are missing numeric values. Besides using "." you can also use .A through .Z and ._ . This is helpful when you want to keep track of different reasons why a value is missing.
N/A
Posts: 0

Re: What does .N and .E do?

Thanks a lot Rick. Appreciate your help Smiley Happy
N/A
Posts: 0

Re: What does .N and .E do?

Rick,

Can you tell me how missing is different than NULL ?

Thanks in advance.
Super Contributor
Super Contributor
Posts: 3,174

Re: What does .N and .E do?

Posted in reply to deleted_user
Suggested reading on SAS PROC SQL and MISSING / NULL condition - link below.

Scott Barry
SBBWorks, Inc.


http://support.sas.com/documentation/cdl/en/sqlproc/62086/HTML/default/a001409512.htm

Suggested Google advanced search argument, this topic/post:

proc sql missing value null site:sas.com
N/A
Posts: 0

Re: What does .N and .E do?

Thanks Scott. Now, I am clear about the differences between NULL and MISSING.
Ask a Question
Discussion stats
  • 5 replies
  • 1065 views
  • 0 likes
  • 3 in conversation