DATA Step, Macro, Functions and more

How to make comparison with date

Reply
Occasional Contributor
Posts: 16

How to make comparison with date

Not sure if this is the correct sub forum? Hopefully someone can redirect me if I'm on the wrong one.

 

 

Bascially I want to know how to subset a dataset to only the records dates before 07May2017 (in that exact format). How do I do this? Is there some website where I can find documentation on this? The data type of the field is date. thanks in advance!

PROC Star
Posts: 1,831

Re: How to make comparison with date

[ Edited ]
Posted in reply to toesockshoe

data want;

set have;

where date<'07May2017'd;

run;

 

assumption: your dates are sas date numeric variable

Super User
Posts: 10,278

Re: How to make comparison with date

Posted in reply to toesockshoe

I recommend reading this paper: https://support.sas.com/resources/papers/proceedings15/1334-2015.pdf. It has everything a beginner needs to know about SAS dates, and then some.

PS it is the second result of a google search for "sas 9.4 date and time values". See Maxim 6.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Ask a Question
Discussion stats
  • 2 replies
  • 76 views
  • 0 likes
  • 3 in conversation