BookmarkSubscribeRSS Feed
deleted_user
Not applicable
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
5 REPLIES 5
RickM
Fluorite | Level 6
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.
deleted_user
Not applicable
Thanks a lot Rick. Appreciate your help 🙂
deleted_user
Not applicable
Rick,

Can you tell me how missing is different than NULL ?

Thanks in advance.
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
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
deleted_user
Not applicable
Thanks Scott. Now, I am clear about the differences between NULL and MISSING.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 5 replies
  • 3704 views
  • 0 likes
  • 3 in conversation